How to get all the transactions in db2?

[S***@infosys.com]

Hi all

How to get the list of all the tranactions or applications that are connected to the instance and how to know which application or tranaction connected to the database and who is running what?

In the application list it gives the application name as db2jcc_application.
can i know what is exact application which is connected.
And to force an application i need to give the application handle but i cant what is the application which is connected ie associated with the application handle or PID(because for all application or transaction. Is there any way resolve this issue.
HOW TO EXACTLY CORRELATE THE APPLICATION NAME WITH APPLICATION HANDLE AND THE USER WHO IS RUNNING THAT AND INFORMATION FOR WHERE HE IS RUNNING THE APPLICATION OR THE TRANSACTION

PLEASE REPLY IF ANYONE HAS AN IDEA
THANK YOU.

[Mark A]

Post by S***@infosys.com
Hi all
How to get the list of all the tranactions or applications that are
connected to the instance and how to know which application or tranaction
connected to the database and who is running what?
In the application list it gives the application name as
db2jcc_application.
can i know what is exact application which is connected.
And to force an application i need to give the application handle but i
cant what is the application which is connected ie associated with the
application handle or PID(because for all application or transaction. Is
there any way resolve this issue.
HOW TO EXACTLY CORRELATE THE APPLICATION NAME WITH APPLICATION HANDLE AND
THE USER WHO IS RUNNING THAT AND INFORMATION FOR WHERE HE IS RUNNING THE
APPLICATION OR THE TRANSACTION
PLEASE REPLY IF ANYONE HAS AN IDEA
THANK YOU.

The ip address of the client is shown in hex (in pairs without a decimal)
when you do a list applications show detail. If the first character is a "G"
convert it to a zero, H=1,I=2, etc). The userid is also shown.

If you want more detail, you can do a snapshot for locks and see which
application handle is holding which locks (and what tables the locks are
held on). Other snapshots may provide additional clues.