DB2 – verify DB2 is available

This article describes some methods of checking DB2 is running on a Linux Server

 Method 1

Log onto the server and execute db2start  as the instance owner. If the instance is running you’ll see , something like:

02/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. This lists all TCP/IP connections. Look for the instance names or the ports , such as :

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   Feb01  24:49 db2sysc 0     

db2dba  13823  0.0  0.9 1858144 279532 ?      Sl   Feb01   9:09 db2sysc 0

See Also

db2start at start up on Linux