Need process to find locks and timeouts in a DB2 database rc=-911
Posted on 2013-10-10
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.