Question & Answer
Question
How to find detailed information about the DB2 product installed in your environment ?
Answer
db2ls command will display the db2level along with the install path and install date.
db2ls
Install Path Level Fix Pack Special Install Number Install Date Installer UID
--------------------------------------------------------------------------------------------
/opt/ibm/db2/V9.7 9.7.0.7 7 Thu Aug 1 12:25:53 2013 CDT 0
To determine the specific product installed:
db2ls -p -q -b <installpath>
Eg: db2ls -p -q -b /opt/ibm/db2/V9.7
Install Path : /opt/ibm/db2/V9.7
Product Response File ID Level Fix Pack Product Description
-------------------------------------------------------------------------------------------ENTERPRISE_SERVER_EDITION 9.7.0.7 7 DB2 Enterprise Server Edition
db2 get dbm cfg | head
- Eg: db2 get dbm cfg | head
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Database manager configuration release level = 0x0d00
CPU speed (millisec/instruction) (CPUSPEED) = 3.227686e-07
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02
db2licm -l
- Eg: db2licm -l
Product name: "DB2 Enterprise Server Edition"
License type: "CPU Option"
Expiry date: "Permanent"
Product identifier: "db2ese"
Version information: "9.7"
Enforcement policy: "Soft Stop"
Features:
DB2 Performance Optimization ESE: "Not licensed"
DB2 Storage Optimization: "Not licensed"
DB2 Advanced Access Control: "Not licensed"
IBM Homogeneous Replication ESE: "Not licensed"
Product name: "DB2 Connect Server"
Expiry date: "Expired"
Product identifier: "db2consv"
Version information: "9.7"
Concurrent connect user policy: "Disabled"
Enforcement policy: "Soft Stop"
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21667518