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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial