Information written to tables for a connections event monitor

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

When you choose WRITE TO TABLE as the ouput type for the connections event monitor, by default, four tables are produced, each containing monitor elements from one or more logical data groups:
Table 1. Tables produced by CONNECTIONS 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
CONNHEADER_evmon-name Refer to event_connheader in Event monitor logical data groups and monitor elements
CONN_evmon-name Refer to event_conn in Event monitor logical data groups and monitor elements
CONMEMUSE_evmon-name Refer to event_connmemuse 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.
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.

For information about the output returned when the event monitor writes to a file or named pipe, see Event monitor self-describing data stream.

Control table

Table 2. Information returned for a connections event monitor: Default table name: CONTROL_evmon-name
Column Name Data Type Description
APPL_ID VARCHAR(64) appl_id - Application ID
EVMON_FLUSHES BIGINT evmon_flushes - Number of event monitor flushes
POOL_CUR_SIZE BIGINT pool_cur_size - Current size of memory pool
POOL_ID BIGINT pool_id - Memory pool identifier
POOL_WATERMARK BIGINT pool_watermark - Memory pool watermark