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 event_qstats logical data group
SCSTATS_evmon-name event_scstats logical data group
HISTOGRAMBIN_evmon-name event_histogrambin logical data group
WCSTATS_evmon-name event_wcstats logical data group
WLSTATS_evmon-name event_wlstats logical data group
SCMETRICS_evmon-name event_scmetrics logical data group
WLMETRICS_evmon-name event_wlmetrics logical data group
OSMETRICS_evmon-name event_osmetrics logical data group
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.

Tables produced

Table 2. Information returned for a statistics event monitor: Default table name: QSTATS_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
LAST_WLM_RESET TIMESTAMP last_wlm_reset - Time of last reset
MON_INTERVAL_ID BIGINT mon_interval_id - Monitor interval identifier
PARTITION_NUMBER SMALLINT partition_number - Partition number
QUEUE_ASSIGNMENTS_TOTAL BIGINT queue_assignments_total - Queue assignments total
QUEUE_SIZE_TOP INTEGER queue_size_top - Queue size top
QUEUE_TIME_TOTAL BIGINT queue_time_total - Queue time total
SERVICE_SUBCLASS_NAME VARCHAR(128) service_subclass_name - Service subclass name
SERVICE_SUPERCLASS_NAME VARCHAR(128) service_superclass_name - Service superclass name
STATISTICS_TIMESTAMP TIMESTAMP statistics_timestamp - Statistics timestamp
THRESHOLD_DOMAIN VARCHAR(64) threshold_domain - Threshold domain
THRESHOLD_NAME VARCHAR(128) threshold_name - Threshold name
THRESHOLD_PREDICATE VARCHAR(64) threshold_predicate - Threshold predicate
THRESHOLDID INTEGER thresholdid - Threshold ID
WORK_ACTION_SET_NAME VARCHAR(128) work_action_set_name - Work action set name
WORK_CLASS_NAME VARCHAR(128) work_class_name - Work class name
Table 3. Information returned for a statistics event monitor: Table name: SCSTATS_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
ACT_CPU_TIME_TOP BIGINT act_cpu_time_top - Activity CPU time top
ACT_REMAPPED_IN BIGINT act_remapped_in - Activities remapped in
ACT_REMAPPED_OUT BIGINT act_remapped_out - Activities remapped out
ACT_ROWS_READ_TOP BIGINT act_rows_read_top - Activity rows read top
ACT_THROUGHPUT BIGINT act_throughput - Activity throughput
ACTIVE_COL_VECTOR_CONSUMERS_TOP BIGINT active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
ACTIVE_HASH_GRPBYS_TOP BIGINT active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
ACTIVE_HASH_JOINS_TOP BIGINT active_hash_joins_top - Active hash join operations high watermark monitor element
ACTIVE_OLAP_FUNCS_TOP BIGINT active_olap_funcs_top - Active OLAP function operations high watermark monitor element
ACTIVE_PEAS_TOP BIGINT active_peas_top - Active partial early aggregation operations high watermark monitor element
ACTIVE_PEDS_TOP BIGINT active_peds_top - Active partial early distinct operations high watermark monitor element
ACTIVE_SORTS_TOP BIGINT active_sorts_top - Active sorts high watermark monitor element
ACTIVE_SORT_CONSUMERS_TOP BIGINT active_sort_consumers_top - Active sort memory consumers high watermark monitor element
AGG_TEMP_TABLESPACE_TOP BIGINT agg_temp_tablespace_top - Aggregate temporary table space top
APP_ACT_ABORTED_TOTAL BIGINT app_act_aborted_total - Total failed external coordinator activities
APP_ACT_COMPLETED_TOTAL BIGINT app_act_completed_total - Total successful external coordinator activities
APP_ACT_REJECTED_TOTAL BIGINT app_act_rejected_total - Total rejected external coordinator activities
CONCURRENT_ACT_TOP INTEGER concurrent_act_top - Concurrent activity top
CONCURRENT_CONNECTION_TOP INTEGER concurrent_connection_top - Concurrent connection top
CONCURRENT_WLO_TOP INTEGER concurrent_wlo_top - Concurrent workload occurrences top
COORD_ACT_ABORTED_TOTAL BIGINT coord_act_aborted_total - Coordinator activities aborted total
COORD_ACT_COMPLETED_TOTAL BIGINT coord_act_completed_total - Coordinator activities completed total
COORD_ACT_EST_COST_AVG BIGINT coord_act_est_cost_avg - Coordinator activity estimated cost average
COORD_ACT_EXEC_TIME_AVG BIGINT coord_act_exec_time_avg - Coordinator activities execution time average
COORD_ACT_INTERARRIVAL_TIME_AVG BIGINT coord_act_interarrival_time_avg - Coordinator activity arrival time average
COORD_ACT_LIFETIME_AVG BIGINT coord_act_lifetime_avg - Coordinator activity lifetime average
COORD_ACT_LIFETIME_TOP BIGINT coord_act_lifetime_top - Coordinator activity lifetime top
COORD_ACT_QUEUE_TIME_AVG BIGINT coord_act_queue_time_avg - Coordinator activity queue time average
COORD_ACT_REJECTED_TOTAL BIGINT coord_act_rejected_total - Coordinator activities rejected total
COST_ESTIMATE_TOP BIGINT cost_estimate_top - Cost estimate top
CPU_UTILIZATION BIGINT cpu_utilization - CPU utilization
DETAILS_XML BLOB details_xml - Details XMLMetrics reported in this document for the default subclass SYSDEFAULTSUBCLASS under the superclass SYSDEFAULTSYSTEMCLASS have a value of 0.
LAST_WLM_RESET TIMESTAMP last_wlm_reset - Time of last reset
MEMBER SMALLINT member - Database member
METRICS BLOB metrics - Metrics
MON_INTERVAL_ID BIGINT mon_interval_id - Monitor interval identifier
PARTITION_NUMBER SMALLINT partition_number - Partition number
REQUEST_EXEC_TIME_AVG BIGINT request_exec_time_avg - Request execution time average
ROWS_RETURNED_TOP BIGINT rows_returned_top - Actual rows returned top
SERVICE_CLASS_ID INTEGER service_class_id - Service class ID
SERVICE_SUBCLASS_NAME VARCHAR(128) service_subclass_name - Service subclass name
SERVICE_SUPERCLASS_NAME VARCHAR(128) service_superclass_name - Service superclass name
SORT_CONSUMER_HEAP_TOP BIGINT sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
SORT_CONSUMER_SHRHEAP_TOP BIGINT sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
SORT_HEAP_TOP BIGINT sort_heap_top - Sort private heap high watermark monitor element
SORT_SHRHEAP_TOP BIGINT sort_shrheap_top - Sort share heap high watermark monitor element
STATISTICS_TIMESTAMP TIMESTAMP statistics_timestamp - Statistics timestamp
TEMP_TABLESPACE_TOP BIGINT temp_tablespace_top - Temporary table space top
TOTAL_CPU_TIME BIGINT total_cpu_time - Total CPU time
TOTAL_DISP_RUN_QUEUE_TIME BIGINT total_disp_run_queue_time - Total dispatcher run queue time
UOW_COMPLETED_TOTAL BIGINT uow_completed_total - Total completed units of work
UOW_LIFETIME_AVG BIGINT uow_lifetime_avg - Unit of work lifetime average
UOW_THROUGHPUT BIGINT uow_throughput - Unit of work throughput
UOW_TOTAL_TIME_TOP BIGINT uow_total_time_top - UOW total time top
Table 4. Information returned for a statistics event monitor: Table name: HISTOGRAMBIN_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
BIN_ID INTEGER bin_id - Histogram bin identifier
BOTTOM BIGINT bottom - Histogram bin bottom
HISTOGRAM_TYPE VARCHAR(64) histogram_type - Histogram type
MON_INTERVAL_ID BIGINT mon_interval_id - Monitor interval identifier
NUMBER_IN_BIN BIGINT number_in_bin - Number in bin
PARTITION_NUMBER SMALLINT partition_number - Partition number
SERVICE_CLASS_ID INTEGER service_class_id - Service class ID
STATISTICS_TIMESTAMP TIMESTAMP statistics_timestamp - Statistics timestamp
TOP BIGINT top - Histogram bin top
WORK_ACTION_SET_ID INTEGER work_action_set_id - Work action set ID
WORK_CLASS_ID INTEGER work_class_id - Work class ID
WORKLOAD_ID INTEGER workload_id - Workload ID
Table 5. Information returned for a statistics event monitor: Table name: WCSTATS_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
ACT_CPU_TIME_TOP BIGINT act_cpu_time_top - Activity CPU time top
ACT_ROWS_READ_TOP BIGINT act_rows_read_top - Activity rows read top
ACT_TOTAL BIGINT act_total - Activities total
COORD_ACT_EST_COST_AVG BIGINT coord_act_est_cost_avg - Coordinator activity estimated cost average
COORD_ACT_EXEC_TIME_AVG BIGINT coord_act_exec_time_avg - Coordinator activities execution time average
COORD_ACT_INTERARRIVAL_TIME_AVG BIGINT coord_act_exec_time_avg - Coordinator activities execution time average
COORD_ACT_LIFETIME_AVG BIGINT coord_act_lifetime_avg - Coordinator activity lifetime average
COORD_ACT_LIFETIME_TOP BIGINT coord_act_lifetime_top - Coordinator activity lifetime top
COORD_ACT_QUEUE_TIME_AVG BIGINT coord_act_queue_time_avg - Coordinator activity queue time average
COST_ESTIMATE_TOP BIGINT cost_estimate_top - Cost estimate top
LAST_WLM_RESET TIMESTAMP last_wlm_reset - Time of last reset
MON_INTERVAL_ID BIGINT mon_interval_id - Monitor interval identifier
PARTITION_NUMBER SMALLINT partition_number - Partition number
ROWS_RETURNED_TOP BIGINT rows_returned_top - Actual rows returned top
STATISTICS_TIMESTAMP TIMESTAMP statistics_timestamp - Statistics timestamp
TEMP_TABLESPACE_TOP BIGINT temp_tablespace_top - Temporary table space top
WORK_ACTION_SET_ID INTEGER work_action_set_id - Work action set ID
WORK_ACTION_SET_NAME VARCHAR(128) work_action_set_name - Work action set name
WORK_CLASS_ID INTEGER work_class_id - Work class ID
WORK_CLASS_NAME VARCHAR(128) work_class_name - Work class name
Table 6. Information returned for a statistics event monitor: Table name: WLSTATS_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
ACT_CPU_TIME_TOP BIGINT act_cpu_time_top - Activity CPU time top
ACT_ROWS_READ_TOP BIGINT act_rows_read_top - Activity rows read top
ACT_THROUGHPUT BIGINT act_throughput - Activity throughput
ACTIVE_COL_VECTOR_CONSUMERS_TOP BIGINT active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
ACTIVE_HASH_GRPBYS_TOP BIGINT active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
ACTIVE_HASH_JOINS_TOP BIGINT active_hash_joins_top - Active hash join operations high watermark monitor element
ACTIVE_OLAP_FUNCS_TOP BIGINT active_olap_funcs_top - Active OLAP function operations high watermark monitor element
ACTIVE_PEAS_TOP BIGINT active_peas_top - Active partial early aggregation operations high watermark monitor element
ACTIVE_PEDS_TOP BIGINT active_peds_top - Active partial early distinct operations high watermark monitor element
ACTIVE_SORTS_TOP BIGINT active_sorts_top - Active sorts high watermark monitor element
ACTIVE_SORT_CONSUMERS_TOP BIGINT active_sort_consumers_top - Active sort memory consumers high watermark monitor element
APP_ACT_ABORTED_TOTAL BIGINT app_act_aborted_total - Total failed external coordinator activities
APP_ACT_COMPLETED_TOTAL BIGINT app_act_completed_total - Total successful external coordinator activities
APP_ACT_REJECTED_TOTAL BIGINT app_act_rejected_total - Total rejected external coordinator activities
CONCURRENT_WLO_ACT_TOP INTEGER concurrent_wlo_act_top - Concurrent WLO activity top
CONCURRENT_WLO_TOP INTEGER concurrent_wlo_top - Concurrent workload occurrences top
COORD_ACT_ABORTED_TOTAL BIGINT coord_act_aborted_total - Coordinator activities aborted total
COORD_ACT_COMPLETED_TOTAL BIGINT coord_act_completed_total - Coordinator activities completed total
COORD_ACT_EST_COST_AVG BIGINT coord_act_est_cost_avg - Coordinator activity estimated cost average
COORD_ACT_EXEC_TIME_AVG BIGINT coord_act_exec_time_avg - Coordinator activities execution time average
COORD_ACT_INTERARRIVAL_TIME_AVG BIGINT coord_act_interarrival_time_avg - Coordinator activity arrival time average monitor element
COORD_ACT_LIFETIME_AVG BIGINT coord_act_lifetime_avg - Coordinator activity lifetime average
COORD_ACT_LIFETIME_TOP BIGINT coord_act_lifetime_top - Coordinator activity lifetime top
COORD_ACT_QUEUE_TIME_AVG BIGINT coord_act_queue_time_avg - Coordinator activity queue time average
COORD_ACT_REJECTED_TOTAL BIGINT coord_act_rejected_total - Coordinator activities rejected total
COST_ESTIMATE_TOP BIGINT cost_estimate_top - Cost estimate top
CPU_UTILIZATION BIGINT cpu_utilization - CPU utilization
DETAILS_XML BLOB details_xml - Details XML
LAST_WLM_RESET TIMESTAMP last_wlm_reset - Time of last reset
LOCK_WAIT_TIME_GLOBAL_TOP BIGINT lock_wait_time_global_top - Top global lock wait time
LOCK_WAIT_TIME_TOP BIGINT lock_wait_time_top - Lock wait time top
MEMBER SMALLINT member - Database member
METRICS BLOB metrics - Metrics
MON_INTERVAL_ID BIGINT mon_interval_id - Monitor interval identifier
ROWS_RETURNED_TOP BIGINT rows_returned_top - Actual rows returned top
SORT_CONSUMER_HEAP_TOP BIGINT sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
SORT_CONSUMER_SHRHEAP_TOP BIGINT sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
SORT_HEAP_TOP BIGINT sort_heap_top - Sort private heap high watermark monitor element
SORT_SHRHEAP_TOP BIGINT sort_shrheap_top - Sort share heap high watermark monitor element
STATISTICS_TIMESTAMP TIMESTAMP statistics_timestamp - Statistics timestamp
TEMP_TABLESPACE_TOP BIGINT temp_tablespace_top - Temporary table space top
TOTAL_CPU_TIME BIGINT total_cpu_time - Total CPU time
TOTAL_DISP_RUN_QUEUE_TIME BIGINT total_disp_run_queue_time - Total dispatcher run queue time
UOW_COMPLETED_TOTAL BIGINT uow_completed_total - Total completed units of work
UOW_LIFETIME_AVG BIGINT uow_lifetime_avg - Unit of work lifetime average
UOW_THROUGHPUT BIGINT uow_throughput - Unit of work throughput
UOW_TOTAL_TIME_TOP BIGINT uow_total_time_top - UOW total time top
WLO_COMPLETED_TOTAL BIGINT wlo_completed_total - Workload occurrences completed total
WORKLOAD_ID INTEGER workload_id - Workload ID
WORKLOAD_NAME VARCHAR(128) workload_name - Workload name
Table 7. Information returned for a statistics event monitor: Default table name: SCMETRICS_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
LAST_WLM_RESET TIMESTAMP last_wlm_reset - Time of last reset
MON_INTERVAL_ID BIGINT mon_interval_id - Monitor interval identifier
PARTITION_NUMBER SMALLINT partition_number - Partition number
SERVICE_CLASS_ID INTEGER service_class_id - Service class ID
SERVICE_SUBCLASS_NAME VARCHAR service_subclass_name - Service subclass name
SERVICE_SUPERCLASS_NAME VARCHAR service_superclass_name - Service superclass name
STATISTICS_TIMESTAMP TIMESTAMP statistics_timestamp - Statistics timestamp
WLM_QUEUE_TIME_TOTAL BIGINT wlm_queue_time_total - Workload manager total queue time monitor element
WLM_QUEUE_ASSIGNMENTS_TOTAL BIGINT wlm_queue_assignments_total - Workload manager total queue assignments monitor element
FCM_TQ_RECV_WAIT_TIME BIGINT fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
FCM_MESSAGE_RECV_WAIT_TIME BIGINT fcm_message_recv_wait_time - FCM message received wait time monitor element
FCM_TQ_SEND_WAIT_TIME BIGINT fcm_tq_send_wait_time - FCM table queue send wait time monitor element
FCM_MESSAGE_SEND_WAIT_TIME BIGINT fcm_message_send_wait_time - FCM message send wait time monitor element
AGENT_WAIT_TIME BIGINT agent_wait_time - Agent wait time monitor element
AGENT_WAITS_TOTAL BIGINT agent_waits_total - Total agent waits monitor element
LOCK_WAIT_TIME BIGINT lock_wait_time - Time waited on locks monitor element
LOCK_WAITS BIGINT lock_waits - Lock waits monitor element
DIRECT_READ_TIME BIGINT direct_read_time - Direct read time monitor element
DIRECT_READ_REQS BIGINT direct_read_reqs - Direct read requests monitor element
DIRECT_WRITE_TIME BIGINT direct_write_time - Direct write time monitor element
DIRECT_WRITE_REQS BIGINT direct_write_reqs - Direct write requests monitor element
LOG_BUFFER_WAIT_TIME BIGINT log_buffer_wait_time - Log buffer wait time monitor element
NUM_LOG_BUFFER_FULL BIGINT num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
LOG_DISK_WAIT_TIME BIGINT log_disk_wait_time - Log disk wait time monitor element
LOG_DISK_WAITS_TOTAL BIGINT log_disk_waits_total - Total log disk waits monitor element
TCPIP_RECV_WAIT_TIME BIGINT tcpip_recv_wait_time - TCP/IP received wait time monitor element
TCPIP_RECVS_TOTAL BIGINT tcpip_recvs_total - TCP/IP receives total monitor element
CLIENT_IDLE_WAIT_TIME BIGINT client_idle_wait_time - Client idle wait time monitor element
IPC_RECV_WAIT_TIME BIGINT ipc_recv_wait_time - Interprocess communication received wait time monitor element
IPC_RECVS_TOTAL BIGINT ipc_recvs_total - Interprocess communication receives total monitor element
IPC_SEND_WAIT_TIME BIGINT ipc_send_wait_time - Interprocess communication send wait time monitor element
IPC_SENDS_TOTAL BIGINT ipc_sends_total - Interprocess communication send total monitor element
TCPIP_SEND_WAIT_TIME BIGINT tcpip_send_wait_time - TCP/IP send wait time monitor element
TCPIP_SENDS_TOTAL BIGINT tcpip_sends_total - TCP/IP sends total monitor element
POOL_WRITE_TIME BIGINT pool_write_time - Total buffer pool physical write time monitor element
POOL_READ_TIME BIGINT pool_read_time - Total buffer pool physical read time monitor element
AUDIT_FILE_WRITE_WAIT_TIME BIGINT audit_file_write_wait_time - Audit file write wait time monitor element
AUDIT_FILE_WRITES_TOTAL BIGINT audit_file_writes_total - Total audit files written monitor element
AUDIT_SUBSYSTEM_WAIT_TIME BIGINT audit_subsystem_wait_time - Audit subsystem wait time monitor element
AUDIT_SUBSYSTEM_WAITS_TOTAL BIGINT audit_subsystem_waits_total - Total audit subsystem waits monitor element
DIAGLOG_WRITE_WAIT_TIME BIGINT diaglog_write_wait_time - Diagnostic log file write wait time monitor element
DIAGLOG_WRITES_TOTAL BIGINT diaglog_writes_total - Total diagnostic log file writes monitor element
FCM_SEND_WAIT_TIME BIGINT fcm_send_wait_time - FCM send wait time monitor element
FCM_RECV_WAIT_TIME BIGINT fcm_recv_wait_time - FCM received wait time monitor element
TOTAL_WAIT_TIME BIGINT total_wait_time - Total wait time monitor element
RQSTS_COMPLETED_TOTAL BIGINT rqsts_completed_total - Total requests completed monitor element
TOTAL_RQST_TIME BIGINT total_rqst_time - Total request time monitor element
APP_RQSTS_COMPLETED_TOTAL BIGINT app_rqsts_completed_total - Total application requests completed monitor element
TOTAL_APP_RQST_TIME BIGINT total_app_rqst_time - Total application request time monitor element
TOTAL_SECTION_SORT_PROC_TIME BIGINT total_section_sort_proc_time - Total section sort processing time monitor element
TOTAL_SECTION_SORTS BIGINT total_section_sorts - Total section sorts monitor element
TOTAL_SECTION_SORT_TIME BIGINT total_section_sort_time - Total section sort time monitor element
ROWS_READ BIGINT rows_read - Rows read monitor element
ROWS_MODIFIED BIGINT rows_modified - Rows modified monitor element
POOL_DATA_L_READS BIGINT pool_data_l_reads - Buffer pool data logical reads monitor element
POOL_INDEX_L_READS BIGINT pool_index_l_reads - Buffer pool index logical reads monitor element
POOL_TEMP_DATA_L_READS BIGINT pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
POOL_TEMP_INDEX_L_READS BIGINT pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
POOL_XDA_L_READS BIGINT pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
POOL_TEMP_XDA_L_READS BIGINT pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
TOTAL_CPU_TIME BIGINT total_cpu_time - Total CPU time monitor element
ACT_COMPLETED_TOTAL BIGINT act_completed_total - Total completed activities monitor element
POOL_DATA_P_READS BIGINT pool_data_p_reads - Buffer pool data physical reads monitor element
POOL_TEMP_DATA_P_READS BIGINT pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
POOL_XDA_P_READS BIGINT pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
POOL_TEMP_XDA_P_READS BIGINT pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
POOL_INDEX_P_READS BIGINT pool_index_p_reads - Buffer pool index physical reads monitor element
POOL_TEMP_INDEX_P_READS BIGINT pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
POOL_DATA_WRITES BIGINT pool_data_writes - Buffer pool data writes monitor element
POOL_XDA_WRITES BIGINT pool_xda_writes - Buffer pool XDA data writes monitor element
POOL_INDEX_WRITES BIGINT pool_index_writes - Buffer pool index writes monitor element
DIRECT_READS BIGINT direct_reads - Direct reads from database monitor element
DIRECT_WRITES BIGINT direct_writes - Direct writes to database monitor element
ROWS_RETURNED BIGINT rows_returned - Rows returned monitor element
DEADLOCKS BIGINT deadlocks - Deadlocks detected monitor element
LOCK_TIMEOUTS BIGINT lock_timeouts - Number of lock timeouts monitor element
LOCK_ESCALS BIGINT lock_escals - Number of lock escalations monitor element
FCM_SENDS_TOTAL BIGINT fcm_sends_total - FCM sends total monitor element
FCM_RECVS_TOTAL BIGINT fcm_recvs_total - FCM receives total monitor element
FCM_SEND_VOLUME BIGINT fcm_send_volume - FCM send volume monitor element
FCM_RECV_VOLUME BIGINT fcm_recv_volume - FCM received volume monitor element
FCM_MESSAGE_SENDS_TOTAL BIGINT fcm_message_sends_total - Total FCM message sends monitor element
FCM_MESSAGE_RECVS_TOTAL BIGINT fcm_message_recvs_total - Total FCM message receives monitor element
FCM_MESSAGE_SEND_VOLUME BIGINT fcm_message_send_volume - FCM message send volume monitor element
FCM_MESSAGE_RECV_VOLUME BIGINT fcm_message_recv_volume - FCM message received volume monitor element
FCM_TQ_SENDS_TOTAL BIGINT fcm_tq_sends_total - FCM table queue send total monitor element
FCM_TQ_RECVS_TOTAL BIGINT fcm_tq_recvs_total - FCM table queue receives total monitor element
FCM_TQ_SEND_VOLUME BIGINT fcm_tq_send_volume - FCM table queue send volume monitor element
FCM_TQ_RECV_VOLUME BIGINT fcm_tq_recv_volume - FCM table queue received volume monitor element
TQ_TOT_SEND_SPILLS BIGINT tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
TCPIP_SEND_VOLUME BIGINT tcpip_send_volume - TCP/IP send volume monitor element
TCPIP_RECV_VOLUME BIGINT tcpip_recv_volume - TCP/IP received volume monitor element
IPC_SEND_VOLUME BIGINT ipc_send_volume - Interprocess communication send volume monitor element
IPC_RECV_VOLUME BIGINT ipc_recv_volume - Interprocess communication received volume monitor element
POST_THRESHOLD_SORTS BIGINT post_threshold_sorts - Post threshold sorts monitor element
POST_SHRTHRESHOLD_SORTS BIGINT post_shrthreshold_sorts - Post shared threshold sorts monitor element
SORT_OVERFLOWS BIGINT sort_overflows - Sort overflows monitor element
AUDIT_EVENTS_TOTAL BIGINT audit_events_total - Total audit events monitor element
TOTAL_RQST_MAPPED_IN BIGINT total_rqst_mapped_in - Total request mapped-in monitor element
TOTAL_RQST_MAPPED_OUT BIGINT total_rqst_mapped_out - Total request mapped-out monitor element
ACT_REJECTED_TOTAL BIGINT act_rejected_total - Total rejected activities monitor element
ACT_ABORTED_TOTAL BIGINT act_aborted_total - Total aborted activities monitor element
TOTAL_SORTS BIGINT total_sorts - Total sorts monitor element
TOTAL_ROUTINE_TIME BIGINT total_routine_time - Total routine time monitor element
TOTAL_COMPILE_PROC_TIME BIGINT total_compile_proc_time - Total compile processing time monitor element
TOTAL_COMPILATIONS BIGINT total_compilations - Total compilations monitor element
TOTAL_COMPILE_TIME BIGINT total_compile_time - Total compile time monitor element
TOTAL_IMPLICIT_COMPILE_PROC_TIME BIGINT total_implicit_compile_proc_time - Total implicit compile processing time monitor element
TOTAL_IMPLICIT_COMPILATIONS BIGINT total_implicit_compilations - Total implicit compilations monitor element
TOTAL_IMPLICIT_COMPILE_TIME BIGINT total_implicit_compile_time - Total implicit compile time monitor element
TOTAL_RUNSTATS_PROC_TIME BIGINT total_runstats_proc_time - Total runtime statistics processing time monitor element
TOTAL_RUNSTATS BIGINT total_runstats - Total runtime statistics monitor element
TOTAL_RUNSTATS_TIME BIGINT total_runstats_time - Total runtime statistics time monitor element
TOTAL_REORG_PROC_TIME BIGINT total_reorg_proc_time - Total reorganization processing time monitor element
TOTAL_REORGS BIGINT total_reorgs - Total reorganizations monitor element
TOTAL_REORG_TIME BIGINT total_reorg_time - Total reorganization time monitor element
TOTAL_LOAD_PROC_TIME BIGINT total_load_proc_time - Total load processing time monitor element
TOTAL_LOADS BIGINT total_loads - Total loads monitor element
TOTAL_LOAD_TIME BIGINT total_load_time - Total load time monitor element
TOTAL_SECTION_PROC_TIME BIGINT total_section_proc_time - Total section processing time monitor element
TOTAL_APP_SECTION_EXECUTIONS BIGINT total_app_section_executions - Total application section executions monitor element
TOTAL_SECTION_TIME BIGINT total_section_time - Total section time monitor element
TOTAL_COMMIT_PROC_TIME BIGINT total_commit_proc_time - Total commits processing time monitor element
TOTAL_APP_COMMITS BIGINT total_app_commits - Total application commits monitor elements
TOTAL_COMMIT_TIME BIGINT total_commit_time - Total commit time monitor element
TOTAL_ROLLBACK_PROC_TIME BIGINT total_rollback_proc_time - Total rollback processing time monitor element
TOTAL_APP_ROLLBACKS BIGINT total_app_rollbacks - Total application rollbacks monitor element
TOTAL_ROLLBACK_TIME BIGINT total_rollback_time - Total rollback time monitor element
TOTAL_ROUTINE_USER_CODE_PROC_TIME BIGINT total_routine_user_code_proc_time - Total routine user code processing time monitor element
TOTAL_ROUTINE_USER_CODE_TIME BIGINT total_routine_user_code_time - Total routine user code time monitor element
THRESH_VIOLATIONS BIGINT thresh_violations - Number of threshold violations monitor element
NUM_LW_THRESH_EXCEEDED BIGINT num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
TOTAL_ROUTINE_INVOCATIONS BIGINT total_routine_invocations - Total routine invocations monitor elements
INT_COMMITS BIGINT int_commits - Internal commits monitor element
INT_ROLLBACKS BIGINT int_rollbacks - Internal rollbacks monitor element
CAT_CACHE_INSERTS BIGINT cat_cache_inserts - Catalog cache inserts monitor element
CAT_CACHE_LOOKUPS BIGINT cat_cache_lookups - Catalog cache lookups monitor element
PKG_CACHE_INSERTS BIGINT pkg_cache_inserts - Package cache inserts monitor element
PKG_CACHE_LOOKUPS BIGINT pkg_cache_lookups - Package cache lookups monitor element
ACT_RQSTS_TOTAL BIGINT act_rqsts_total - Total activity requests monitor elements
TOTAL_ACT_WAIT_TIME BIGINT total_act_wait_time - Total activity wait time monitor element
TOTAL_ACT_TIME BIGINT total_act_time - Total activity time monitor element
LOCK_WAIT_TIME_GLOBAL BIGINT lock_wait_time_global - Lock wait time global monitor element
LOCK_WAITS_GLOBAL BIGINT lock_waits_global - Lock waits global monitor element
RECLAIM_WAIT_TIME BIGINT reclaim_wait_time - Reclaim wait time monitor element
SPACEMAPPAGE_RECLAIM_WAIT_TIME BIGINT spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
LOCK_TIMEOUTS_GLOBAL BIGINT lock_timeouts_global - Lock timeouts global monitor element
LOCK_ESCALS_MAXLOCKS BIGINT lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
LOCK_ESCALS_LOCKLIST BIGINT lock_escals_locklist - Number of locklist lock escalations monitor element
LOCK_ESCALS_GLOBAL BIGINT lock_escals_global - Number of global lock escalations monitor element
CF_WAIT_TIME BIGINT cf_wait_time - cluster caching facility wait time monitor element
CF_WAITS BIGINT cf_waits - Number of cluster caching facility waits monitor element
POOL_DATA_GBP_L_READS BIGINT pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
POOL_DATA_GBP_P_READS BIGINT pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
POOL_DATA_LBP_PAGES_FOUND BIGINT pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
POOL_DATA_GBP_INVALID_PAGES BIGINT pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
POOL_INDEX_GBP_L_READS BIGINT pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
POOL_INDEX_GBP_P_READS BIGINT pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
POOL_INDEX_LBP_PAGES_FOUND BIGINT pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
POOL_INDEX_GBP_INVALID_PAGES BIGINT pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
POOL_XDA_GBP_L_READS BIGINT pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
POOL_XDA_GBP_P_READS BIGINT pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
POOL_XDA_LBP_PAGES_FOUND BIGINT pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
POOL_XDA_GBP_INVALID_PAGES BIGINT pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
EVMON_WAIT_TIME BIGINT evmon_wait_time - Event monitor wait time monitor element
EVMON_WAITS_TOTAL BIGINT evmon_waits_total - Event monitor total waits monitor element
TOTAL_EXTENDED_LATCH_WAIT_TIME BIGINT total_extended_latch_wait_time - Total extended latch wait time monitor element
TOTAL_EXTENDED_LATCH_WAITS BIGINT total_extended_latch_waits - Total extended latch waits monitor element
TOTAL_STATS_FABRICATION_PROC_TIME BIGINT total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
TOTAL_STATS_FABRICATIONS BIGINT total_stats_fabrications - Total statistics fabrications monitor elements
TOTAL_STATS_FABRICATION_TIME BIGINT total_stats_fabrication_time - Total statistics fabrication time monitor element
TOTAL_SYNC_RUNSTATS_PROC_TIME BIGINT total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
TOTAL_SYNC_RUNSTATS BIGINT total_sync_runstats - Total synchronous RUNSTATS activities monitor element
TOTAL_SYNC_RUNSTATS_TIME BIGINT total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
TOTAL_DISP_RUN_QUEUE_TIME BIGINT total_disp_run_queue_time - Total dispatcher run queue time monitor element
POOL_QUEUED_ASYNC_DATA_REQS BIGINT pool_queued_async_data_reqs - Data prefetch requests monitor element
POOL_QUEUED_ASYNC_INDEX_REQS BIGINT pool_queued_async_index_reqs - Index prefetch requests monitor element
POOL_QUEUED_ASYNC_XDA_REQS BIGINT pool_queued_async_xda_reqs - XDA prefetch requests monitor element
POOL_QUEUED_ASYNC_TEMP_DATA_REQS BIGINT pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_INDEX_REQS BIGINT pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_XDA_REQS BIGINT pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_OTHER_REQS BIGINT pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
POOL_QUEUED_ASYNC_DATA_PAGES BIGINT pool_queued_async_data_pages - Data pages prefetch requests monitor element
POOL_QUEUED_ASYNC_INDEX_PAGES BIGINT pool_queued_async_index_pages - Index pages prefetch requests monitor element
POOL_QUEUED_ASYNC_XDA_PAGES BIGINT pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
POOL_QUEUED_ASYNC_TEMP_DATA_PAGES BIGINT pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES BIGINT pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_XDA_PAGES BIGINT pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_DATA_REQS BIGINT pool_failed_async_data_reqs - Failed data prefetch requests monitor element
POOL_FAILED_ASYNC_INDEX_REQS BIGINT pool_failed_async_index_reqs - Failed index prefetch requests monitor element
POOL_FAILED_ASYNC_XDA_REQS BIGINT pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
POOL_FAILED_ASYNC_TEMP_DATA_REQS BIGINT pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_TEMP_INDEX_REQS BIGINT pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_TEMP_XDA_REQS BIGINT pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_OTHER_REQS BIGINT pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
APP_ACT_COMPLETED_TOTAL BIGINT app_act_completed_total - Total successful external coordinator activities monitor element
APP_ACT_ABORTED_TOTAL BIGINT app_act_aborted_total - Total failed external coordinator activities monitor element
APP_ACT_REJECTED_TOTAL BIGINT app_act_rejected_total - Total rejected external coordinator activities monitor element
TOTAL_PEDS BIGINT total_peds - Total partial early distincts monitor element
DISABLED_PEDS BIGINT disabled_peds - Disabled partial early distincts monitor element
POST_THRESHOLD_PEDS BIGINT post_threshold_peds - Partial early distincts threshold monitor element
TOTAL_PEAS BIGINT total_peas - Total partial early aggregations monitor element
POST_THRESHOLD_PEAS BIGINT post_threshold_peas - Partial early aggregation threshold monitor element
TQ_SORT_HEAP_REQUESTS BIGINT tq_sort_heap_requests - Table queue sort heap requests monitor element
TQ_SORT_HEAP_REJECTIONS BIGINT tq_sort_heap_rejections - Table queue sort heap rejections monitor element
TOTAL_CONNECT_REQUEST_PROC_TIME BIGINT total_connect_request_proc_time - Total connection or switch user request processing time monitor element
TOTAL_CONNECT_REQUESTS BIGINT total_connect_requests - Connection or switch user requests monitor element
TOTAL_CONNECT_REQUEST_TIME BIGINT total_connect_request_time - Total connection or switch user request time monitor element
TOTAL_CONNECT_AUTHENTICATION_PROC_TIME BIGINT total_connect_authentication_proc_time - Total connection authentication processing time monitor element
TOTAL_CONNECT_AUTHENTICATIONS BIGINT total_connect_authentications - Connections or switch user authentications performed monitor element
TOTAL_CONNECT_AUTHENTICATION_TIME BIGINT total_connect_authentication_time - Total connection or switch user authentication request time monitor element
PREFETCH_WAIT_TIME BIGINT prefetch_wait_time - Time waited for prefetch monitor element
PREFETCH_WAITS BIGINT prefetch_waits - Prefetcher wait count monitor element
POOL_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
POOL_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
POOL_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
COMM_EXIT_WAIT_TIME BIGINT comm_exit_wait_time - Communication exit wait time monitor element
COMM_EXIT_WAITS BIGINT comm_exit_waits - Communication exit number of waits monitor element
FCM_TQ_RECV_WAITS_TOTAL BIGINT  
FCM_MESSAGE_RECV_WAITS_TOTAL BIGINT  
FCM_TQ_SEND_WAITS_TOTAL BIGINT  
FCM_MESSAGE_SEND_WAITS_TOTAL BIGINT  
FCM_SEND_WAITS_TOTAL BIGINT  
FCM_RECV_WAITS_TOTAL BIGINT  
IDA_SEND_WAIT_TIME BIGINT ida_send_wait_time - Time spent waiting to send data monitor element
IDA_SENDS_TOTAL BIGINT ida_sends_total - Number of times data sent monitor element
IDA_SEND_VOLUME BIGINT ida_send_volume - Total data volume sent monitor element
IDA_RECV_WAIT_TIME BIGINT ida_recv_wait_time - Time spent waiting to receive data monitor element
IDA_RECVS_TOTAL BIGINT ida_recvs_total - Number of times data received monitor element
IDA_RECV_VOLUME BIGINT ida_recv_volume - Total data volume received monitor element
POST_THRESHOLD_COL_VECTOR_CONSUMERS BIGINT post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
TOTAL_COL_VECTOR_CONSUMERS BIGINT total_col_vector_consumers - Total columnar vector memory consumers monitor element
TOTAL_INDEXES_BUILT BIGINT total_indexes_built - Total number of indexes built monitor element
TOTAL_INDEX_BUILD_PROC_TIME BIGINT total_index_build_proc_time - Total non-wait time spent building indexes due to index creation or re-creation monitor element
TOTAL_INDEX_BUILD_TIME BIGINT total_index_build_time - Total time spent building indexes due to index creation or re-creation monitor element
TOTAL_BACKUPS BIGINT total_backups - Total online backups monitor element
TOTAL_BACKUP_PROC_TIME BIGINT total_backup_proc_time - Total non-wait time for online backups monitor element
TOTAL_BACKUP_TIME BIGINT total_backup_time - Total elapsed time for doing online backups monitor element
Table 8. Information returned for a statistics event monitor: Default table name: WLMETRICS_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
LAST_WLM_RESET TIMESTAMP last_wlm_reset - Time of last reset
MON_INTERVAL_ID BIGINT mon_interval_id - Monitor interval identifier
PARTITION_NUMBER SMALLINT partition_number - Partition number
STATISTICS_TIMESTAMP TIMESTAMP statistics_timestamp - Statistics timestamp
WORKLOAD_ID INTEGER workload_id - Workload ID
WORKLOAD_NAME VARCHAR workload_name - Workload name
WLM_QUEUE_TIME_TOTAL BIGINT wlm_queue_time_total - Workload manager total queue time monitor element
WLM_QUEUE_ASSIGNMENTS_TOTAL BIGINT wlm_queue_assignments_total - Workload manager total queue assignments monitor element
FCM_TQ_RECV_WAIT_TIME BIGINT fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
FCM_MESSAGE_RECV_WAIT_TIME BIGINT fcm_message_recv_wait_time - FCM message received wait time monitor element
FCM_TQ_SEND_WAIT_TIME BIGINT fcm_tq_send_wait_time - FCM table queue send wait time monitor element
FCM_MESSAGE_SEND_WAIT_TIME BIGINT fcm_message_send_wait_time - FCM message send wait time monitor element
AGENT_WAIT_TIME BIGINT agent_wait_time - Agent wait time monitor element
AGENT_WAITS_TOTAL BIGINT agent_waits_total - Total agent waits monitor element
LOCK_WAIT_TIME BIGINT lock_wait_time - Time waited on locks monitor element
LOCK_WAITS BIGINT lock_waits - Lock waits monitor element
DIRECT_READ_TIME BIGINT direct_read_time - Direct read time monitor element
DIRECT_READ_REQS BIGINT direct_read_reqs - Direct read requests monitor element
DIRECT_WRITE_TIME BIGINT direct_write_time - Direct write time monitor element
DIRECT_WRITE_REQS BIGINT direct_write_reqs - Direct write requests monitor element
LOG_BUFFER_WAIT_TIME BIGINT log_buffer_wait_time - Log buffer wait time monitor element
NUM_LOG_BUFFER_FULL BIGINT num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
LOG_DISK_WAIT_TIME BIGINT log_disk_wait_time - Log disk wait time monitor element
LOG_DISK_WAITS_TOTAL BIGINT log_disk_waits_total - Total log disk waits monitor element
TCPIP_RECV_WAIT_TIME BIGINT tcpip_recv_wait_time - TCP/IP received wait time monitor element
TCPIP_RECVS_TOTAL BIGINT tcpip_recvs_total - TCP/IP receives total monitor element
CLIENT_IDLE_WAIT_TIME BIGINT client_idle_wait_time - Client idle wait time monitor element
IPC_RECV_WAIT_TIME BIGINT ipc_recv_wait_time - Interprocess communication received wait time monitor element
IPC_RECVS_TOTAL BIGINT ipc_recvs_total - Interprocess communication receives total monitor element
IPC_SEND_WAIT_TIME BIGINT ipc_send_wait_time - Interprocess communication send wait time monitor element
IPC_SENDS_TOTAL BIGINT ipc_sends_total - Interprocess communication send total monitor element
TCPIP_SEND_WAIT_TIME BIGINT tcpip_send_wait_time - TCP/IP send wait time monitor element
TCPIP_SENDS_TOTAL BIGINT tcpip_sends_total - TCP/IP sends total monitor element
POOL_WRITE_TIME BIGINT pool_write_time - Total buffer pool physical write time monitor element
POOL_READ_TIME BIGINT pool_read_time - Total buffer pool physical read time monitor element
AUDIT_FILE_WRITE_WAIT_TIME BIGINT audit_file_write_wait_time - Audit file write wait time monitor element
AUDIT_FILE_WRITES_TOTAL BIGINT audit_file_writes_total - Total audit files written monitor element
AUDIT_SUBSYSTEM_WAIT_TIME BIGINT audit_subsystem_wait_time - Audit subsystem wait time monitor element
AUDIT_SUBSYSTEM_WAITS_TOTAL BIGINT audit_subsystem_waits_total - Total audit subsystem waits monitor element
DIAGLOG_WRITE_WAIT_TIME BIGINT diaglog_write_wait_time - Diagnostic log file write wait time monitor element
DIAGLOG_WRITES_TOTAL BIGINT diaglog_writes_total - Total diagnostic log file writes monitor element
FCM_SEND_WAIT_TIME BIGINT fcm_send_wait_time - FCM send wait time monitor element
FCM_RECV_WAIT_TIME BIGINT fcm_recv_wait_time - FCM received wait time monitor element
TOTAL_WAIT_TIME BIGINT total_wait_time - Total wait time monitor element
RQSTS_COMPLETED_TOTAL BIGINT rqsts_completed_total - Total requests completed monitor element
TOTAL_RQST_TIME BIGINT total_rqst_time - Total request time monitor element
APP_RQSTS_COMPLETED_TOTAL BIGINT app_rqsts_completed_total - Total application requests completed monitor element
TOTAL_APP_RQST_TIME BIGINT total_app_rqst_time - Total application request time monitor element
TOTAL_SECTION_SORT_PROC_TIME BIGINT total_section_sort_proc_time - Total section sort processing time monitor element
TOTAL_SECTION_SORTS BIGINT total_section_sorts - Total section sorts monitor element
TOTAL_SECTION_SORT_TIME BIGINT total_section_sort_time - Total section sort time monitor element
ROWS_READ BIGINT rows_read - Rows read monitor element
ROWS_MODIFIED BIGINT rows_modified - Rows modified monitor element
POOL_DATA_L_READS BIGINT pool_data_l_reads - Buffer pool data logical reads monitor element
POOL_INDEX_L_READS BIGINT pool_index_l_reads - Buffer pool index logical reads monitor element
POOL_TEMP_DATA_L_READS BIGINT pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
POOL_TEMP_INDEX_L_READS BIGINT pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
POOL_XDA_L_READS BIGINT pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
POOL_TEMP_XDA_L_READS BIGINT pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
TOTAL_CPU_TIME BIGINT total_cpu_time - Total CPU time monitor element
ACT_COMPLETED_TOTAL BIGINT act_completed_total - Total completed activities monitor element
POOL_DATA_P_READS BIGINT pool_data_p_reads - Buffer pool data physical reads monitor element
POOL_TEMP_DATA_P_READS BIGINT pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
POOL_XDA_P_READS BIGINT pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
POOL_TEMP_XDA_P_READS BIGINT pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
POOL_INDEX_P_READS BIGINT pool_index_p_reads - Buffer pool index physical reads monitor element
POOL_TEMP_INDEX_P_READS BIGINT pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
POOL_DATA_WRITES BIGINT pool_data_writes - Buffer pool data writes monitor element
POOL_XDA_WRITES BIGINT pool_xda_writes - Buffer pool XDA data writes monitor element
POOL_INDEX_WRITES BIGINT pool_index_writes - Buffer pool index writes monitor element
DIRECT_READS BIGINT direct_reads - Direct reads from database monitor element
DIRECT_WRITES BIGINT direct_writes - Direct writes to database monitor element
ROWS_RETURNED BIGINT rows_returned - Rows returned monitor element
DEADLOCKS BIGINT deadlocks - Deadlocks detected monitor element
LOCK_TIMEOUTS BIGINT lock_timeouts - Number of lock timeouts monitor element
LOCK_ESCALS BIGINT lock_escals - Number of lock escalations monitor element
FCM_SENDS_TOTAL BIGINT fcm_sends_total - FCM sends total monitor element
FCM_RECVS_TOTAL BIGINT fcm_recvs_total - FCM receives total monitor element
FCM_SEND_VOLUME BIGINT fcm_send_volume - FCM send volume monitor element
FCM_RECV_VOLUME BIGINT fcm_recv_volume - FCM received volume monitor element
FCM_MESSAGE_SENDS_TOTAL BIGINT fcm_message_sends_total - Total FCM message sends monitor element
FCM_MESSAGE_RECVS_TOTAL BIGINT fcm_message_recvs_total - Total FCM message receives monitor element
FCM_MESSAGE_SEND_VOLUME BIGINT fcm_message_send_volume - FCM message send volume monitor element
FCM_MESSAGE_RECV_VOLUME BIGINT fcm_message_recv_volume - FCM message received volume monitor element
FCM_TQ_SENDS_TOTAL BIGINT fcm_tq_sends_total - FCM table queue send total monitor element
FCM_TQ_RECVS_TOTAL BIGINT fcm_tq_recvs_total - FCM table queue receives total monitor element
FCM_TQ_SEND_VOLUME BIGINT fcm_tq_send_volume - FCM table queue send volume monitor element
FCM_TQ_RECV_VOLUME BIGINT fcm_tq_recv_volume - FCM table queue received volume monitor element
TQ_TOT_SEND_SPILLS BIGINT tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
TCPIP_SEND_VOLUME BIGINT tcpip_send_volume - TCP/IP send volume monitor element
TCPIP_RECV_VOLUME BIGINT tcpip_recv_volume - TCP/IP received volume monitor element
IPC_SEND_VOLUME BIGINT ipc_send_volume - Interprocess communication send volume monitor element
IPC_RECV_VOLUME BIGINT ipc_recv_volume - Interprocess communication received volume monitor element
POST_THRESHOLD_SORTS BIGINT post_threshold_sorts - Post threshold sorts monitor element
POST_SHRTHRESHOLD_SORTS BIGINT post_shrthreshold_sorts - Post shared threshold sorts monitor element
SORT_OVERFLOWS BIGINT sort_overflows - Sort overflows monitor element
AUDIT_EVENTS_TOTAL BIGINT audit_events_total - Total audit events monitor element
TOTAL_RQST_MAPPED_IN BIGINT total_rqst_mapped_in - Total request mapped-in monitor element
TOTAL_RQST_MAPPED_OUT BIGINT total_rqst_mapped_out - Total request mapped-out monitor element
ACT_REJECTED_TOTAL BIGINT act_rejected_total - Total rejected activities monitor element
ACT_ABORTED_TOTAL BIGINT act_aborted_total - Total aborted activities monitor element
TOTAL_SORTS BIGINT total_sorts - Total sorts monitor element
TOTAL_ROUTINE_TIME BIGINT total_routine_time - Total routine time monitor element
TOTAL_COMPILE_PROC_TIME BIGINT total_compile_proc_time - Total compile processing time monitor element
TOTAL_COMPILATIONS BIGINT total_compilations - Total compilations monitor element
TOTAL_COMPILE_TIME BIGINT total_compile_time - Total compile time monitor element
TOTAL_IMPLICIT_COMPILE_PROC_TIME BIGINT total_implicit_compile_proc_time - Total implicit compile processing time monitor element
TOTAL_IMPLICIT_COMPILATIONS BIGINT total_implicit_compilations - Total implicit compilations monitor element
TOTAL_IMPLICIT_COMPILE_TIME BIGINT total_implicit_compile_time - Total implicit compile time monitor element
TOTAL_RUNSTATS_PROC_TIME BIGINT total_runstats_proc_time - Total runtime statistics processing time monitor element
TOTAL_RUNSTATS BIGINT total_runstats - Total runtime statistics monitor element
TOTAL_RUNSTATS_TIME BIGINT total_runstats_time - Total runtime statistics time monitor element
TOTAL_REORG_PROC_TIME BIGINT total_reorg_proc_time - Total reorganization processing time monitor element
TOTAL_REORGS BIGINT total_reorgs - Total reorganizations monitor element
TOTAL_REORG_TIME BIGINT total_reorg_time - Total reorganization time monitor element
TOTAL_LOAD_PROC_TIME BIGINT total_load_proc_time - Total load processing time monitor element
TOTAL_LOADS BIGINT total_loads - Total loads monitor element
TOTAL_LOAD_TIME BIGINT total_load_time - Total load time monitor element
TOTAL_SECTION_PROC_TIME BIGINT total_section_proc_time - Total section processing time monitor element
TOTAL_APP_SECTION_EXECUTIONS BIGINT total_app_section_executions - Total application section executions monitor element
TOTAL_SECTION_TIME v total_section_time - Total section time monitor element
TOTAL_COMMIT_PROC_TIME BIGINT total_commit_proc_time - Total commits processing time monitor element
TOTAL_APP_COMMITS BIGINT total_app_commits - Total application commits monitor elements
TOTAL_COMMIT_TIME BIGINT total_commit_time - Total commit time monitor element
TOTAL_ROLLBACK_PROC_TIME BIGINT total_rollback_proc_time - Total rollback processing time monitor element
TOTAL_APP_ROLLBACKS BIGINT total_app_rollbacks - Total application rollbacks monitor element
TOTAL_ROLLBACK_TIME BIGINT total_rollback_time - Total rollback time monitor element
TOTAL_ROUTINE_USER_CODE_PROC_TIME BIGINT total_routine_user_code_proc_time - Total routine user code processing time monitor element
TOTAL_ROUTINE_USER_CODE_TIME BIGINT total_routine_user_code_time - Total routine user code time monitor element
THRESH_VIOLATIONS BIGINT thresh_violations - Number of threshold violations monitor element
NUM_LW_THRESH_EXCEEDED BIGINT num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
TOTAL_ROUTINE_INVOCATIONS BIGINT total_routine_invocations - Total routine invocations monitor elements
INT_COMMITS BIGINT int_commits - Internal commits monitor element
INT_ROLLBACKS BIGINT int_rollbacks - Internal rollbacks monitor element
CAT_CACHE_INSERTS BIGINT cat_cache_inserts - Catalog cache inserts monitor element
CAT_CACHE_LOOKUPS BIGINT cat_cache_lookups - Catalog cache lookups monitor element
PKG_CACHE_INSERTS BIGINT pkg_cache_inserts - Package cache inserts monitor element
PKG_CACHE_LOOKUPS BIGINT pkg_cache_lookups - Package cache lookups monitor element
ACT_RQSTS_TOTAL BIGINT act_rqsts_total - Total activity requests monitor elements
TOTAL_ACT_WAIT_TIME BIGINT total_act_wait_time - Total activity wait time monitor element
TOTAL_ACT_TIME BIGINT total_act_time - Total activity time monitor element
LOCK_WAIT_TIME_GLOBAL BIGINT lock_wait_time_global - Lock wait time global monitor element
LOCK_WAITS_GLOBAL BIGINT lock_waits_global - Lock waits global monitor element
RECLAIM_WAIT_TIME BIGINT reclaim_wait_time - Reclaim wait time monitor element
SPACEMAPPAGE_RECLAIM_WAIT_TIME BIGINT spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
LOCK_TIMEOUTS_GLOBAL BIGINT lock_timeouts_global - Lock timeouts global monitor element
LOCK_ESCALS_MAXLOCKS BIGINT lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
LOCK_ESCALS_LOCKLIST BIGINT lock_escals_locklist - Number of locklist lock escalations monitor element
LOCK_ESCALS_GLOBAL BIGINT lock_escals_global - Number of global lock escalations monitor element
CF_WAIT_TIME BIGINT cf_wait_time - cluster caching facility wait time monitor element
CF_WAITS BIGINT cf_waits - Number of cluster caching facility waits monitor element
POOL_DATA_GBP_L_READS BIGINT pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
POOL_DATA_GBP_P_READS BIGINT pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
POOL_DATA_LBP_PAGES_FOUND BIGINT pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
POOL_DATA_GBP_INVALID_PAGES BIGINT pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
POOL_INDEX_GBP_L_READS BIGINT pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
POOL_INDEX_GBP_P_READS BIGINT pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
POOL_INDEX_LBP_PAGES_FOUND BIGINT pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
POOL_INDEX_GBP_INVALID_PAGES BIGINT pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
POOL_XDA_GBP_L_READS BIGINT pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
POOL_XDA_GBP_P_READS BIGINT pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
POOL_XDA_LBP_PAGES_FOUND BIGINT pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
POOL_XDA_GBP_INVALID_PAGES BIGINT pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
EVMON_WAIT_TIME BIGINT evmon_wait_time - Event monitor wait time monitor element
EVMON_WAITS_TOTAL BIGINT evmon_waits_total - Event monitor total waits monitor element
TOTAL_EXTENDED_LATCH_WAIT_TIME BIGINT total_extended_latch_wait_time - Total extended latch wait time monitor element
TOTAL_EXTENDED_LATCH_WAITS BIGINT total_extended_latch_waits - Total extended latch waits monitor element
TOTAL_STATS_FABRICATION_PROC_TIME BIGINT total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
TOTAL_STATS_FABRICATIONS BIGINT total_stats_fabrications - Total statistics fabrications monitor elements
TOTAL_STATS_FABRICATION_TIME BIGINT total_stats_fabrication_time - Total statistics fabrication time monitor element
TOTAL_SYNC_RUNSTATS_PROC_TIME BIGINT total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
TOTAL_SYNC_RUNSTATS BIGINT total_sync_runstats - Total synchronous RUNSTATS activities monitor element
TOTAL_SYNC_RUNSTATS_TIME BIGINT total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
TOTAL_DISP_RUN_QUEUE_TIME BIGINT total_disp_run_queue_time - Total dispatcher run queue time monitor element
POOL_QUEUED_ASYNC_DATA_REQS BIGINT pool_queued_async_data_reqs - Data prefetch requests monitor element
POOL_QUEUED_ASYNC_INDEX_REQS BIGINT pool_queued_async_index_reqs - Index prefetch requests monitor element
POOL_QUEUED_ASYNC_XDA_REQS BIGINT pool_queued_async_xda_reqs - XDA prefetch requests monitor element
POOL_QUEUED_ASYNC_TEMP_DATA_REQS BIGINT pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_INDEX_REQS BIGINT pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_XDA_REQS BIGINT pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_OTHER_REQS BIGINT pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
POOL_QUEUED_ASYNC_DATA_PAGES BIGINT pool_queued_async_data_pages - Data pages prefetch requests monitor element
POOL_QUEUED_ASYNC_INDEX_PAGES BIGINT pool_queued_async_index_pages - Index pages prefetch requests monitor element
POOL_QUEUED_ASYNC_XDA_PAGES BIGINT pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
POOL_QUEUED_ASYNC_TEMP_DATA_PAGES BIGINT pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES BIGINT pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_XDA_PAGES BIGINT pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_DATA_REQS BIGINT pool_failed_async_data_reqs - Failed data prefetch requests monitor element
POOL_FAILED_ASYNC_INDEX_REQS BIGINT pool_failed_async_index_reqs - Failed index prefetch requests monitor element
POOL_FAILED_ASYNC_XDA_REQS BIGINT pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
POOL_FAILED_ASYNC_TEMP_DATA_REQS BIGINT pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_TEMP_INDEX_REQS BIGINT pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_TEMP_XDA_REQS BIGINT pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_OTHER_REQS BIGINT pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
APP_ACT_COMPLETED_TOTAL BIGINT app_act_completed_total - Total successful external coordinator activities monitor element
APP_ACT_ABORTED_TOTAL BIGINT app_act_aborted_total - Total failed external coordinator activities monitor element
APP_ACT_REJECTED_TOTAL BIGINT app_act_rejected_total - Total rejected external coordinator activities monitor element
TOTAL_PEDS BIGINT total_peds - Total partial early distincts monitor element
DISABLED_PEDS BIGINT disabled_peds - Disabled partial early distincts monitor element
POST_THRESHOLD_PEDS BIGINT post_threshold_peds - Partial early distincts threshold monitor element
TOTAL_PEAS BIGINT total_peas - Total partial early aggregations monitor element
POST_THRESHOLD_PEAS BIGINT post_threshold_peas - Partial early aggregation threshold monitor element
TQ_SORT_HEAP_REQUESTS BIGINT tq_sort_heap_requests - Table queue sort heap requests monitor element
TQ_SORT_HEAP_REJECTIONS BIGINT tq_sort_heap_rejections - Table queue sort heap rejections monitor element
TOTAL_CONNECT_REQUEST_PROC_TIME BIGINT total_connect_request_proc_time - Total connection or switch user request processing time monitor element
TOTAL_CONNECT_REQUESTS BIGINT total_connect_requests - Connection or switch user requests monitor element
TOTAL_CONNECT_REQUEST_TIME BIGINT total_connect_request_time - Total connection or switch user request time monitor element
TOTAL_CONNECT_AUTHENTICATION_PROC_TIME BIGINT total_connect_authentication_proc_time - Total connection authentication processing time monitor element
TOTAL_CONNECT_AUTHENTICATIONS BIGINT total_connect_authentications - Connections or switch user authentications performed monitor element
TOTAL_CONNECT_AUTHENTICATION_TIME BIGINT total_connect_authentication_time - Total connection or switch user authentication request time monitor element
PREFETCH_WAIT_TIME BIGINT prefetch_wait_time - Time waited for prefetch monitor element
PREFETCH_WAITS BIGINT prefetch_waits - Prefetcher wait count monitor element
POOL_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
POOL_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
POOL_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
COMM_EXIT_WAIT_TIME BIGINT comm_exit_wait_time - Communication exit wait time monitor element
COMM_EXIT_WAITS BIGINT comm_exit_waits - Communication exit number of waits monitor element
FCM_TQ_RECV_WAITS_TOTAL BIGINT  
FCM_MESSAGE_RECV_WAITS_TOTAL BIGINT  
FCM_TQ_SEND_WAITS_TOTAL BIGINT  
FCM_MESSAGE_SEND_WAITS_TOTAL BIGINT  
FCM_SEND_WAITS_TOTAL BIGINT  
FCM_RECV_WAITS_TOTAL BIGINT  
IDA_SEND_WAIT_TIME BIGINT ida_send_wait_time - Time spent waiting to send data monitor element
IDA_SENDS_TOTAL BIGINT ida_sends_total - Number of times data sent monitor element
IDA_SEND_VOLUME BIGINT ida_send_volume - Total data volume sent monitor element
IDA_RECV_WAIT_TIME BIGINT ida_recv_wait_time - Time spent waiting to receive data monitor element
IDA_RECVS_TOTAL BIGINT ida_recvs_total - Number of times data received monitor element
IDA_RECV_VOLUME BIGINT ida_recv_volume - Total data volume received monitor element
POST_THRESHOLD_COL_VECTOR_CONSUMERS BIGINT post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
TOTAL_COL_VECTOR_CONSUMERS BIGINT total_col_vector_consumers - Total columnar vector memory consumers monitor element
TOTAL_INDEXES_BUILT BIGINT total_indexes_built - Total number of indexes built monitor element
TOTAL_INDEX_BUILD_PROC_TIME BIGINT total_index_build_proc_time - Total non-wait time spent building indexes due to index creation or re-creation monitor element
TOTAL_INDEX_BUILD_TIME BIGINT total_index_build_time - Total time spent building indexes due to index creation or re-creation monitor element
TOTAL_BACKUPS BIGINT total_backups - Total online backups monitor element
TOTAL_BACKUP_PROC_TIME BIGINT total_backup_proc_time - Total non-wait time for online backups monitor element
TOTAL_BACKUP_TIME BIGINT total_backup_time - Total elapsed time for doing online backups monitor element
Table 9. Information returned for a statistics event monitor: Default table name: OSMETRICS_evmon-name
Column name Data type Description
PARTITION_KEY INTEGER partition_key - Partitioning key monitor element
PARTITION_NUMBER SMALLINT partition_number - Partition number
STATISTICS_TIMESTAMP TIMESTAMP statistics_timestamp - Statistics timestamp
LAST_WLM_RESET TIMESTAMP last_wlm_reset - Time of last reset
MON_INTERVAL_ID BIGINT mon_interval_id - Monitor interval identifier
CPU_TOTAL BIGINT cpu_total - Number of CPUs monitor element
CPU_ONLINE BIGINT cpu_online - Number of CPUs online monitor element
CPU_CONFIGURED BIGINT cpu_configured - Number of configured CPUs monitor element
CPU_SPEED BIGINT cpu_speed - CPU clock speed monitor element
CPU_TIMEBASE BIGINT cpu_timebase - Frequency of timebase register increment monitor element
CPU_HMT_DEGREE BIGINT cpu_hmt_degree - Number of logical CPUs monitor element
CPU_CORES_PER_SOCKET BIGINT cpu_cores_per_socket - Number of CPU cores per socket monitor element
MEMORY_TOTAL BIGINT memory_total - Total physical memory monitor element
MEMORY_FREE BIGINT memory_free - Amount of free physical memory monitor element
MEMORY_SWAP_TOTAL BIGINT memory_swap_total - Total swap space monitor element
MEMORY_SWAP_FREE BIGINT memory_swap_free - Total free swap space monitor element
VIRTUAL_MEM_TOTAL BIGINT virtual_mem_total - Total virtual memory monitor element
VIRTUAL_MEM_RESERVED BIGINT virtual_mem_reserved - Reserved virtual memory monitor element
VIRTUAL_MEM_FREE BIGINT virtual_mem_free - Free virtual memory monitor element
CPU_LOAD_SHORT DOUBLE cpu_load_short - Processor load (short timeframe) monitor element
CPU_LOAD_MEDIUM DOUBLE cpu_load_medium - Processor load (medium timeframe) monitor element
CPU_LOAD_LONG DOUBLE cpu_load_long - Processor load (long timeframe) monitor element
CPU_USAGE_TOTAL SMALLINT cpu_usage_total - Processor usage monitor element
CPU_USER BIGINT cpu_user - Non-kernel processing time monitor element
CPU_IDLE BIGINT cpu_idle - Processor idle time monitor element
CPU_IOWAIT BIGINT cpu_iowait - IO Wait time monitor element
CPU_SYSTEM BIGINT cpu_system - Kernel time monitor element
SWAP_PAGE_SIZE BIGINT swap_page_size - Swap page size monitor element
SWAP_PAGES_IN BIGINT swap_pages_in - Pages swapped in from disk monitor element
SWAP_PAGES_OUT BIGINT swap_pages_out - Pages swapped out to disk monitor element
Table 10. 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 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