Link to home
Start Free TrialLog in
Avatar of data_bits
data_bitsFlag for United States of America

asked on

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

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.

THanks!
ASKER CERTIFIED SOLUTION
Avatar of mustaccio
mustaccio
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial