Information written to tables for a transaction event monitor

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

The sections that follows illustrates the output of a transaction 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 TRANSACTION 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
XACT_evmon-name Refer to event_xact logical data group in Event monitor logical data groups and monitor elements
CONNHEADER_evmon-name Refer to event_connheader 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 transaction event monitor: Default table name: CONTROL_evmon-name
Column name Data type Description
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