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