How to find out the SQL statements causing deadlock?

dnlchou · #1 (**permalink**) 10-24-03, 11:42

Hello,

We are runnig DB2 on AIX and have DB2 deadlock problem.
Is there any way or any tool to find out which SQL statements cause the deadlock?

Thanks a lot.

sathyaram_s · #2 (**permalink**) 10-24-03, 11:44

If you have taken a moment to search for the word deadlock in the forum, you would have come across many threads with the information you want .... The most recent one is

Deadlock Problem

Cheers
Sathyaram

Quote:

Originally posted by dnlchou
Hello,

We are runnig DB2 on AIX and have DB2 deadlock problem.
Is there any way or any tool to find out which SQL statements cause the deadlock?

Thanks a lot.

Internet Services

Web Development

Digital Marketing

Consumer Tech