Enhanced Deadlock Monitoring
With DB2 UDB v8.1, you have access to more information than in prior releases about deadlocks that occur in your database system. To collect detailed database system monitoring data about deadlocks as they occur, create and activate a DEADLOCKS WITH DETAILS event monitor. For example:
CREATE EVENT MONITOR dlmon FOR DEADLOCKS WITH DETAILS WRITE TO FILE 'C:\Temp\DeadLock' SET EVENT MONITOR dlmon STATE 1
DEADLOCKS WITH DETAILS event monitors collect comprehensive information regarding the applications involved, the participating statements (and statement text), and a list of locks being held.
Using a DEADLOCKS WITH DETAILS event monitor instead of a DEADLOCKS event monitor incurs a performance cost when deadlocks ...