Information written to tables for a package cache event monitor

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

When you choose WRITE TO TABLE as the output type for a package cache event monitor, by default, three tables are produced, each containing monitor elements from one or more logical data groups.
Table 1. Tables produced by package cache 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
PKGCACHE_evmon-name Refer to pkgcache in Event monitor logical data groups and monitor elements
PKGCACHE_METRICS_evmon-name Refer to pkgcache_metrics in Event monitor logical data groups and monitor elements
PKGCACHE_STMT_ARGS_evmon-name 1 Refer to pkgcache_stmt_args 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.
  1. This table records entries for the following data types; however, the actual values of the arguments are not recorded in the STMT_VALUE_DATA element: BLOB, CLOB, REF, BOOLEAN, Structured data types, DATALINK, LONG VARGRAPHIC, LONG VARCHAR, XML types, DBCLOB, ARRAY types, ROW types, ROWID, CURSOR variables

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 statement. Refer to the reference topics for those statements for details.

Control table

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