do a get snapshot for locks on xxxxx where xxxxx is your database

You have applications that are written such that they are locking each
other out,






"Avudaiappan
Jeyapaul"
<[Email address protected] To
v.za> <[Email address protected]
cc
01/23/2006 04:25
AM Subject
DeadLock










Dear All,

My production server is running on DB2UDB 8.2 running under SuSe Linux 9.0
on mainframe z series

It was working fine, from last week onwards i am getting a error message
frequently for couple of
transactions.

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

Can you please advice me about the above.





Thanks and Regards
Avu




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