We have moved to www.dataGenX.net, Keep Learning with us.

Monday, June 24, 2013

Get DB2 Version

Method #1. Connect to the database from the command line


Method #2. Retrieve the version from the system table:

db2 "select * from SYSIBM.SYSVERSIONS"

Method #3. The Database Manager snapshot

db2 get snapshot for dbm | grep -P "(Product name|Service level)" 


Method #4. Get the version directly using the 'db2level' command:
     This will give the version of local DB or DB2 Client installed on same server where you are checking