CODEWITHSUNDEEP
sqldb2
Kamal Joshi
Kamal Joshi

Reputation: 1777

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

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?

Upvotes: 12

Views: 79610

Answers (4)

Amrith Raj Herle
Amrith Raj Herle

Reputation: 875

Maybe you are searching for below query.

SELECT
    AUTHID,
    APPL_NAME,
    CLIENT_NNAME,
    AGENT_ID,
    APPL_ID,
    APPL_STATUS
FROM
    SYSIBMADM.APPLICATIONS

Upvotes: 3

Fuangwith S.
Fuangwith S.

Reputation: 5764

CLP:

db2 list applications

QUERY:

SELECT * FROM SYSIBM.APPLICATIONS
SELECT * FROM SYSIBM.SESSION

Upvotes: 6

Len
Len

Reputation:

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"

and

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

Upvotes: 11

Tamas Czinege
Tamas Czinege

Reputation: 121334

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.

Upvotes: 3

Related Questions