Tuesday, June 18, 2013

1 How to check the db2 version

There are few ways to check db2 edition and installed features.

DB2licm

db2licm is the db2 license manager program

image

image

db2level

db2level

image

db2ls

db2ls
 db2ls -q -a -b /opt/ibm/db2/V10.1

image

DB2 Environment view: SYSIBMADM

Above DB2 command can only works if you are on the db2 host. To get the information from remote, we have to use the SYSIBMADM view.

SELECT *   FROM SYSIBMADM.ENV_INST_INFO;
 
SELECT *   FROM SYSIBMADM.ENV_FEATURE_INFO;
 
SELECT *   FROM SYSIBMADM.ENV_PROD_INFO;

image

1 comments:

  1. Thank you very much.....very useful for newbies like me :)

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates