Thursday, 5 April 2012

How to see if an instance of DB2 is already running in your machine

bash-3.00$ netstat  -an | grep 50000
bash-3.00$ ps   -eaf |  grep db2
bash-3.00$ ps   -eaf |  grep db2sysc 

Points to note:

1.db2 database owner is same as the instance owner created by using db2icrt command.
2.If the instance speficied is not identified then use following command:
/opt/IBM/db2/V9.7/instance/db2iupdt   < instance name> 

3.If the communication error occurs duing stop or start  or tcp/ip error.

check whether hostname is consistant in  /etc/hosts file, $DB2InstanceHome/sqllib/db2nodes.cfg
and with the hostname command.

No comments:

Post a Comment

Tweets by @sriramperumalla