How to find all open/active connections in DB2 (8.x)

Question

I'm currently working with Db2 Enterprise Server V 8.2 with FixPak 10

And I want to retrieve list of all the open active connections with an instance.

In Oracle there is a utility program called "Top Session" which does the similar task. Is there any equivalent in DB2?

Thanks in advance, Kamal

Answer 1

The command you seek is:

LIST APPLICATIONS

In the DB2 Command Center there is a tool which list the applications and displays them in a human friendly format as well.

Answer 2

CLP

-> db2 list applications

QUERY

-> SELECT * FROM SYSIBM.APPLICATIONS

-> SELECT * FROM SYSIBM.SESSION

Answer 3

To get more detailed information from list applications:

db2 list applications for database {dbName} show detail

For applications with lots of active connections it is useful to pipe the results to grep to find only the threads currently executing or locked.

db2 list applications for database {dbName} show detail | grep -i "executing"

db2 list applications for database {dbName} show detail | grep -i "lock"