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. |