All,
I understand that we cannot capture lock time out in db2diag.log with a
diaglevel of 3 and we do not want to pump it to 4.

Can we capture in real time basis the details of a lock time out ?
What I am looking for is:
1) capturing the tables involved in a lock time out
2) capturing the sqls involved in a lock time out
3) capturing the application that is responsible for the lock time out.

Please advise me on if you could implement your idea successfully.
I did go through lot of documents but nothing really was helpful.

Thanks.


DB2 & UDB email list listserv db2-l LazyDBA home page