Walker News

How To Check Which DB2 Edition And FixPak Level Is Installed?

Similar to most other enterprise software, IBM DB2 database system comes with few editions vary in term of supported features and cost or license fee.

If you are not the one who install the system, could you check or verify the DB2 edition, version number, as well as the Fix Pack level running in the system? The answer is of course, YES.

To what I know, there are at least two DB2 commands on Linux platform for gathering this kind of system profile information.

db2ls

The db2ls command is only available in DB2 version 9 or above and it is NOT applicable on Windows operating systems.

Some information, such as DB2 edition, returned by db2ls requires one to run this command in DB2 installation directory or specify the path using -b option switch.

In its simple form, execute db2ls in Linux command prompt returns the DB2 install path, DB2 version, Fix Pack level, and the DB2 installation date.

With reference to db2ls output, suppose the DB2 install path is /opt/ibm/db2/V9.1, then execute the following to get the DB2 Response File ID (DB2 product edition):
db2ls -q -p -b /opt/ibm/db2/V9.1

You may also run db2ls -q -a -b /opt/ibm/db2/V9.1 to check all DB2 components and features running in Linux system.

db2licm

The db2licm command available in DB2 version 8 (or below) as well as version 9. This command line version of DB2 License Manager allows DBA to add, remove, list, and modify DB2 license registered on the local system.

To find out DB2 edition running in Linux system, executes db2licm -l:
db2adm $ db2licm -l
Product name:                     "DB2 Express Edition"
License type:                     "CPU"
Expiry date:                      "Permanent"
Product identifier:               "db2exp"
Version information:              "9.1"
Max number of CPUs:               "2"
Annotation:                       "3;(_c)"
Features:
DB2 Performance Optimization Exp: "Not licensed"
DB2 High Availability Exp:        "Not licensed"
DB2 Workload Management Exp:      "Not licensed"
DB2 pureXML Exp:                  "Not licensed"
IBM Homogeneous Federation Exp:   "Not licensed"

Custom Search

2014  •  Privacy Policy