Mr. Jagadeesh this error occurs when the users are simultanously are
working if you fire your commad then it get locked.
solution :
Try stop your database for 25-30 minutes.
then restart your db then fire your command
only thing is you have to wait for such time thats the main solution.
Best Regards
Praneeth Marpally
AE- IS Product Support
Regional IS, MESA
Direct : +971-04-4035-524
Mob : +971-050-2744543
"jagadeesh" <db2udbdba-ezmlmshield-x95985857.[Email address protected]
03/23/2006 12:33 PM
To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: Deadlock Error
Hi All,
I am getting the following error when trying to trigger a online
transaction which involves a jdbc query from AIX with db2 6.1 UDB.
ORIGINAL EXCEPTION :
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL0913N
Unsuccessful execution caused by deadlock or timeout. Reason code
"00C9008E". SQLSTATE=57033
But the same transaction executes well without any error when tried from
another AIX server with the same code and configuration.
Can anyone advice on this please ..Our DB Server is in z/OS and the
version is 7.2.
Regards
Jagadeesh Govindarajan
Tata Consultancy Services Limited
Mailto: jagadeesh.[Email address protected]
Website: http://www.tcs.com
Notice: The information contained in this e-mail message and/or
attachments to it may contain confidential or privileged information. If
you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this
e-mail message and/or attachments to it are strictly prohibited. If you
have received this communication in error, please notify us by reply
e-mail or telephone and immediately and permanently delete the message and
any attachments. Thank you
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not accept liability for damage caused by this email and may monitor email traffic.
This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not accept liability for damage caused by this email and may monitor email traffic.
DB2 & UDB email list listserv db2-l LazyDBA home page