Information written to tables for a statistics event monitor

When you choose WRITE TO TABLE as the ouput type for a statistics event monitor, a number of tables are produced. Each table contains monitor elements from one or more logical data groups.

The following table contains a list of the logical data groups and associated tables used by the statistics event monitor. The default table name for each logical data group is derived by concatenating the name of the logical data group used to populate the table with the name given to the event monitor when it was created by using the CREATE EVENT MONITOR statement. The table names shown are the default table names when a name is not specified as part of the CREATE EVENT MONITOR statement.

Table 1. Tables produced by STATISTICS write-to-table event monitors
Default table name	Logical data groups reported
QSTATS_`evmon-name`	Refer to event_qstats logical data group in Event monitor logical data groups and monitor elements
SCSTATS_`evmon-name`	Refer to event_scstats logical data group in Event monitor logical data groups and monitor elements
HISTOGRAMBIN_`evmon-name`	Refer to event_histogrambin logical data group in Event monitor logical data groups and monitor elements
WCSTATS_`evmon-name`	Refer to event_wcstats logical data group in Event monitor logical data groups and monitor elements
WLSTATS_`evmon-name`	Refer to event_wlstats logical data group in Event monitor logical data groups and monitor elements
SCMETRICS_`evmon-name`	Refer to event_scmetrics logical data group in Event monitor logical data groups and monitor elements
WLMETRICS_`evmon-name`	Refer to event_wlmetrics logical data group in Event monitor logical data groups and monitor elements
OSMETRICS_`evmon-name`	Refer to event_osmetrics 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.

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. You can refer to the reference topics for those statements for details.

Control table

Table 2. Information returned for a statistics event monitor: Default table name: CONTROL_`evmon-name`
Column name	Data type	Description
PARTITION_KEY	INTEGER	partition_key - Partitioning key
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
PARTITION_NUMBER	SMALLINT	partition_number - Partition number