Retrieving Db2 version information

Edit online

The version of Db2 that is installed with the IBM Storage Protect server is updated periodically. If database problems occur, you must know the version of Db2 and its location so that you can provide this information to IBM® Software Support.

Procedure

Issue the db2level command to show where Db2 products are installed on your server, and to list the Db2 product level.

The following output shows sample results of the db2level command.

Linux operating systemsAIX operating systems
> db2level
DB21085I This instance or install (instance name, where applicable:
"cetinst1") uses "64" bits and Db2 code release "SQL10051" with level
identifier "0602010E".
Informational tokens are "DB2 v10.5.0.1", "special_31150", 
"IP23526_31150", and Fix Pack "1".
Product is installed at "/opt/tivoli/tsm/db2".
Windows operating systems
C:\>db2level
DB21085I  This instance or install (instance name, where applicable: "SERVER1")
uses "64" bits and Db2 code release "SQL10051" with level identifier
"0602010E".
Informational tokens are "DB2 v10.5.100.64", "special_31150",
 "IP23521_31155", and Fix Pack "1".
Product is installed at "C:\PROGRA~1\Tivoli\TSM\db2" with Db2 Copy Name
"DB2TSM1".