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 ...

Get DB2® Version 8: The Official Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.