If you are V8.2 then the db was created with an Event Monitor that monitors
deadlocks.
It is AUTOSTART=YESso it has been on since the db was created and became
active.
You can investigate its contents by using DB2EVMON command on the files
contained in your database path which ends with SQL0000n.
Hope this helps, Pierre.



-----Message d'origine-----
De : RAJESH CHANDRAMOHAN
[mailto:db2udbdba-ezmlmshield-x1929472.[Email address protected]
Envoyé : 29 mai, 2007 05:59
À : LazyDBA Discussion
Objet : RE: To avoid Deadlock


Hi,

If you know which query is causing this, then its well and fine.
If not create an event monitor for deadlocks and resolve it with the
output.

Meanwhile, reason code "2" is deadlock and not timeout.
Try to update the query using cursor with the help of procedure.
Check indexes are proper for the queries also.
Try "WITH UR" keyword for selecting the table records while updating.

Regards
Rajesh

-----Original Message-----
From: SangeethaPriya R.
[mailto:db2udbdba-ezmlmshield-x47087410.[Email address protected]
Sent: Monday, May 28, 2007 2:42 AM
To: LazyDBA Discussion
Subject: 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.




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - -

This message is intended only for the personal and confidential use of the
designated recipient(s) named above. If you are not the intended recipient
of this message you are hereby notified that any review, dissemination,
distribution or copying of this message is strictly prohibited. This
communication is for information purposes only and should not be regarded as
an offer to sell or as a solicitation of an offer to buy any financial
product, an official confirmation of any transaction, or as an official
statement of Lehman Brothers. Email transmission cannot be guaranteed to be
secure or error-free. Therefore, we do not represent that this information
is complete or accurate and it should not be relied upon as such. All
information is subject to change without notice.

--------
IRS Circular 230 Disclosure:
Please be advised that any discussion of U.S. tax matters contained within
this communication (including any attachments) is not intended or written to
be used and cannot be used for the purpose of (i) avoiding U.S. tax related
penalties or (ii) promoting, marketing or recommending to another party any
transaction or matter addressed herein.




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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