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..
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..