Check applications running on the DB2

Checking how many applications are running on the DB2 and which they are

 

Steps to check how many applications are running at the DB2, which they are and if they are running OK

To check the number of current applications running under DB2, perform the following command:

db2 list active databases

It will show you an output just like that:

>db2 list active databases

                           Active Databases

Database name                         = DBASE2
Applications connected currently      = 1
Database path                         = /db2/dbdata/db2inst1/NODE0000/SQL00001/

You can also check the status of all running applications, performing:

db2 list applications show detail | grep -i executing

In case you need to check if your applications are in lock, perform:

db2 list applications show detail | grep -i lock

On AIX, we also can use the command wc (word count) to help us to count the lines from a result output, as following:

db2 list applications show detail | grep -i executing | wc -l

or

db2 list applications show detail | grep -i lock | wc -l