IBM Support

[Db2] How to check Db2 version or registered edition.

Question & Answer


Question

How can I check Db2 version or registered edition?

Answer

You can display DB2 version by running db2level command and DB2 edition by db2licm -l.
In particular, you can check registered edition only by license information if you use DB2 V10.5 and later server
edition that is higher than or equal to Workgroup Server Edition.
Because they use a common installation image.

a)Linux and UNIX platform

1. Login to database server as instance owner.

2-1. Run db2level command if you want to check DB2 version.

e.g.:V11.5 GA
$ db2level
DB21085I  This instance or install (instance name, where applicable: "db2inst1")
uses "64" bits and DB2 code release "SQL10050" with level identifier "0601010F".
Informational tokens are "DB2 v11.5.0.0", "s1906101300", "DYN1906101300AMD64", and FixPack "0".
Product is installed at "/work/db2/V11.5".
2-2. Run db2licm -l command if you want to check registered edition.

e.g.:Advanced Enterprise Server Edition
$ db2licm -l
Product name:                     "DB2 Advanced Enterprise Server Edition"
License type:                     "CPU Option"
Expiry date:                      "Permanent"
Product identifier:               "db2aese"
Version information:              "11.5"
Enforcement policy:               "Soft Stop"
b)Windows platform

1. Logon to database server as administrator.

2. Open up [DB2 Command Window  -Administrator].

3-1. Run db2level command if you want to check DB2 version.

e.g.:V11.5 GA

C:\>db2level
DB21085I  This instance or install (instance name, where applicable: "DB2")
uses "64" bits and DB2 code release "SQL11050" with level identifier "0601010F".
Informational tokens are "DB2 v11.5.0.1007", "s1906101300", "DYN1906101300WIN64", and FixPack "0".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name"DB2COPY1".

3-2. Run db2licm -l command if you want to check registered edition.

e.g.:Advanced Enterprise Server Edition
C:\>db2licm -l
Product name:                     "DB2 Advanced Enterprise Server Edition"
License type:                     "CPU Option"
Expiry date:                      "Permanent"
Product identifier:               "db2aese"
Version information:              "11.5"
Enforcement policy:               "Soft Stop"
 
Operational Consideration 
Please register valid license by referring following technote.

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

Document Information

Modified date:
01 December 2020

UID

ibm11098609

Page Feedback