IBM Support

How to find what DB2 Product is installed on your machine?

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"

Related Information

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Instance","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;10.1;10.5","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21667518