Need process to find locks and timeouts in a DB2 database rc=-911

Posted on 2013-10-10
Medium Priority
Last Modified: 2013-10-18
Our application periodically fails with what appears to be a lock time out, rc=-911.

How would I go about monitoring for locks? This happens late at night when the scheduled processes run and so its hard to catch it in the act.

This is DB2 V9.7 on AIX 7. LOCKTIMEOUT is set to 60.

I have the monitor switches enabled and have a script to take snapshots during the time when the process runs. But i haven't been able to get the information.

I'm wondering about setting the event monitor for LOCKEVMON. I'm not very familiar with setting up event monitors, how to enable/disable them or how to gather the information and generate readable reports from it.

Any help would be appreciated.

Question by:data_bits
1 Comment

Accepted Solution

mustaccio earned 1500 total points
ID: 39574328
Firstly, SQLCODE -911 may mean either a lock timeout or a deadlock; the actual event is indicated by the additional reason code value. You can check db2diag.log -- deadlocks would appear there as well.

The procedure for setting up a lock event monitor and generating a report is described in the manual in great detail: http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.mon.doc/doc/t0055093.html

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question