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