Information written to tables for a deadlock event monitor

Information written by a deadlock event monitor when the WRITE TO TABLE option is specified.

The sections that follows illustrates the output of a deadlock event monitor when the WRITE TO TABLE option is used on the CREATE EVENT MONITOR statement. For information about the output returned when the event monitor writes to a file or named pipe, see Event monitor self-describing data stream.
Table 1. Tables produced by DEADLOCK write-to-table event monitors. The table name is derived by concatenating the name of the logical data group used to populate the table with the name given to the event monitor (as represented by evmon-name in the table names shown in the following table) in the CREATE EVENT MONITOR statement.
Default table name Logical data groups reported
CONNHEADER_evmon-name Refer to event_connheader logical data group in Event monitor logical data groups and monitor elements
DEADLOCK_evmon-name Refer to event_deadlock logical data group in Event monitor logical data groups and monitor elements
DLCONN_evmon-name Refer to event_dlconn logical data group in Event monitor logical data groups and monitor elements
CONTROL_evmon-name The CONTROL logical group consists of selected elements from one or more of the event_dbheader, event_start and event_overflow logical data groups.

Control table

Table 2. Information returned for a deadlock event monitor: Default table name: CONTROL_evmon-name
Column Name Data Type Description
AGENT_ID BIGINT agent_id - Application handle (agent ID) monitor element
APPL_ID VARCHAR(64) appl_id - Application ID monitor element
APPL_ID_HOLDING_LK VARCHAR(64) appl_id_holding_lk - Application ID Holding Lock monitor element
DATA_PARTITION_ID INTEGER data_partition_id - Data partition identifier monitor element
DEADLOCK_ID BIGINT deadlock_id - Deadlock Event Identifier monitor element
EVMON_ACTIVATES BIGINT evmon_activates - Number of Event Monitor Activations monitor element
LOCK_ATTRIBUTES BIGINT lock_attributes - Lock attributes monitor element
LOCK_COUNT BIGINT lock_count - Lock count monitor element
LOCK_CURRENT_MODE BIGINT lock_current_mode - Original lock mode before conversion monitor element
LOCK_ESCALATION SMALLINT lock_escalation - Lock escalation monitor element
LOCK_HOLD_COUNT BIGINT lock_hold_count - Lock hold count monitor element
LOCK_MODE BIGINT lock_mode - Lock mode monitor element
LOCK_MODE_REQUESTED BIGINT lock_mode_requested - Lock mode requested monitor element
LOCK_NAME CHARACTER(13) lock_name - Lock name monitor element
LOCK_NODE BIGINT lock_node - Lock Node monitor element
LOCK_OBJECT_NAME BIGINT lock_object_name - Lock Object Name monitor element
LOCK_OBJECT_TYPE BIGINT lock_object_type - Lock object type waited on monitor element
LOCK_RELEASE_FLAGS BIGINT lock_release_flags - Lock release flags monitor element
LOCK_WAIT_START_TIME TIMESTAMP lock_wait_start_time - Lock wait start timestamp monitor element
PARTICIPANT_NO SMALLINT participant_no - Participant within Deadlock monitor element
PARTICIPANT_NO_HOLDING_LK SMALLINT participant_no_holding_lk - Participant Holding a Lock on the Object Required by Application monitor element
SEQUENCE_NO CHARACTER(5) sequence_no - Sequence number monitor element
SEQUENCE_NO_HOLDING_LK CHARACTER(5) sequence_no_holding_lk - Sequence Number Holding Lock monitor element
START_TIME TIMESTAMP start_time - Event Start Time monitor element
TABLE_NAME VARCHAR(128) table_name - Table name monitor element
TABLE_SCHEMA VARCHAR(128) table_schema - Table schema name monitor element
TABLESPACE_NAME VARCHAR(18) tablespace_name - Table space name monitor element