To avoid Deadlock

To avoid Deadlock

 

  

Hi,

We are facing Transaction Timeout problem while we simaltaneously update
and select rows from the same table.

I need some information reg. Tables with exclusive mode.Is it possible
to solve this problem by using Exclusive lock to that table.

Error:

SQL0911N. The current transaction has rolled back because of a deadlock
or timeout. Reason code "2"

Thanks in Advance,

Best Regards,
Sangeetha Priya R.



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