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 event_connheader logical data group
DEADLOCK_evmon-name event_deadlock logical data group
DLCONN_evmon-name event_dlconn logical data group
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.

Tables produced

Table 2. Information returned for a deadlock event monitor: Default table name: CONNHEADER_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_NAME VARCHAR(255) appl_name - Application name monitor element
AUTH_ID VARCHAR(128) auth_id - Authorization ID monitor element
CLIENT_DB_ALIAS CHARACTER(8) client_db_alias - Database Alias Used by Application monitor element
CLIENT_NNAME VARCHAR(20) client_nname - Client name monitor element
CLIENT_PID BIGINT client_pid - Client process ID monitor element
CLIENT_PLATFORM INTEGER client_platform - Client operating platform monitor element
CLIENT_PRDID VARCHAR(20) client_prdid - Client product and version ID monitor element
CLIENT_PROTOCOL INTEGER client_protocol - Client communication protocol monitor element
CODEPAGE_ID INTEGER codepage_id - ID of Code Page Used by Application monitor element
CONN_TIME TIMESTAMP conn_time - Time of database connection monitor element
CORR_TOKEN VARCHAR(64) corr_token - DRDA Correlation Token monitor element
EXECUTION_ID VARCHAR(128) execution_id - User Login ID monitor element
SEQUENCE_NO CHARACTER(5) sequence_no - Sequence number monitor element
TERRITORY_CODE INTEGER territory_code - Database Territory Code monitor element
Table 3. Information returned for a deadlock event monitor: Default table name: DEADLOCK_evmon-name
Column Name Data Type Description
DEADLOCK_ID BIGINT deadlock_id - Deadlock Event Identifier monitor element
DL_CONNS BIGINT dl_conns - Connections involved in deadlock monitor element
EVMON_ACTIVATES BIGINT evmon_activates - Number of Event Monitor Activations monitor element
ROLLED_BACK_AGENT_ID BIGINT rolled_back_agent_id - Rolled Back Agent monitor element
ROLLED_BACK_APPL_ID VARCHAR(64) rolled_back_appl_id - Rolled Back Application monitor element
ROLLED_BACK_PARTICIPANT_NO SMALLINT rolled_back_participant_no - Rolled back application participant monitor element
ROLLED_BACK_SEQUENCE_NO CHARACTER(5) rolled_back_sequence_no - Rolled Back Sequence Number monitor element
START_TIME TIMESTAMP start_time - Event Start Time monitor element
Table 4. Information returned for a deadlock event monitor: Default table name: DLCONN_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
Table 5. 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