Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I have created an event monitor for

Status
Not open for further replies.

Prince26

Systems Engineer
May 17, 2019
8
IN
I have created an event monitor for locking in db2 as below:

CREATE EVENT MONITOR LOCKEVMON
FOR LOCKING
WRITE TO TABLE;

Below tables were created:
LOCK_LOCKEVMON
LOCK_PARTICIPANTS_LOCKEVMON
LOCK_PARTICIPANT_ACTIVITIES_LOCKEVMON
LOCK_ACTIVITY_VALUES_LOCKEVMON
CONTROL_LOCKEVMON

Please help me the fields to check for locks and deadlocks and to check the blocker and the one who was blocked..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top