Information written to tables for a threshold violation event monitor

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

The sections that follows illustrates the output of a threshold violations 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 THRESHOLD 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
THRESHOLDVIOLATIONS_evmon-name event_thresholdviolations
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.

Tables produced

Table 2. Information returned for a threshold violations event monitor: Default table name: THRESHOLDVIOLATIONS_evmon-name
Column Name Data Type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
ACTIVATE_TIMESTAMP TIMESTAMP activate_timestamp - Activate timestamp
ACTIVITY_COLLECTED CHARACTER(1) activity_collected - Activity collected
ACTIVITY_ID BIGINT activity_id - Activity ID
AGENT_ID BIGINT agent_id - Application handle (agent ID)
APPL_ID VARCHAR(64) appl_id - Application ID
COORD_PARTITION_NUM INTEGER coord_partition_num - Coordinator partition number
DESTINATION_SERVICE_CLASS_ID INTEGER destination_service_class_id - Destination service class ID monitor element
PARTITION_NUMBER SMALLINT partition_number - Partition number
SOURCE_SERVICE_CLASS_ID INTEGER source_service_class_id - Source service class ID
THRESHOLD_ACTION VARCHAR(16) threshold_action - Threshold action
THRESHOLD_MAXVALUE BIGINT threshold_maxvalue - Threshold maximum value
THRESHOLD_PREDICATE VARCHAR(64) threshold_predicate - Threshold predicate
THRESHOLD_QUEUESIZE BIGINT threshold_queuesize - Threshold queue size
THRESHOLDID INTEGER thresholdid - Threshold ID
TIME_OF_VIOLATION TIMESTAMP time_of_violation - Time of violation
UOW_ID INTEGER uow_id - Unit of work ID
Table 3. Information returned for a threshold violations event monitor: Table name: CONTROL_evmon-name
Column Name Data Type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
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