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 SkipVought 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
0
0
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

Thomas B
  • Locked
  • Question
"BMC AMI Ops Monitor for Db2" (mvmon) trace for prepared statements (from Java)
Replies
0
Views
53
Thomas B
Thomas B
P
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
108
prashant_0701
P
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
46
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
122
ANGELDANY
ANGELDANY
usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
44
usr1234
usr1234

Part and Inventory Search

Sponsor

Back
Top