How to solve dead lock

anandss6 · New User Joined: 12 Dec 2005 Posts: 7 Location: trivandrum

Hi,

If dead lock occurs how to resolve it? How can we know which transaction is using same table? can u please give me solution for the same.

martin9 · Posted: Tue Mar 14, 2006 4:50 pm Post subject:

hy s.anand,

look at the db2 logs to find out on which object
the deadlock occurred, then find out, who was
already on this object at the same time.

other possibility, you control it with the db2
performance monitor, or any other monitor
you have at your site...
just make sure to enable the history feature...

martin9

anandss6 · New User Joined: 12 Dec 2005 Posts: 7 Location: trivandrum

Thanks martin