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!

Register Log in
  • Congratulations Chris Miller 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

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.

Similar threads

C
  • Question
Conditionally have a subfile display record blink
Replies
2
Views
163
mikrom
mikrom
Thomas B
  • Locked
  • Question
"BMC AMI Ops Monitor for Db2" (mvmon) trace for prepared statements (from Java)
Replies
0
Views
143
Thomas B
Thomas B
P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
343
prashant_0701
P
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
155
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
340
ANGELDANY
ANGELDANY

Part and Inventory Search

Sponsor

Back
Top