DB2 - Drop the DB2DETAILDEADLOCK event monitor

27 August,2012 by Jack Vamvas

DB2DETAILDEADLOCK is created and activated by default  when a database is created.  When an activity activates the database the  monitor  starts up.  When a deadlock occurs the diagnostic information is collected.

There are circumstances where you need to either deactivate  or DROP the monitor. For example , there may be resource constraints

Deactivate the the event monitor 
db2 "set event monitor DB2DETAILDEADLOCK state 0"

 Drop the event monitor

db2 "drop event monitor DB2DETAILDEADLOCK"

 Related Posts

SQL0911N Reason Code 68 The current transaction has been rolled back because of a deadlock or timeout

How to monitor a deadlock in DB2

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 - Drop the DB2DETAILDEADLOCK event monitor

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright