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.
Default table name | Logical data groups reported |
---|---|
XACT_evmon-name | event_xact logical data group |
CONNHEADER_evmon-name | event_connheader 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
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 |