Walker News

How To Check DB2 Edition and Fix Pack Level On Linux?

The dblicm -l is probably a simple and easy to remember DB2 command to take a glance of what DB2 edition is installed on Linux, license type and expiry date, maximum number of accessible memory and processor value unit (PVU) limited by license type.

However, db2licm doesn’t show Fix Pack level and it’s not able to tell whether it’s DB2 32-bit or 64-bit version:

db2licm

No worry, you can run db2level to check DB2 Fix Pack level, bitness (32-bit or 64-bit version of DB2) and install directory (where the DB2 binaries are installed).
[db2adm@localhost] db2level
DB21085I Instance "db2adm" uses "64" bits and DB2 code release "SQL09073" with level identifier "08040107". Informational tokens are "DB2 v9.7.0.3", "special_25384", "IP23099_25384", and Fix Pack "3". Product is installed at "/opt/ibm/db2/V9.7".

What about the DB2 install date? Well, just run db2ls -a if you want to check when the DB2 was installed (including DB2 Fix Pack). Besides, this command can also display the list of DB2 products and features installed on Linux (get DB2 install directory from db2level for the -b option):
db2ls -q -a -b /opt/ibm/db2/V9.7

db2ls

For those who prefer using SQL statement to retrieve DB2 production edition and license type, just connect to a database and run this SELECT statement:
SELECT * FROM SYSIBMADM.ENV_PROD_INFO

Custom Search

2016  •  Privacy Policy