IBM Support

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

Technote (FAQ)


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

db2ls
db2licm

Document information

More support for: DB2 for Linux, UNIX and Windows
Install/Migrate/Upgrade - Instance

Software version: 9.5, 9.7, 9.8, 10.1, 10.5

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: Advanced Enterprise Server, Advanced Workgroup Server, Enterprise Server, Workgroup Server

Reference #: 1667518

Modified date: 18 November 2015


Translate this page: