DB2 Version 9.7 for Linux, UNIX, and Windows

dl_conns - Connections involved in deadlock monitor element

The number of connections that are involved in the deadlock.

Table 1. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	-	-
Deadlocks¹	event_deadlock	-

1: This option has been deprecated. Its use is no longer recommended and might be removed in a future release. Use the CREATE EVENT MONITOR FOR LOCKING statement to monitor lock-related events, such as lock timeouts, lock waits, and deadlocks.

Usage

Use this element in your monitoring application to identify how many deadlock connection event records will follow in the event monitor data stream.