Information written to tables for a locking event monitor

Information written by the locking event monitor when the WRITE TO TABLE option is specified.
When you choose WRITE TO TABLE as the output type for the locking event monitor, by default, five tables are produced, each containing monitor elements from one or more logical data groups:
Table 1. Tables produced by locking write-to-table event monitors
Default table name Logical data groups reported
LOCK_evmon-name lock
LOCK_PARTICIPANTS_evmon-name lock_participants
LOCK_PARTICIPANT_ACTIVITIES_evmon-name lock_participant_activities
LOCK_ACTIVITY_VALUES_evmon-name lock_activity_values
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.
Important: Even though all five tables are produced by default, you must still ensure that data collection is enabled for the kind of lock information that you want to gather. Otherwise, some of the columns contain null values.
To restrict the output of the event monitor to specific tables, specify the names of the logical groups for which you want tables produced for the CREATE EVENT MONITOR or ALTER EVENT MONITOR statement. Refer to the reference topics for those statements for details.

Tables produced

Table 2. Information returned for a locking event monitor: Default table name: LOCK_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
DEADLOCK_TYPE VARCHAR(10) deadlock_type - Deadlock type monitor element
DL_CONNS INTEGER dl_conns - Connections involved in deadlock
EVENT_ID BIGINT NOT NULL event_id - Event ID monitor element
EVENT_TIMESTAMP TIMESTAMP NOT NULL event_timestamp - Event timestamp monitor element
EVENT_TYPE VARCHAR(128) NOT NULL event_type - Event Type monitor element monitor element
MEMBER SMALLINT NOT NULL member - Database member
ROLLED_BACK_PARTICIPANT_NO INTEGER rolled_back_participant_no - Rolled back application participant
Table 3. Information returned for a locking event monitor: Default table name: LOCK_PARTICIPANTS_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
AGENT_STATUS INTEGER agent_status - DCS application agents
AGENT_TID BIGINT agent_tid - Agent thread ID monitor element
APPL_ACTION VARCHAR(64) appl_action - Application action monitor element
APPL_ID VARCHAR(128) appl_id - Application ID
APPL_NAME VARCHAR(128) appl_name - Application name
APPLICATION_HANDLE BIGINT application_handle - Application handle
AUTH_ID VARCHAR(128) auth_id - Authorization ID
CLIENT_ACCTNG VARCHAR(255) client_acctng - Client accounting string
CLIENT_APPLNAME VARCHAR(255) client_applname - Client application name
CLIENT_USERID VARCHAR(255) client_userid - Client user ID
CLIENT_WRKSTNNAME VARCHAR(255) client_wrkstnname - Client workstation name
COORD_AGENT_TID BIGINT coord_agent_tid - Coordinator agent engine dispatchable unit ID monitor element
CURRENT_REQUEST VARCHAR(32) current_request - Current operation request monitor element
DEADLOCK_MEMBER SMALLINT deadlock_member - Deadlock member monitor element
EVENT_ID BIGINT event_id - Event ID monitor element
EVENT_TIMESTAMP TIMESTAMP event_timestamp - Event timestamp monitor element
EVENT_TYPE VARCHAR(128) event_type - Event Type monitor element monitor element
INTERNAL_DATA VARCHAR(255)  
LOCK_ATTRIBUTES CHAR(8) lock_attributes - Lock attributes
LOCK_COUNT BIGINT lock_count - Lock count
LOCK_CURRENT_MODE BIGINT lock_current_mode - Original lock mode before conversion
LOCK_ESCALATION CHAR(3) lock_escalation - Lock escalation
LOCK_HOLD_COUNT BIGINT lock_hold_count - Lock hold count
LOCK_MODE BIGINT lock_mode - Lock mode
LOCK_MODE_REQUESTED BIGINT lock_mode_requested - Lock mode requested
LOCK_NAME CHAR(32) lock_name - Lock name
LOCK_OBJECT_TYPE BIGINT lock_object_type - Lock object type waited on
LOCK_OBJECT_TYPE_ID CHAR(1) Reserved for future use
LOCK_RELEASE_FLAGS CHAR(8) lock_release_flags - Lock release flags
LOCK_RRIID BIGINT  
LOCK_STATUS BIGINT lock_status - Lock status
LOCK_TIMEOUT_VAL BIGINT lock_timeout_val - Lock timeout value
LOCK_WAIT_END_TIME TIMESTAMP lock_wait_end_time - Lock wait end timestamp monitor element
LOCK_WAIT_START_TIME TIMESTAMP lock_wait_start_time - Lock wait start timestamp
LOCK_WAIT_VAL BIGINT lock_wait_val - Lock wait value monitor element
MEMBER SMALLINT member - Database member
OBJECT_REQUESTED VARCHAR(10) object_requested - Requested object monitor element
PARTICIPANT_NO INTEGER participant_no - Participant within deadlock
PARTICIPANT_NO_HOLDING_LK INTEGER participant_no_holding_lk - Participant holding a lock on the object required by application
PARTICIPANT_TYPE VARCHAR(10) participant_type - Participant type monitor element
PAST_ACTIVITIES_WRAPPED CHAR(3) past_activities_wrapped - Past activities list wrapped monitor element
QUEUE_START_TIME TIMESTAMP queue_start_time - Queue start timestamp monitor element
QUEUED_AGENTS BIGINT queued_agents - Queued threshold agents monitor element
SERVICE_CLASS_ID INTEGER service_class_id - Service class ID
SERVICE_SUBCLASS_NAME VARCHAR(128) service_subclass_name - Service subclass name
SERVICE_SUPERCLASS_NAME VARCHAR(128) service_superclass_name - Service superclass name
TABLE_FILE_ID BIGINT table_file_id - Table file identification
TABLE_NAME VARCHAR(128) table_name - Table name
TABLE_SCHEMA VARCHAR(128) table_schema - Table schema name
TABLESPACE_NAME VARCHAR(128) tablespace_name - Table space name
THRESHOLD_ID INTEGER thresholdid - Threshold ID monitor element
THRESHOLD_NAME VARCHAR(128) threshold_name - Threshold name
UTILITY_INVOCATION_ID VARCHAR(32) FOR BIT DATA  
WORKLOAD_ID INTEGER workload_id - Workload ID
WORKLOAD_NAME VARCHAR(128) workload_name - Workload name
XID VARCHAR(140) xid - Transaction ID
Table 4. Information returned for a locking event monitor: Default table name: LOCK_PARTICIPANT_ACTIVITIES_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
ACTIVITY_ID BIGINT activity_id - Activity ID
ACTIVITY_TYPE VARCHAR(10) activity_type - Activity type
CONSISTENCY_TOKEN CHARACTER(8) consistency_token - Package consistency token
EFFECTIVE_ISOLATION CHARACTER(2) effective_isolation - Effective isolation
EFFECTIVE_QUERY_DEGREE BIGINT effective_query_degree - Effective query degree
EVENT_ID BIGINT event_id - Event ID monitor element
EVENT_TIMESTAMP TIMESTAMP event_timestamp - Event timestamp monitor element
EVENT_TYPE VARCHAR(128) event_type - Event Type monitor element monitor element
INCREMENTAL_BIND CHARACTER(3) incremental_bind - Incremental bind monitor element
MEMBER SMALLINT member - Database member
PACKAGE_NAME VARCHAR(128) package_name - Package name
PACKAGE_SCHEMA VARCHAR(128) package_schema - Package schema
PACKAGE_VERSION_ID VARCHAR(64) package_version_id - Package version
PARTICIPANT_NO SMALLINT participant_no - Participant within deadlock
QUERY_ACTUAL_DEGREE INTEGER query_actual_degree - Actual runtime degree of intrapartition parallelism
REOPT VARCHAR(10) reopt - Reopt bind option monitor element
SECTION_NUMBER BIGINT section_number - Section number
STMT_FIRST_USE_TIME TIMESTAMP stmt_first_use_time - Statement first use timestamp
STMT_INVOCATION_ID BIGINT stmt_invocation_id - Statement invocation identifier
STMT_LAST_USE_TIME TIMESTAMP stmt_last_use_time - Statement last use timestamp
STMT_LOCK_TIMEOUT INTEGER stmt_lock_timeout - Statement lock timeout
STMT_NEST_LEVEL BIGINT stmt_nest_level - Statement nesting level
STMT_OPERATION VARCHAR(128) stmt_operation/operation - Statement operation monitor element
STMT_PKGCACHE_ID BIGINT stmt_pkgcache_id - Statement package cache identifier
STMT_QUERY_ID BIGINT stmt_query_id - Statement query identifier
STMT_SOURCE_ID BIGINT stmt_source_id - Statement source identifier
STMT_TEXT CLOB stmt_text - SQL statement text
STMT_TYPE BIGINT stmt_type - Statement type
STMT_UNICODE CHARACTER(3) stmt_unicode - Statement unicode flag monitor element
UOW_ID INTEGER uow_id - Unit of work ID
Table 5. Information returned for a locking event monitor: Default table name: LOCK_ACTIVITY_VALUES_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
ACTIVITY_ID BIGINT activity_id - Activity ID
EVENT_ID BIGINT event_id - Event ID monitor element
EVENT_TIMESTAMP TIMESTAMP event_timestamp - Event timestamp monitor element
EVENT_TYPE VARCHAR(128) event_type - Event Type monitor element monitor element
MEMBER SMALLINT member - Database member
PARTICIPANT_NO SMALLINT participant_no - Participant within deadlock
STMT_VALUE_DATA CLOB stmt_value_data - Value data
STMT_VALUE_INDEX INTEGER stmt_value_index - Value index
STMT_VALUE_ISNULL INTEGER stmt_value_isnull - Value has null value
STMT_VALUE_ISREOPT INTEGER stmt_value_isreopt - Variable used for statement reoptimization
STMT_VALUE_TYPE CHARACTER(16) stmt_value_type - Value type
UOW_ID INTEGER uow_id - Unit of work ID
Table 6. Information returned for a locking event monitor: Default table name: CONTROL_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
EVENT_MONITOR_NAME VARCHAR(128) event_monitor_name - Event monitor name
MESSAGE VARCHAR(128) message - Control table message
MESSAGE_TIME TIMESTAMP message_time - Timestamp control table message
PARTITION_NUMBER SMALLINT partition_number - Partition number