Hi Ado,
How did you conclude it's a Deadlock ????
Below error i.e sql911 with reason code 68 is for timeout...that just
means we had timeout trying to get hold of the databae objects.
Looksnormal for database. What you need to do is look if any other
process has any locks on the tales you are trying to use.
Db2 "get snapshot for locks on <Db_Name>"
Db2pd -db <DB_Name> -locks
In order to prevent this one try to have a code in your application that
should check for sql911 with 68..if you have timeout try after some time
.Thats simple and easy. Try to see the offecding process that acquire
lock at the time your production process is running.
---------------------------------------------------
Regards,
Vijay
-----Original Message-----
From: ado
[mailto:db2udbdba-ezmlmshield-x20324852.[Email address protected]
Sent: Friday, January 18, 2008 8:48 AM
To: LazyDBA Discussion
Subject: Severe Deadlock
Hi,
I received this error message:
DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68
I am having this depressed pressure, since it affects the company's
operations badly.
Do you know:
1. What this error means more than just a deadlock?
2. How to prevent this from happening again?
Thank you very much!
Ado
---------------------------------------------------------------------
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.
DB2 & UDB email list listserv db2-l LazyDBA home page