Hi Experts,

When i used db2pd i got the queries executed.How can i find the person or IP from which the statement is executed and when?

TIA

Statements in the dynamic cache can be potentially executed by many users, connecting from different IP addresses. To see who is _currently_ executing which statement, use db2pd -apinfo or the application snapshot.

Hi Nick,
Thanks for the reply. I didnt find db2pd -apinfo or application snapshot.

Please help

db2pd -d <db> -apinfo works for db2v9.5 FP1 and later.

I mostly use get snapshot for applications on <db>

or SYSIBMADM.SNAPAPPL_INFO

regards

DBFinder

Thanks DBFinder :-)