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

Tuesday, July 10, 2012

Verify DB2 is available or Not


In this post, telling you the 3 method to know if DB2 is available or not.

 

Method 1

Log onto the server and execute db2start as the instance owner. If the instance is running you’ll see , something like:
$ db2start
07/10/2012 23:36:14     0   0   SQL1026N  The database manager is already active.SQL1026N  The database manager is already active.

 

Method 2

Log onto the server a run a netstat –a/ NETSTAT -a. This lists all TCP/IP connections. Look for the instance names or the ports , such as :
$ netstat –a | grep –i db2
tcp        0      0 *:db2c_db2a               *:*                         LISTEN
tcp        0      0 *:db2c_db2b               *:*                         LISTEN
tcp        0      0 *:db2c_db2c               *:*                         LISTEN
tcp        0      0 *:db2c_db2d              *:*                         LISTEN
tcp        0      0 *:db2c_db2e              *:*                         LISTEN

Method 3

 On the Linux command line , issue the command :
 $ ps aux | less | grep 'db2sysc'
If you see similar to  this reponse – then the DB2 servers are running.
db2test   13474  0.1 11.3 8860292 3506408 ?     Sl   Jul07  24:49 db2sysc 0     
db2dba  13823  0.0  0.9 1858144 279532 ?      Sl   Jul07   9:09 db2sysc 0



njoy the simplicity.......
Atul Singh

No comments :

Post a Comment