Information written to tables for a statement event monitor

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

The sections that follows illustrates the output of a statement 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 STATEMENT 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
STMT_`evmon-name`	Refer to event_stmt 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.
CONNHEADER_`evmon-name`	Refer to event_connheader logical data group in Event monitor logical data groups and monitor elements
SUBSECTION_`evmon-name`	Refer to event_subsection logical data group in Event monitor logical data groups and monitor elements. Note: This logical data group is generated only in partitioned database environments.
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.

To restrict the output of the event monitor to specific tables, specify the names of the logical groups for which you want tables produced in the CREATE EVENT MONITOR or ALTER EVENT MONITOR statements. Refer to the reference topics for those statements for details.

Control table

Table 2. Information returned for a statement 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