Information written to tables for an activities event monitor

Information written by an activities event monitor when the WRITE TO TABLE option is specified.

When you choose WRITE TO TABLE as the ouput type for an activities event monitor, by default, five tables are produced, each containing monitor elements from one or more logical data groups:

Table 1. Tables produced by ACTIVITIES 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
ACTIVITY_`evmon-name`	Refer to event_activity in Event monitor logical data groups and monitor elements
ACTIVITYSTMT_`evmon-name`	Refer to event_activitystmt in Event monitor logical data groups and monitor elements
ACTIVITYVALS_`evmon-name`	Refer to event_activityvals in Event monitor logical data groups and monitor elements
ACTIVITYMETRICS_`evmon-name`	Refer to event_activitymetrics 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.

Control table

Table 2. Information returned for an activities 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

¹ Some columns returned in the ACTIVITY_evmon-name are dependent on the snapshot monitoring infrastructure. The snapshot statement switch must be enabled (using the DBM parameter DFT_MON_STMT) to return activity information for them. The metrics returned in these columns do not always align strictly with activity boundaries. To get more accurate activity metrics, use the corresponding columns with the same names that are returned in the ACTIVITYMETRICS_evmon-name table, except for ROWS_READ, now called ROWS_FETCHED, and USER_CPU_TIME and SYSTEM_CPU_TIME, which are now combined into TOTAL_CPU_TIME.