DB2 Version 9.7 for Linux, UNIX, and Windows

deadlock_id - Deadlock Event Identifier monitor element

The deadlock identifier for a deadlock.

Element identifier
deadlock_id
Element type
information
Table 1. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Deadlocks event_deadlock -
Deadlocks event_dlconn -
Deadlocks with Details event_detailed_dlconn -
Deadlocks with Details History event_detailed_dlconn -
Deadlocks with Details History event_stmt_history -
Deadlocks with Details History Values event_data_value -
Deadlocks with Details History Values event_detailed_dlconn -
Deadlocks with Details History Values event_stmt_history -
Usage
Use this element in your monitoring application to correlate deadlock connection and statement history event records with deadlock event records.
Parent topic: Database system monitor elements