Search dba-db2.com
*Use the Comments section for questions
Daily & Exclusive Content
Recent Posts
DB2 - Drop the DB2DETAILDEADLOCK event monitor
27 August,2012 by Tom Collins
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
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
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
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.
dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright
Posted by: |