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