Event monitor logical data groups and monitor elements
Monitor elements that are often useful to examine
together are grouped in logical data groups.
All event monitors use logical
data groups in one way or another. For some event monitor types, you can
specify what information you want to collect by specifying the logical data groups for which you
want information recorded. Logical data groups are also used to group data together in the output
event monitors generate; for example, event monitors that write to tables generally create one table
for each logical data group of monitor elements.
The following table lists the logical data groupings and monitor elements that can be
returned by event monitoring.
- changesummary logical data group
- dbdbmcfg logical data group
- ddlstmtexec logical data group
- dllock logical data group
- event_activity logical data group
- event_activitymetrics logical data group
- event_activitystmt logical data group
- event_activityvals logical data group
- event_bufferpool logical data group
- event_conn logical data group
- event_connheader logical data group
- event_connmemuse logical data group
- event_data_value logical data group
- event_db logical data group
- event_dbheader logical data group
- event_dbmemuse logical data group
- event_deadlock logical data group
- event_detailed_dlconn logical data group
- event_dlconn logical data group
- event_histogrambin logical data group
- event_log_header logical data group
- event_overflow logical data group
- event_qstats logical data group
- event_osmetrics logical data group
- event_scmetrics logical data group
- event_scstats logical data group
- event_start logical data group
- event_stmt logical data group
- event_stmt_history logical data group
- event_subsection logical data group
- event_superclassmetrics logical data group
- event_superclassstats logical data group
- event_table logical data group
- event_tablespace logical data group
- event_thresholdviolations logical data group
- event_wcstats logical data group
- event_wlmetrics logical data group
- event_wlstats logical data group
- event_xact logical data group
- evmonstart logical data group
- lock logical data group
- lock_participants logical data group
- lock_participant_activities logical data group
- lock_activity_values logical data group
- pkgcache logical data group
- pkgcache_metrics logical data group
- pkgcache_stmt_args logical data group
- regvar logical data group
- txncompletion logical data group
- uow logical data group
- uow_metrics logical data group
- uow_package_list logical data group
- uow_executable_list logical data group
- utillocation logical data group
- utilphase logical data group
- utilstart logical data group
- utilstop logical data group
changesummary logical data group
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- application_handle - Application handle monitor element
- backup_timestamp - Backup timestamp monitor element
- client_acctng - Client accounting string monitor element
- client_applname - Client application name monitor element
- client_hostname - Client hostname monitor element
- client_pid - Client process ID monitor element
- client_platform - Client operating platform monitor element
- client_port_number - Client port number monitor element
- client_protocol - Client communication protocol monitor element
- client_userid - Client user ID monitor element
- client_wrkstnname - Client workstation name monitor element
- coord_member - Coordinator member monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
- session_auth_id - Session authorization ID monitor element
- system_auth_id - System authorization identifier monitor element
- tenant_id - Tenant identifier monitor element
- tenant_name - Tenant name monitor element
- utility_invocation_id - Utility invocation ID monitor element
- utility_type - Utility Type monitor element
dbdbmcfg logical data group
- cfg_collection_type - Configuration collection type monitor element
- cfg_name - Configuration name monitor element
- cfg_old_value - Configuration old value monitor element
- cfg_old_value_flags - Configuration old value flags monitor element
- cfg_value - Configuration value monitor element
- cfg_value_flags - Configuration value flags monitor element
- deferred - Deferred monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
ddlstmtexec logical data group
- ddl_classification - DDL classification monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- global_transaction_id - Global transaction identifier monitor element
- local_transaction_id - Local transaction identifier monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
- savepoint_id - Savepoint ID monitor element
- stmt_text - SQL statement text monitor element
- uow_id - Unit of work ID monitor element
dllock logical data group
- data_partition_id - Data partition identifier monitor element
- lock_attributes - Lock attributes monitor element
- lock_count - Lock count monitor element
- lock_current_mode - Original lock mode before conversion monitor element
- lock_escalation - Lock escalation monitor element
- lock_hold_count - Lock hold count monitor element
- lock_mode - Lock mode monitor element
- lock_name - Lock name monitor element
- lock_object_name - Lock Object Name monitor element
- lock_object_type - Lock object type waited on monitor element
- lock_release_flags - Lock release flags monitor element
- lock_status - Lock status monitor element
- node_number - Node Number monitor element
- table_file_id - Table file ID monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- tablespace_name - Table space name monitor element
Note: The underlying implementation for this logical data group is the
snapshot monitor LOCK logical data group. If you examine the output for this logical group in the
self-describing stream used for the file and pipe output options, you can see that the LOCK group is
used to generate the output.
event_activity logical data group
- act_exec_time - Activity execution time monitor element
- act_sortmem_limit_pages - Activity sort memory limit (4k pages) monitor element
- activate_timestamp - Activate timestamp monitor element
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- activity_id - Activity ID monitor element
- activity_secondary_id - Activity secondary ID monitor element
- activity_type - Activity type monitor element
- act_sortmem_limit_pct - Activity sort memory limit (percentage) monitor element
- address - IP address from which the connection was initiated
- adm_bypassed - Admission control bypassed monitor element
- agent_id - Application handle (agent ID) monitor element
- agents_top - Number of Agents Created monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- application_handle - Application handle monitor element
- arm_correlator - Application response measurement correlator monitor element
- coord_partition_num - Coordinator partition number monitor element
- coord_time_created - Time of execution on member monitor element
- db_work_action_set_id - Database work action set ID monitor element
- db_work_class_id - Database work class ID monitor element
- details_xml - Details XML monitor element
- effective_query_degree - Effective query degree monitor element
- estimated_runtime - Estimated execution time for a DML statement monitor element
- event_timestamp - Event timestamp monitor element
- estimated_sort_consumers_top - Estimated concurrently executing sort memory consumers monitor element
- estimated_sort_shrheap_top - Estimated shared sort heap consumption monitor element
- mon_interval_id - Monitor interval identifier monitor element
- num_remaps - Number of remaps monitor element
- parent_activity_id - Parent activity ID monitor element
- parent_uow_id - Parent unit of work ID monitor element
- partial_record - Partial Record monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- prep_time - Preparation time monitor element
- query_actual_degree - Actual runtime degree of intrapartition parallelism monitor element
- query_card_estimate - Query Number of Rows Estimate monitor element
- query_cost_estimate - Query cost estimate monitor element
- query_data_tag_list - Estimated query data tag list monitor element
- rows_fetched - Rows fetched monitor element
- rows_modified - Rows modified monitor element
- rows_returned - Rows returned monitor element
- sc_work_action_set_id - Service class work action set ID monitor element
- sc_work_class_id - Service class work class ID monitor element
- section_actuals - Section actuals monitor element
- service_subclass_name - Service subclass name monitor element
- service_superclass_name - Service superclass name monitor element
- session_auth_id - Session authorization ID monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_overflows - Sort overflows monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- sqlca - SQL Communications Area (SQLCA) monitor element
- system_cpu_time - System CPU time monitor element
- tenant_id - Tenant identifier monitor element
- tenant_name - Tenant name monitor element
- time_completed - Time completed monitor element
- time_created - Time created monitor element
- time_started - Time started monitor element
- total_sort_time - Total sort time monitor element
- total_sorts - Total sorts monitor element
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
- tpmon_acc_str - TP monitor client accounting string monitor element
- tpmon_client_app - TP monitor client application name monitor element
- tpmon_client_userid - TP monitor client user ID monitor element
- tpmon_client_wkstn - TP monitor client workstation name monitor element
- uow_id - Unit of work ID monitor element
- user_cpu_time - User CPU time monitor element
- wl_work_action_set_id - Workload work action set identifier monitor element
- wl_work_class_id - Workload work class identifier monitor element
- workload_id - Workload ID monitor element
- workload_occurrence_id - Workload occurrence identifier monitor element
event_activitymetrics logical data group
- activity_id - Activity ID monitor element
- activity_secondary_id - Activity secondary ID monitor element
- adm_bypass_act_total - Number of times admission control was bypassed monitor element
- adm_overflows - Number of times an activity fit as an overflow monitor element
- appl_id - Application ID monitor element
- application_handle - Application handle monitor element
- audit_events_total - Total audit events monitor element
- audit_file_write_wait_time - Audit file write wait time monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- caching_tier_direct_reads - Direct reads from caching tier monitor element
- caching_tier_direct_read_reqs - Direct read requests from caching tier monitor element
- caching_tier_page_read_time - Caching tier page read time monitor element
- cf_wait_time - cluster caching facility wait time monitor element
- cf_waits - Number of cluster caching facility waits monitor element
- col_vector_consumer_overflows - Columnar vector consumer overflows monitor element
- coord_stmt_exec_time - Execution time for statement by coordinator agent monitor element
- coord_time_created - Time of execution on member monitor element
- deadlocks - Deadlocks detected monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- disabled_peds - Disabled partial early distincts monitor element
- event_timestamp - Event timestamp monitor element
- evmon_wait_time - Event monitor wait time monitor element
- evmon_waits_total - Event monitor total waits monitor element
- ext_table_read_volume - Total data read by external table readers monitor element
- ext_table_recv_volume - Total data received from external table readers monitor element
- ext_table_recv_wait_time - Total agent wait time for external table readers monitor element
- ext_table_recvs_total - Total row batches received from external table readers monitor element
- ext_table_send_volume - Total data sent to external table writers monitor element
- ext_table_send_wait_time - Total agent wait time for external table writers monitor element
- ext_table_sends_total - Total row batches sent to external table writers monitor element
- ext_table_write_volume - Total data written by external table writers monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- fed_rows_deleted - Rows deleted by a federation system monitor element
- fed_rows_inserted - Rows inserted by a federation system monitor element
- fed_rows_read - Rows read by a federation system monitor element
- fed_rows_updated - Rows updated by a federation system monitor element
- fed_wait_time - Time spent by a federation server monitor element
- fed_waits_total - Total number of execution times for a federation server monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- lob_prefetch_reqs - LOB prefetcher request count monitor element
- lob_prefetch_wait_time - Wait time for prefetcher for LOB read or write monitor element
- lock_escals - Number of lock escalations monitor element
- lock_escals_global - Number of global lock escalations monitor element
- lock_escals_locklist - Number of locklist lock escalations monitor element
- lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_timeouts_global - Lock timeouts global monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_wait_time_global - Lock wait time global monitor element
- lock_waits - Lock waits monitor element
- lock_waits_global - Lock waits global monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- pool_caching_tier_page_read_time - Buffer pool caching tier page read time monitor element
- pool_col_caching_tier_l_reads - Buffer pool column-organized caching tier logical reads monitor element
- pool_col_caching_tier_pages_found - Buffer pool column-organized pages found in caching tier monitor element
- pool_data_caching_tier_l_reads - Buffer pool data caching tier logical reads monitor element
- pool_data_caching_tier_pages_found - Buffer pool data pages found in caching tier monitor element
- pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_failed_async_data_reqs - Failed data prefetch requests monitor element
- pool_failed_async_index_reqs - Failed index prefetch requests monitor element
- pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
- pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
- pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
- pool_index_caching_tier_l_reads - Buffer pool index caching tier logical reads monitor element
- pool_index_caching_tier_pages_found - Buffer pool index pages found in caching tier monitor element
- pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_queued_async_data_pages - Data pages prefetch requests monitor element
- pool_queued_async_data_reqs - Data prefetch requests monitor element
- pool_queued_async_index_pages - Index pages prefetch requests monitor element
- pool_queued_async_index_reqs - Index prefetch requests monitor element
- pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
- pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
- pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
- pool_queued_async_xda_reqs - XDA prefetch requests monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_col_caching_tier_l_reads - Buffer pool temporary column-organized caching tier logical reads monitor element
- pool_temp_col_caching_tier_pages_found - Buffer pool temporary column-organized pages found in caching tier monitor element
- pool_temp_data_caching_tier_l_reads - Buffer pool temporary data caching tier logical reads monitor element
- pool_temp_data_caching_tier_pages_found - Buffer pool temporary data pages found in caching tier monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_caching_tier_l_reads - Buffer pool temporary index caching tier logical reads monitor element
- pool_temp_index_caching_tier_pages_found - Buffer pool temporary index pages found in caching tier monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_caching_tier_l_reads - Buffer pool temporary XML data caching tier logical reads monitor element
- pool_temp_xda_caching_tier_pages_found - Buffer pool temporary XDA data pages found in caching tier monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_caching_tier_l_reads - Buffer pool XML data caching tier logical reads monitor element
- pool_xda_caching_tier_pages_found - Buffer pool XDA data pages found in caching tier monitor element
- pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- post_threshold_peas - Partial early aggregation threshold monitor element
- post_threshold_peds - Partial early distincts threshold monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- prefetch_waits - Prefetcher wait count monitor element
- reclaim_wait_time - Reclaim wait time monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_modified - Rows modified monitor element
- rows_read - Rows read monitor element
- rows_returned - Rows returned monitor element
- rows_updated - Rows updated monitor element
- sort_overflows - Sort overflows monitor element
- spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
- stmt_exec_time - Statement execution time monitor element
- thresh_violations - Number of threshold violations monitor element
- total_act_time - Total activity time monitor element
- total_act_wait_time - Total activity wait time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- total_extended_latch_wait_time - Total extended latch wait time monitor element
- total_extended_latch_waits - Total extended latch waits monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- 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 - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_peas - Total partial early aggregations monitor element
- total_peds - Total partial early distincts monitor element
- total_routine_invocations - Total routine invocations monitor elements
- total_routine_non_sect_proc_time - Non-section processing time monitor element
- total_routine_non_sect_time - Non-section routine execution time monitor elements
- total_routine_time - Total routine time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- total_section_proc_time - Total section processing time monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sort_time - Total section sort time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_time - Total section time monitor element
- total_sorts - Total sorts monitor element
- tq_sort_heap_rejections - Table queue sort heap rejections monitor element
- tq_sort_heap_requests - Table queue sort heap requests monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- uow_id - Unit of work ID monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
event_activitystmt logical data group
- activate_timestamp - Activate timestamp monitor element
- activity_id - Activity ID monitor element
- activity_secondary_id - Activity secondary ID monitor element
- appl_id - Application ID monitor element
- application_handle - Application handle monitor element
- comp_env_desc - Compilation environment monitor element
- coord_time_created - Time of execution on member monitor element
- creator - Application Creator monitor element
- eff_stmt_text - Effective statement text monitor element
- event_timestamp - Event timestamp monitor element
- executable_id - Executable ID monitor element
- num_routines - Number of routines monitor element
- package_name - Package name monitor element
- package_version_id - Package version monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- planid - Query plan ID monitor element
- routine_id - Routine ID monitor element
- section_env - Section environment monitor element
- section_number - Section number monitor element
- semantic_env_id - Query semantic compilation environment ID monitor element
- stmt_first_use_time - Statement first use timestamp monitor element
- stmt_invocation_id - Statement invocation identifier monitor element
- stmt_isolation - Statement isolation monitor element
- stmt_last_use_time - Statement last use timestamp monitor element
- stmt_lock_timeout - Statement lock timeout monitor element
- stmt_nest_level - Statement nesting level monitor element
- stmt_pkg_cache_id - Statement package cache identifier monitor element
- stmt_query_id - Statement query identifier monitor element
- stmt_source_id - Statement source identifier monitor element
- stmt_text - SQL statement text monitor element
- stmt_type - Statement type monitor element
- stmtid - Query statement ID monitor element
- stmtno - Statement number monitor element
- uow_id - Unit of work ID monitor element
event_activityvals logical data group
- activate_timestamp - Activate timestamp monitor element
- activity_id - Activity ID monitor element
- activity_secondary_id - Activity secondary ID monitor element
- appl_id - Application ID monitor element
- application_handle - Application handle monitor element
- coord_time_created - Time of execution on member monitor element
- event_timestamp - Event timestamp monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- stmt_value_data - Value data monitor element
- stmt_value_index - Value index monitor element
- stmt_value_isnull - Value has null value monitor element
- stmt_value_isreopt - Variable used for statement reoptimization monitor element
- stmt_value_type - Value type monitor element
- uow_id - Unit of work ID monitor element
event_bufferpool logical data group
- block_ios - Number of block I/O requests monitor element
- bp_id - Buffer pool identifier monitor element
- bp_name - Buffer pool name monitor element
- db_name - Database name monitor element
- db_path - Database Path monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- event_time - Event Time monitor element
- evmon_activates - Number of event monitor activations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- files_closed - Database files closed monitor element
- pages_from_block_ios - Total number of pages read by block I/O monitor element
- pages_from_vectored_ios - Total number of pages read by vectored I/O monitor element
- partial_record - Partial Record monitor element
- pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
- pool_async_data_reads - Buffer pool asynchronous data reads monitor element
- pool_async_data_writes - Buffer pool asynchronous data writes monitor element
- pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
- pool_async_index_reads - Buffer pool asynchronous index reads monitor element
- pool_async_index_writes - Buffer pool asynchronous index writes monitor element
- pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element
- pool_async_write_time - Buffer pool asynchronous write time monitor element
- pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
- pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
- pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_no_victim_buffer - Buffer pool no victim buffers monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- unread_prefetch_pages - Unread prefetch pages monitor element
- vectored_ios - Number of vectored I/O requests monitor element
event_conn logical data group
- acc_curs_blk - Accepted Block Cursor Requests monitor element
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_priority - Application Agent Priority monitor element
- appl_priority_type - Application Priority Type monitor element
- appl_section_inserts - Section Inserts monitor element
- appl_section_lookups - Section Lookups monitor element
- appl_status - Application status monitor element
- authority_bitmap - User authorization level monitor element
- authority_lvl - User authorization level monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- cat_cache_heap_full - Catalog cache heap full monitor element monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- cat_cache_overflows - Catalog Cache Overflows monitor element
- cat_cache_size_top - Catalog cache high watermark monitor element
- commit_sql_stmts - Commit Statements Attempted monitor element
- coord_node - Coordinating Node monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- deadlocks - Deadlocks detected monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- disconn_time - Database Deactivation Timestamp monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- elapsed_exec_time - Statement Execution Elapsed Time monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- int_auto_rebinds - Internal Automatic Rebinds monitor element
- int_commits - Internal commits monitor element
- int_deadlock_rollbacks - Internal Rollbacks Due To Deadlock monitor element
- int_rollbacks - Internal rollbacks monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- int_rows_updated - Internal Rows Updated monitor element
- lock_escalation - Lock escalation monitor element
- lock_escals - Number of lock escalations monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- partial_record - Partial Record monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- rej_curs_blk - Rejected Block Cursor Requests monitor element
- rollback_sql_stmts - Rollback Statements Attempted monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_read - Rows read monitor element
- rows_selected - Rows Selected monitor element
- rows_updated - Rows updated monitor element
- rows_written - Rows Written monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- sequence_no - Sequence number monitor element
- sort_overflows - Sort overflows monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- system_cpu_time - System CPU time monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_sec_cons - Secondary Connections monitor element
- total_sort_time - Total sort time monitor element
- total_sorts - Total sorts monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- unread_prefetch_pages - Unread prefetch pages monitor element
- user_cpu_time - User CPU time monitor element
- x_lock_escals - Exclusive lock escalations monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
event_connheader logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- auth_id - Authorization ID monitor element
- client_db_alias - Database Alias Used by Application monitor element
- client_nname - Client name monitor element
- client_pid - Client process ID monitor element
- client_platform - Client operating platform monitor element
- client_prdid - Client product and version ID monitor element
- client_protocol - Client communication protocol monitor element
- codepage_id - ID of Code Page Used by Application monitor element
- conn_time - Time of database connection monitor element
- corr_token - DRDA Correlation Token monitor element
- execution_id - User Login ID monitor element
- node_number - Node Number monitor element
- sequence_no - Sequence number monitor element
- territory_code - Database Territory Code monitor element
event_connmemuse logical data group
- appl_id - Application ID monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- node_number - Node Number monitor element
- pool_config_size - Configured Size of Memory Pool monitor element
- pool_cur_size - Current Size of Memory Pool monitor element
- pool_id - Memory Pool Identifier monitor element
- pool_secondary_id - Memory Pool Secondary Identifier monitor element
- pool_watermark - Memory Pool Watermark monitor element
event_data_value logical data group
- deadlock_id - Deadlock Event Identifier monitor element
- deadlock_node - Partition Number Where Deadlock Occurred monitor element
- evmon_activates - Number of event monitor activations monitor element
- participant_no - Participant within Deadlock monitor element
- stmt_history_id - Statement history identifier monitor element
- stmt_value_data - Value data monitor element
- stmt_value_index - Value index monitor element
- stmt_value_isnull - Value has null value monitor element
- stmt_value_isreopt - Variable used for statement reoptimization monitor element
- stmt_value_type - Value type monitor element
event_db logical data group
- active_hash_joins - Active hash joins monitor element
- appl_section_inserts - Section Inserts monitor element
- appl_section_lookups - Section Lookups monitor element
- async_runstats - Total number of asynchronous RUNSTATS requests monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- blocks_pending_cleanup - Pending cleanup rolled-out blocks monitor element
- cat_cache_heap_full - Catalog cache heap full monitor element monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- cat_cache_overflows - Catalog Cache Overflows monitor element
- cat_cache_size_top - Catalog cache high watermark monitor element
- catalog_node - Catalog Node Number monitor element
- catalog_node_name - Catalog Node Network Name monitor element
- commit_sql_stmts - Commit Statements Attempted monitor element
- connections_top - Maximum Number of Concurrent Connections monitor element
- db_heap_top - Maximum Database Heap Allocated monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- deadlocks - Deadlocks detected monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- disconn_time - Database Deactivation Timestamp monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- elapsed_exec_time - Statement Execution Elapsed Time monitor element
- evmon_activates - Number of event monitor activations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- files_closed - Database files closed monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- int_auto_rebinds - Internal Automatic Rebinds monitor element
- int_commits - Internal commits monitor element
- int_rollbacks - Internal rollbacks monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- lock_escals - Number of lock escalations monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- log_held_by_dirty_pages - Amount of Log Space Accounted for by Dirty Pages monitor element
- log_read_time - Log Read Time monitor element
- log_reads - Number of Log Pages Read monitor element
- log_to_redo_for_recovery - Amount of Log to be Redone for Recovery monitor element
- log_write_time - Log Write Time monitor element
- log_writes - Number of Log Pages Written monitor element
- num_log_part_page_io - Number of Partial Log Page Writes monitor element
- num_log_read_io - Number of Log Reads monitor element
- num_log_write_io - Number of Log Writes monitor element
- num_threshold_violations - Number of threshold violations monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- partial_record - Partial Record monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- pkg_cache_num_overflows - Package Cache Overflows monitor element
- pkg_cache_size_top - Package cache high watermark monitor element
- pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
- pool_async_data_reads - Buffer pool asynchronous data reads monitor element
- pool_async_data_writes - Buffer pool asynchronous data writes monitor element
- pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
- pool_async_index_reads - Buffer pool asynchronous index reads monitor element
- pool_async_index_writes - Buffer pool asynchronous index writes monitor element
- pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element
- pool_async_write_time - Buffer pool asynchronous write time monitor element
- pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
- pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
- pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_drty_pg_steal_clns - Buffer pool victim page cleaners triggered monitor element
- pool_drty_pg_thrsh_clns - Buffer pool threshold cleaners triggered monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_lsn_gap_clns - Buffer pool log space cleaners triggered monitor element
- pool_no_victim_buffer - Buffer pool no victim buffers monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- rollback_sql_stmts - Rollback Statements Attempted monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_read - Rows read monitor element
- rows_selected - Rows Selected monitor element
- rows_updated - Rows updated monitor element
- sec_log_used_top - Maximum Secondary Log Space Used monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- server_platform - Server Operating System monitor element
- sort_overflows - Sort overflows monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- stats_cache_size - Size of statistics cache monitor element
- stats_fabricate_time - Total time spent on statistics fabrication activities monitor element
- stats_fabrications - Total number of statistics fabrications monitor elements
- sync_runstats - Total number of synchronous RUNSTATS activities monitor element
- sync_runstats_time - Total time spent on synchronous RUNSTATS activities monitor element
- tot_log_used_top - Maximum Total Log Space Used monitor element
- total_cons - Connects Since Database Activation monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_sort_time - Total sort time monitor element
- total_sorts - Total sorts monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- unread_prefetch_pages - Unread prefetch pages monitor element
- x_lock_escals - Exclusive lock escalations monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
event_dbheader logical data group
event_dbmemuse logical data group
- evmon_activates - Number of event monitor activations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- node_number - Node Number monitor element
- node_number - Node Number monitor element
- num_log_data_found_in_buffer - Number of Log Data Found In Buffer monitor element
- pool_config_size - Configured Size of Memory Pool monitor element
- pool_config_size - Configured Size of Memory Pool monitor element
- pool_cur_size - Current Size of Memory Pool monitor element
- pool_id - Memory Pool Identifier monitor element
- pool_secondary_id - Memory Pool Secondary Identifier monitor element
- pool_watermark - Memory Pool Watermark monitor element
event_deadlock logical data group
- deadlock_id - Deadlock Event Identifier monitor element
- deadlock_node - Partition Number Where Deadlock Occurred monitor element
- dl_conns - Connections involved in deadlock monitor element
- evmon_activates - Number of event monitor activations monitor element
- rolled_back_agent_id - Rolled Back Agent monitor element
- rolled_back_appl_id - Rolled Back Application monitor element
- rolled_back_participant_no - Rolled back application participant monitor element
- rolled_back_sequence_no - Rolled Back Sequence Number monitor element
- start_time - Event start time monitor element
event_detailed_dlconn logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_id_holding_lk - Application ID Holding Lock monitor element
- blocking_cursor - Blocking Cursor monitor element
- consistency_token - Package consistency token monitor element
- creator - Application Creator monitor element
- cursor_name - Cursor Name monitor element
- data_partition_id - Data partition identifier monitor element
- deadlock_id - Deadlock Event Identifier monitor element
- deadlock_node - Partition Number Where Deadlock Occurred monitor element
- evmon_activates - Number of event monitor activations monitor element
- lock_attributes - Lock attributes monitor element
- lock_count - Lock count monitor element
- lock_current_mode - Original lock mode before conversion monitor element
- lock_escalation - Lock escalation monitor element
- lock_hold_count - Lock hold count monitor element
- lock_mode - Lock mode monitor element
- lock_mode_requested - Lock mode requested monitor element
- lock_name - Lock name monitor element
- lock_node - Lock Node monitor element
- lock_object_name - Lock Object Name monitor element
- lock_object_type - Lock object type waited on monitor element
- lock_release_flags - Lock release flags monitor element
- lock_wait_start_time - Lock wait start timestamp monitor element
- locks_held - Locks held monitor element
- locks_in_list - Number of Locks Reported monitor element
- package_name - Package name monitor element
- package_version_id - Package version monitor element
- participant_no - Participant within Deadlock monitor element
- participant_no_holding_lk - Participant Holding a Lock on the Object Required by Application monitor element
- section_number - Section number monitor element
- sequence_no - Sequence number monitor element
- sequence_no_holding_lk - Sequence Number Holding Lock monitor element
- start_time - Event start time monitor element
- stmt_operation/operation - Statement operation monitor element
- stmt_text - SQL statement text monitor element
- stmt_type - Statement type monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- tablespace_name - Table space name monitor element
- tenant_id - Tenant identifier monitor element
- tenant_name - Tenant name monitor element
- tpmon_acc_str - TP monitor client accounting string monitor element
- tpmon_client_app - TP monitor client application name monitor element
- tpmon_client_userid - TP monitor client user ID monitor element
- tpmon_client_wkstn - TP monitor client workstation name monitor element
event_dlconn logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_id_holding_lk - Application ID Holding Lock monitor element
- data_partition_id - Data partition identifier monitor element
- deadlock_id - Deadlock Event Identifier monitor element
- deadlock_node - Partition Number Where Deadlock Occurred monitor element
- evmon_activates - Number of event monitor activations monitor element
- lock_attributes - Lock attributes monitor element
- lock_count - Lock count monitor element
- lock_current_mode - Original lock mode before conversion monitor element
- lock_escalation - Lock escalation monitor element
- lock_hold_count - Lock hold count monitor element
- lock_mode - Lock mode monitor element
- lock_mode_requested - Lock mode requested monitor element
- lock_name - Lock name monitor element
- lock_node - Lock Node monitor element
- lock_object_name - Lock Object Name monitor element
- lock_object_type - Lock object type waited on monitor element
- lock_release_flags - Lock release flags monitor element
- lock_wait_start_time - Lock wait start timestamp monitor element
- participant_no - Participant within Deadlock monitor element
- participant_no_holding_lk - Participant Holding a Lock on the Object Required by Application monitor element
- sequence_no - Sequence number monitor element
- sequence_no_holding_lk - Sequence Number Holding Lock monitor element
- start_time - Event start time monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- tablespace_name - Table space name monitor element
- tpmon_acc_str - TP monitor client accounting string monitor element
- tpmon_client_app - TP monitor client application name monitor element
- tpmon_client_userid - TP monitor client user ID monitor element
- tpmon_client_wkstn - TP monitor client workstation name monitor element
event_histogrambin logical data group
- bin_id - Histogram bin identifier monitor element
- bottom - Histogram bin bottom monitor element
- histogram_type - Histogram type monitor element
- mon_interval_id - Monitor interval identifier monitor element
- number_in_bin - Number in bin monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- service_class_id - Service class ID monitor element
- statistics_timestamp - Statistics timestamp monitor element
- top - Histogram bin top monitor element
- work_action_set_id - Work action set ID monitor element
- work_class_id - Work class ID monitor element
- workload_id - Workload ID monitor element
event_log_header logical data group
- byte_order - Byte Order of Event Data monitor element
- codepage_id - ID of Code Page Used by Application monitor element
- event_monitor_name - Event Monitor Name monitor element
- num_nodes_in_db2_instance - Number of Nodes in Partition monitor element
- server_instance_name - Server Instance Name monitor element
- server_prdid - Server Product/Version ID monitor element
- territory_code - Database Territory Code monitor element
- version - Version of Monitor Data monitor element
event_overflow logical data group
event_qstats logical data group
- last_wlm_reset - Time of last reset monitor element
- mon_interval_id - Monitor interval identifier monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- queue_assignments_total - Queue assignments total monitor element
- queue_size_top - Queue size top monitor element
- queue_time_total - Queue time total monitor element
- service_subclass_name - Service subclass name monitor element
- service_superclass_name - Service superclass name monitor element
- statistics_timestamp - Statistics timestamp monitor element
- threshold_domain - Threshold domain monitor element
- threshold_name - Threshold name monitor element
- threshold_predicate - Threshold predicate monitor element
- thresholdid - Threshold ID monitor element
- work_action_set_name - Work action set name monitor element
- work_class_name - Work class name monitor element
event_osmetrics logical data group
- cpu_configured - Number of configured CPUs monitor element
- cpu_cores_per_socket - Number of CPU cores per socket monitor element
- cpu_hmt_degree - Number of logical CPUs monitor element
- cpu_idle - Processor idle time monitor element
- cpu_iowait - IO Wait time monitor element
- cpu_load_long - Processor load (long timeframe) monitor element
- cpu_load_medium - Processor load (medium timeframe) monitor element
- cpu_load_short - Processor load (short timeframe) monitor element
- cpu_online - Number of CPUs online monitor element
- cpu_speed - CPU clock speed monitor element
- cpu_system - Kernel time monitor element
- cpu_timebase - Frequency of timebase register increment monitor element
- cpu_total - Number of CPUs monitor element
- cpu_usage_total - Processor usage monitor element
- cpu_user - Non-kernel processing time monitor element
- last_wlm_reset - Time of last reset monitor element
- member - Database member monitor element
- memory_free - Amount of free physical memory monitor element
- memory_swap_free - Total free swap space monitor element
- memory_swap_total - Total swap space monitor element
- memory_total - Total physical memory monitor element
- mon_interval_id - Monitor interval identifier monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- statistics_timestamp - Statistics timestamp monitor element
- swap_page_size - Swap page size monitor element
- swap_pages_in - Pages swapped in from disk monitor element
- swap_pages_out - Pages swapped out to disk monitor element
- virtual_mem_free - Free virtual memory monitor element
- virtual_mem_reserved - Reserved virtual memory monitor element
- virtual_mem_total - Total virtual memory monitor element
event_scmetrics logical data group
- act_aborted_total - Total aborted activities monitor element
- act_completed_total - Total completed activities monitor element
- act_rejected_total - Total rejected activities monitor element
- act_rqsts_total - Total activity requests monitor elements
- agent_wait_time - Agent wait time monitor element
- agent_waits_total - Total agent waits monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- app_rqsts_completed_total - Total application requests completed monitor element
- appl_section_inserts - Section Inserts monitor element
- appl_section_lookups - Section Lookups monitor element
- audit_events_total - Total audit events monitor element
- audit_file_write_wait_time - Audit file write wait time monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- caching_tier_direct_reads - Direct reads from caching tier monitor element
- caching_tier_direct_read_reqs - Direct read requests from caching tier monitor element
- call_sql_stmts - CALL SQL statements executed monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- cf_wait_time - cluster caching facility wait time monitor element
- cf_waits - Number of cluster caching facility waits monitor element
- client_idle_wait_time - Client idle wait time monitor element
- col_vector_consumer_overflows - Columnar vector consumer overflows monitor element
- comm_exit_wait_time - Communication exit wait time monitor element
- comm_exit_waits - Communication exit number of waits monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- deadlocks - Deadlocks detected monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- disabled_peds - Disabled partial early distincts monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- evmon_wait_time - Event monitor wait time monitor element
- evmon_waits_total - Event monitor total waits monitor element
- ext_table_read_volume - Total data read by external table readers monitor element
- ext_table_recv_volume - Total data received from external table readers monitor element
- ext_table_recv_wait_time - Total agent wait time for external table readers monitor element
- ext_table_recvs_total - Total row batches received from external table readers monitor element
- ext_table_send_volume - Total data sent to external table writers monitor element
- ext_table_send_wait_time - Total agent wait time for external table writers monitor element
- ext_table_sends_total - Total row batches sent to external table writers monitor element
- ext_table_write_volume - Total data written by external table writers monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_message_recv_waits_total - Number of times spent waiting for FCM reply message monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- fcm_message_send_waits_total - Number of times spent blocking on an FCM message send monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- fcm_recv_waits_total - Number of times spent waiting to receive data through FCM monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_send_waits_total - Number of times spent blocking on an FCM send operation monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_tq_recv_waits_total - Number of times spent waiting to receive the next buffer monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_tq_send_waits_total - Number of times spent waiting to send the next buffer monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- fed_rows_deleted - Rows deleted by a federation system monitor element
- fed_rows_inserted - Rows inserted by a federation system monitor element
- fed_rows_read - Rows read by a federation system monitor element
- fed_rows_updated - Rows updated by a federation system monitor element
- fed_wait_time - Time spent by a federation server monitor element
- fed_waits_total - Total number of execution times for a federation server monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- ida_recv_volume - Total data volume received monitor element
- ida_recv_wait_time - Time spent waiting to receive data monitor element
- ida_recvs_total - Number of times data received monitor element
- ida_send_volume - Total data volume sent monitor element
- ida_send_wait_time - Time spent waiting to send data monitor element
- ida_sends_total - Number of times data sent monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- int_commits - Internal commits monitor element
- int_rollbacks - Internal rollbacks monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- ipc_recv_volume - Interprocess communication received volume monitor element
- ipc_recv_wait_time - Interprocess communication received wait time monitor element
- ipc_recvs_total - Interprocess communication receives total monitor element
- ipc_send_volume - Interprocess communication send volume monitor element
- ipc_send_wait_time - Interprocess communication send wait time monitor element
- ipc_sends_total - Interprocess communication send total monitor element
- last_wlm_reset - Time of last reset monitor element
- lob_prefetch_reqs - LOB prefetcher request count monitor element
- lob_prefetch_wait_time - Wait time for prefetcher for LOB read or write monitor element
- lock_escals - Number of lock escalations monitor element
- lock_escals_global - Number of global lock escalations monitor element
- lock_escals_locklist - Number of locklist lock escalations monitor element
- lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_timeouts_global - Lock timeouts global monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_wait_time_global - Lock wait time global monitor element
- lock_waits - Lock waits monitor element
- lock_waits_global - Lock waits global monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- merge_sql_stmts - Merge SQL statements executed monitor element
- mon_interval_id - Monitor interval identifier monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- pool_caching_tier_page_read_time - Buffer pool caching tier page read time monitor element
- pool_col_caching_tier_l_reads - Buffer pool column-organized caching tier logical reads monitor element
- pool_col_caching_tier_pages_found - Buffer pool column-organized pages found in caching tier monitor element
- pool_data_caching_tier_l_reads - Buffer pool data caching tier logical reads monitor element
- pool_data_caching_tier_pages_found - Buffer pool data pages found in caching tier monitor element
- pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_failed_async_data_reqs - Failed data prefetch requests monitor element
- pool_failed_async_index_reqs - Failed index prefetch requests monitor element
- pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
- pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
- pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
- pool_index_caching_tier_l_reads - Buffer pool index caching tier logical reads monitor element
- pool_index_caching_tier_pages_found - Buffer pool index pages found in caching tier monitor element
- pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_queued_async_data_pages - Data pages prefetch requests monitor element
- pool_queued_async_data_reqs - Data prefetch requests monitor element
- pool_queued_async_index_pages - Index pages prefetch requests monitor element
- pool_queued_async_index_reqs - Index prefetch requests monitor element
- pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
- pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
- pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
- pool_queued_async_xda_reqs - XDA prefetch requests monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_col_caching_tier_l_reads - Buffer pool temporary column-organized caching tier logical reads monitor element
- pool_temp_col_caching_tier_pages_found - Buffer pool temporary column-organized pages found in caching tier monitor element
- pool_temp_data_caching_tier_l_reads - Buffer pool temporary data caching tier logical reads monitor element
- pool_temp_data_caching_tier_pages_found - Buffer pool temporary data pages found in caching tier monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_caching_tier_l_reads - Buffer pool temporary index caching tier logical reads monitor element
- pool_temp_index_caching_tier_pages_found - Buffer pool temporary index pages found in caching tier monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_caching_tier_l_reads - Buffer pool temporary XML data caching tier logical reads monitor element
- pool_temp_xda_caching_tier_pages_found - Buffer pool temporary XDA data pages found in caching tier monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_caching_tier_l_reads - Buffer pool XML data caching tier logical reads monitor element
- pool_xda_caching_tier_pages_found - Buffer pool XDA data pages found in caching tier monitor element
- pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- post_threshold_peas - Partial early aggregation threshold monitor element
- post_threshold_peds - Partial early distincts threshold monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- prefetch_waits - Prefetcher wait count monitor element
- reclaim_wait_time - Reclaim wait time monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_modified - Rows modified monitor element
- rows_read - Rows read monitor element
- rows_returned - Rows returned monitor element
- rows_updated - Rows updated monitor element
- rqsts_completed_total - Total requests completed monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- service_class_id - Service class ID monitor element
- service_subclass_name - Service subclass name monitor element
- service_superclass_name - Service superclass name monitor element
- sort_overflows - Sort overflows monitor element
- spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- statistics_timestamp - Statistics timestamp monitor element
- tcpip_recv_volume - TCP/IP received volume monitor element
- tcpip_recv_wait_time - TCP/IP received wait time monitor element
- tcpip_recvs_total - TCP/IP receives total monitor element
- tcpip_send_volume - TCP/IP send volume monitor element
- tcpip_send_wait_time - TCP/IP send wait time monitor element
- tcpip_sends_total - TCP/IP sends total monitor element
- thresh_violations - Number of threshold violations monitor element
- total_act_time - Total activity time monitor element
- total_act_wait_time - Total activity wait time monitor element
- total_app_commits - Total application commits monitor elements
- total_app_rollbacks - Total application rollbacks monitor element
- total_app_rqst_time - Total application request time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_backup_proc_time - Total non-wait time for online backups monitor element
- total_backup_time - Total elapsed time for doing online backups monitor element
- total_backups - Total online backups monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
- total_commit_proc_time - Total commits processing time monitor element
- total_commit_time - Total commit time monitor element
- total_compilations - Total compilations monitor element
- total_compile_proc_time - Total compile processing time monitor element
- total_compile_time - Total compile time monitor element
- total_connect_authentication_proc_time - Total connection authentication processing time monitor element
- total_connect_authentication_time - Total connection or switch user authentication request time monitor element
- total_connect_authentications - Connections or switch user authentications performed monitor element
- total_connect_request_proc_time - Total connection or switch user request processing time monitor element
- total_connect_request_time - Total connection or switch user request time monitor element
- total_connect_requests - Connection or switch user requests monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- total_extended_latch_wait_time - Total extended latch wait time monitor element
- total_extended_latch_waits - Total extended latch waits monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- total_implicit_compilations - Total implicit compilations monitor element
- total_implicit_compile_proc_time - Total implicit compile processing time monitor element
- total_implicit_compile_time - Total implicit compile time monitor element
- 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 - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_load_proc_time - Total load processing time monitor element
- total_load_time - Total load time monitor element
- total_loads - Total loads monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_peas - Total partial early aggregations monitor element
- total_peds - Total partial early distincts monitor element
- total_reorg_proc_time - Total reorganization processing time monitor element
- total_reorg_time - Total reorganization time monitor element
- total_reorgs - Total reorganizations monitor element
- total_rollback_proc_time - Total rollback processing time monitor element
- total_rollback_time - Total rollback time monitor element
- total_routine_invocations - Total routine invocations monitor elements
- total_routine_time - Total routine time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- total_rqst_mapped_in - Total request mapped-in monitor element
- total_rqst_mapped_out - Total request mapped-out monitor element
- total_rqst_time - Total request time monitor element
- total_runstats - Total runtime statistics monitor element
- total_runstats_proc_time - Total runtime statistics processing time monitor element
- total_runstats_time - Total runtime statistics time monitor element
- total_section_proc_time - Total section processing time monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sort_time - Total section sort time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_time - Total section time monitor element
- total_sorts - Total sorts monitor element
- total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
- total_wait_time - Total wait time monitor element
- tq_sort_heap_rejections - Table queue sort heap rejections monitor element
- tq_sort_heap_requests - Table queue sort heap requests monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
event_scstats logical data group
- act_cpu_time_top - Activity CPU time top monitor element
- act_remapped_in - Activities remapped in monitor element
- act_remapped_out - Activities remapped out monitor element
- act_rows_read_top - Activity rows read top monitor element
- act_throughput - Activity throughput monitor element
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- act_sort_shrheap_top - Activity shared sort memory high watermark monitor element
- act_estimated_sort_shrheap_top - Activity estimated shared sort memory high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- adm_bypassed_act_load - Load of activities that bypass the adaptive workload manager monitor element
- adm_bypassed_act_time - Total time spent running activities that bypass adaptive workload manager monitor element
- adm_queued_act_load - Load of queued activities controlled by adaptive workload management monitor element
- adm_queued_act_time - Total time spent queued activities controlled by adaptive workload manager monitor element
- adm_running_act_load - Load of running activities controlled by adaptive workload management monitor element
- adm_running_act_time - Total time spent running activities controlled by the adaptive workload manager monitor element
- agent_load_trgt_demand - Estimated agent load target demand monitor element
- agent_load_trgt_demand_avg - Average estimated agent load target demand monitor element
- agent_load_trgt_demand_top - Peak estimated agent load target demand monitor element
- agg_temp_tablespace_top - Aggregate temporary table space top monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- concurrent_act_top - Concurrent activity top monitor element
- concurrent_connection_top - Concurrent connection top monitor element
- concurrent_wlo_top - Concurrent workload occurrences top monitor element
- coord_act_aborted_total - Coordinator activities aborted total monitor element
- coord_act_completed_total - Coordinator activities completed total monitor element
- coord_act_est_cost_avg - Coordinator activity estimated cost average monitor element
- coord_act_exec_time_avg - Coordinator activities execution time average monitor element
- coord_act_interarrival_time_avg - Coordinator activity arrival time average monitor element
- coord_act_lifetime_avg - Coordinator activity lifetime average monitor element
- coord_act_lifetime_top - Coordinator activity lifetime top monitor element
- coord_act_queue_time_avg - Coordinator activity queue time average monitor element
- coord_act_rejected_total - Coordinator activities rejected total monitor element
- cost_estimate_top - Cost estimate top monitor element
- cpu_utilization - CPU utilization monitor element
- details_xml - Details XML monitor element
- last_wlm_reset - Time of last reset monitor element
- metrics - Metrics monitor element
- mon_interval_id - Monitor interval identifier monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- request_exec_time_avg - Request execution time average monitor element
- rows_returned_top - Actual rows returned top monitor element
- service_class_id - Service class ID monitor element
- service_subclass_name - Service subclass name monitor element
- service_superclass_name - Service superclass name monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_shrheap_demand - Estimated sort memory resources demand monitor element
- sort_shrheap_demand_avg - Average estimated agent load target demand monitor element
- sort_shrheap_demand_top - Peak estimated sort memory demand monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- statistics_timestamp - Statistics timestamp monitor element
- temp_tablespace_top - Temporary table space top monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- uow_completed_total - Total completed units of work monitor element
- uow_lifetime_avg - Unit of work lifetime average monitor element
- uow_throughput - Unit of work throughput monitor element
- uow_total_time_top - UOW total time top monitor element
event_start logical data group
event_stmt logical data group
- agent_id - Application handle (agent ID) monitor element
- agents_top - Number of Agents Created monitor element
- appl_id - Application ID monitor element
- blocking_cursor - Blocking Cursor monitor element
- consistency_token - Package consistency token monitor element
- creator - Application Creator monitor element
- cursor_name - Cursor Name monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- fetch_count - Number of Successful Fetches monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- package_name - Package name monitor element
- package_version_id - Package version monitor element
- partial_record - Partial Record monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- rows_read - Rows read monitor element
- rows_written - Rows Written monitor element
- section_number - Section number monitor element
- sequence_no - Sequence number monitor element
- sort_overflows - Sort overflows monitor element
- sql_req_id - Request Identifier for SQL Statement monitor element
- sqlca - SQL Communications Area (SQLCA) monitor element
- start_time - Event start time monitor element
- stats_fabricate_time - Total time spent on statistics fabrication activities monitor element
- stmt_operation/operation - Statement operation monitor element
- stmt_text - SQL statement text monitor element
- stmt_type - Statement type monitor element
- stop_time - Event stop time monitor element
- sync_runstats_time - Total time spent on synchronous RUNSTATS activities monitor element
- system_cpu_time - System CPU time monitor element
- tenant_id - Tenant identifier monitor element
- tenant_name - Tenant name monitor element
- total_sort_time - Total sort time monitor element
- total_sorts - Total sorts monitor element
- user_cpu_time - User CPU time monitor element
event_stmt_history logical data group
- appl_id - Application ID monitor element
- comp_env_desc - Compilation environment monitor element
- creator - Application Creator monitor element
- deadlock_id - Deadlock Event Identifier monitor element
- deadlock_node - Partition Number Where Deadlock Occurred monitor element
- evmon_activates - Number of event monitor activations monitor element
- package_name - Package name monitor element
- package_version_id - Package version monitor element
- participant_no - Participant within Deadlock monitor element
- section_number - Section number monitor element
- sequence_no - Sequence number monitor element
- stmt_first_use_time - Statement first use timestamp monitor element
- stmt_history_id - Statement history identifier monitor element
- stmt_invocation_id - Statement invocation identifier monitor element
- stmt_isolation - Statement isolation monitor element
- stmt_last_use_time - Statement last use timestamp monitor element
- stmt_lock_timeout - Statement lock timeout monitor element
- stmt_nest_level - Statement nesting level monitor element
- stmt_pkg_cache_id - Statement package cache identifier monitor element
- stmt_query_id - Statement query identifier monitor element
- stmt_source_id - Statement source identifier monitor element
- stmt_text - SQL statement text monitor element
- stmt_type - Statement type monitor element
event_subsection logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- num_agents - Number of Agents Working on a Statement monitor element
- partial_record - Partial Record monitor element
- sql_req_id - Request Identifier for SQL Statement monitor element
- ss_exec_time - Subsection Execution Elapsed Time monitor element
- ss_node_number - Subsection Node Number monitor element
- ss_number - Subsection number monitor element
- ss_sys_cpu_time - System CPU Time used by Subsection monitor element
- ss_usr_cpu_time - User CPU Time used by Subsection monitor element
- tq_max_send_spills - Maximum number of table queue buffers overflows monitor element
- tq_rows_read - Number of Rows Read from table queues monitor element
- tq_rows_written - Number of rows written to table queues monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
Note: This logical data group is only generated in partitioned database
environments.
event_superclassmetrics logical data group
- act_aborted_total - Total aborted activities monitor element
- act_completed_total - Total completed activities monitor element
- act_rejected_total - Total rejected activities monitor element
- act_rqsts_total - Total activity requests monitor elements
- agent_wait_time - Agent wait time monitor element
- agent_waits_total - Total agent waits monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- app_rqsts_completed_total - Total application requests completed monitor element
- appl_section_inserts - Section Inserts monitor element
- appl_section_lookups - Section Lookups monitor element
- audit_events_total - Total audit events monitor element
- audit_file_write_wait_time - Audit file write wait time monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- caching_tier_direct_reads - Direct reads from caching tier monitor element
- caching_tier_direct_read_reqs - Direct read requests from caching tier monitor element
- caching_tier_page_read_time - Caching tier page read time monitor element
- call_sql_stmts - CALL SQL statements executed monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- cf_wait_time - cluster caching facility wait time monitor element
- cf_waits - Number of cluster caching facility waits monitor element
- client_idle_wait_time - Client idle wait time monitor element
- col_vector_consumer_overflows - Columnar vector consumer overflows monitor element
- comm_exit_wait_time - Communication exit wait time monitor element
- comm_exit_waits - Communication exit number of waits monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- deadlocks - Deadlocks detected monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- disabled_peds - Disabled partial early distincts monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- evmon_wait_time - Event monitor wait time monitor element
- evmon_waits_total - Event monitor total waits monitor element
- ext_table_read_volume - Total data read by external table readers monitor element
- ext_table_recv_volume - Total data received from external table readers monitor element
- ext_table_recv_wait_time - Total agent wait time for external table readers monitor element
- ext_table_recvs_total - Total row batches received from external table readers monitor element
- ext_table_send_volume - Total data sent to external table writers monitor element
- ext_table_send_wait_time - Total agent wait time for external table writers monitor element
- ext_table_sends_total - Total row batches sent to external table writers monitor element
- ext_table_write_volume - Total data written by external table writers monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_message_recv_waits_total - Number of times spent waiting for FCM reply message monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- fcm_message_send_waits_total - Number of times spent blocking on an FCM message send monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- fcm_recv_waits_total - Number of times spent waiting to receive data through FCM monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_send_waits_total - Number of times spent blocking on an FCM send operation monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_tq_recv_waits_total - Number of times spent waiting to receive the next buffer monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_tq_send_waits_total - Number of times spent waiting to send the next buffer monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- fed_rows_deleted - Rows deleted by a federation system monitor element
- fed_rows_inserted - Rows inserted by a federation system monitor element
- fed_rows_read - Rows read by a federation system monitor element
- fed_rows_updated - Rows updated by a federation system monitor element
- fed_wait_time - Time spent by a federation server monitor element
- fed_waits_total - Total number of execution times for a federation server monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- ida_recv_volume - Total data volume received monitor element
- ida_recv_wait_time - Time spent waiting to receive data monitor element
- ida_recvs_total - Number of times data received monitor element
- ida_send_volume - Total data volume sent monitor element
- ida_send_wait_time - Time spent waiting to send data monitor element
- ida_sends_total - Number of times data sent monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- int_commits - Internal commits monitor element
- int_rollbacks - Internal rollbacks monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- ipc_recv_volume - Interprocess communication received volume monitor element
- ipc_recv_wait_time - Interprocess communication received wait time monitor element
- ipc_recvs_total - Interprocess communication receives total monitor element
- ipc_send_volume - Interprocess communication send volume monitor element
- ipc_send_wait_time - Interprocess communication send wait time monitor element
- ipc_sends_total - Interprocess communication send total monitor element
- last_wlm_reset - Time of last reset monitor element
- lob_prefetch_reqs - LOB prefetcher request count monitor element
- lob_prefetch_wait_time - Wait time for prefetcher for LOB read or write monitor element
- lock_escals - Number of lock escalations monitor element
- lock_escals_global - Number of global lock escalations monitor element
- lock_escals_locklist - Number of locklist lock escalations monitor element
- lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_timeouts_global - Lock timeouts global monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_wait_time_global - Lock wait time global monitor element
- lock_waits - Lock waits monitor element
- lock_waits_global - Lock waits global monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- merge_sql_stmts - Merge SQL statements executed monitor element
- mon_interval_id - Monitor interval identifier monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- pool_caching_tier_page_read_time - Buffer pool caching tier page read time monitor element
- pool_col_caching_tier_l_reads - Buffer pool column-organized caching tier logical reads monitor element
- pool_data_caching_tier_l_reads - Buffer pool data caching tier logical reads monitor element
- pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_failed_async_data_reqs - Failed data prefetch requests monitor element
- pool_failed_async_index_reqs - Failed index prefetch requests monitor element
- pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
- pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
- pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
- pool_index_caching_tier_l_reads - Buffer pool index caching tier logical reads monitor element
- pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_queued_async_data_pages - Data pages prefetch requests monitor element
- pool_queued_async_data_reqs - Data prefetch requests monitor element
- pool_queued_async_index_pages - Index pages prefetch requests monitor element
- pool_queued_async_index_reqs - Index prefetch requests monitor element
- pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
- pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
- pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
- pool_queued_async_xda_reqs - XDA prefetch requests monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_col_caching_tier_l_reads - Buffer pool temporary column-organized caching tier logical reads monitor element
- pool_temp_col_caching_tier_pages_found - Buffer pool temporary column-organized pages found in caching tier monitor element
- pool_temp_data_caching_tier_l_reads - Buffer pool temporary data caching tier logical reads monitor element
- pool_temp_data_caching_tier_pages_found - Buffer pool temporary data pages found in caching tier monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_caching_tier_l_reads - Buffer pool temporary index caching tier logical reads monitor element
- pool_temp_index_caching_tier_pages_found - Buffer pool temporary index pages found in caching tier monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_caching_tier_l_reads - Buffer pool temporary XML data caching tier logical reads monitor element
- pool_temp_xda_caching_tier_pages_found - Buffer pool temporary XDA data pages found in caching tier monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_caching_tier_l_reads - Buffer pool XML data caching tier logical reads monitor element
- pool_xda_caching_tier_pages_found - Buffer pool XDA data pages found in caching tier monitor element
- pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- post_threshold_peas - Partial early aggregation threshold monitor element
- post_threshold_peds - Partial early distincts threshold monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- prefetch_waits - Prefetcher wait count monitor element
- reclaim_wait_time - Reclaim wait time monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_modified - Rows modified monitor element
- rows_read - Rows read monitor element
- rows_returned - Rows returned monitor element
- rows_updated - Rows updated monitor element
- rqsts_completed_total - Total requests completed monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- service_class_id - Service class ID monitor element
- service_superclass_name - Service superclass name monitor element
- sort_overflows - Sort overflows monitor element
- spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- statistics_timestamp - Statistics timestamp monitor element
- tcpip_recv_volume - TCP/IP received volume monitor element
- tcpip_recv_wait_time - TCP/IP received wait time monitor element
- tcpip_recvs_total - TCP/IP receives total monitor element
- tcpip_send_volume - TCP/IP send volume monitor element
- tcpip_send_wait_time - TCP/IP send wait time monitor element
- tcpip_sends_total - TCP/IP sends total monitor element
- thresh_violations - Number of threshold violations monitor element
- total_act_time - Total activity time monitor element
- total_act_wait_time - Total activity wait time monitor element
- total_app_commits - Total application commits monitor elements
- total_app_rollbacks - Total application rollbacks monitor element
- total_app_rqst_time - Total application request time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_backup_proc_time - Total non-wait time for online backups monitor element
- total_backup_time - Total elapsed time for doing online backups monitor element
- total_backups - Total online backups monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
- total_commit_proc_time - Total commits processing time monitor element
- total_commit_time - Total commit time monitor element
- total_compilations - Total compilations monitor element
- total_compile_proc_time - Total compile processing time monitor element
- total_compile_time - Total compile time monitor element
- total_connect_authentication_proc_time - Total connection authentication processing time monitor element
- total_connect_authentication_time - Total connection or switch user authentication request time monitor element
- total_connect_authentications - Connections or switch user authentications performed monitor element
- total_connect_request_proc_time - Total connection or switch user request processing time monitor element
- total_connect_request_time - Total connection or switch user request time monitor element
- total_connect_requests - Connection or switch user requests monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- total_extended_latch_wait_time - Total extended latch wait time monitor element
- total_extended_latch_waits - Total extended latch waits monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- total_implicit_compilations - Total implicit compilations monitor element
- total_implicit_compile_proc_time - Total implicit compile processing time monitor element
- total_implicit_compile_time - Total implicit compile time monitor element
- 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 - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_load_proc_time - Total load processing time monitor element
- total_load_time - Total load time monitor element
- total_loads - Total loads monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_peas - Total partial early aggregations monitor element
- total_peds - Total partial early distincts monitor element
- total_reorg_proc_time - Total reorganization processing time monitor element
- total_reorg_time - Total reorganization time monitor element
- total_reorgs - Total reorganizations monitor element
- total_rollback_proc_time - Total rollback processing time monitor element
- total_rollback_time - Total rollback time monitor element
- total_routine_invocations - Total routine invocations monitor elements
- total_routine_time - Total routine time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- total_rqst_mapped_in - Total request mapped-in monitor element
- total_rqst_mapped_out - Total request mapped-out monitor element
- total_rqst_time - Total request time monitor element
- total_runstats - Total runtime statistics monitor element
- total_runstats_proc_time - Total runtime statistics processing time monitor element
- total_runstats_time - Total runtime statistics time monitor element
- total_section_proc_time - Total section processing time monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sort_time - Total section sort time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_time - Total section time monitor element
- total_sorts - Total sorts monitor element
- total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
- total_wait_time - Total wait time monitor element
- tq_sort_heap_rejections - Table queue sort heap rejections monitor element
- tq_sort_heap_requests - Table queue sort heap requests monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
event_superclassstats logical data group
- act_cpu_time_top - Activity CPU time top monitor element
- act_rows_read_top - Activity rows read top monitor element
- act_estimated_sort_shrheap_top - Activity estimated shared sort memory high watermark monitor element
- act_sort_shrheap_top - Activity shared sort memory high watermark monitor element
- act_throughput - Activity throughput monitor element
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- adm_bypassed_act_load - Load of activities that bypass the adaptive workload manager monitor element
- adm_bypassed_act_time - Total time spent running activities that bypass adaptive workload manager monitor element
- adm_queued_act_load - Load of queued activities controlled by adaptive workload management monitor element
- adm_queued_act_time - Total time spent queued activities controlled by adaptive workload manager monitor element
- adm_running_act_load - Load of running activities controlled by adaptive workload management monitor element
- adm_running_act_time - Total time spent running activities controlled by the adaptive workload manager monitor element
- agent_load_trgt_demand - Estimated agent load target demand monitor element
- agent_load_trgt_demand_avg - Average estimated agent load target demand monitor element
- agent_load_trgt_demand_top - Peak estimated agent load target demand monitor element
- agg_temp_tablespace_top - Aggregate temporary table space top monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- concurrent_act_top - Concurrent activity top monitor element
- concurrent_connection_top - Concurrent connection top monitor element
- concurrent_wlo_top - Concurrent workload occurrences top monitor element
- coord_act_aborted_total - Coordinator activities aborted total monitor element
- coord_act_completed_total - Coordinator activities completed total monitor element
- coord_act_est_cost_avg - Coordinator activity estimated cost average monitor element
- coord_act_exec_time_avg - Coordinator activities execution time average monitor element
- coord_act_interarrival_time_avg - Coordinator activity arrival time average monitor element
- coord_act_lifetime_avg - Coordinator activity lifetime average monitor element
- coord_act_lifetime_top - Coordinator activity lifetime top monitor element
- coord_act_queue_time_avg - Coordinator activity queue time average monitor element
- coord_act_rejected_total - Coordinator activities rejected total monitor element
- cost_estimate_top - Cost estimate top monitor element
- cpu_utilization - CPU utilization monitor element
- details_xml - Details XML monitor element
- last_wlm_reset - Time of last reset monitor element
- metrics - Metrics monitor element
- mon_interval_id - Monitor interval identifier monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- rows_returned_top - Actual rows returned top monitor element
- service_class_id - Service class ID monitor element
- service_superclass_name - Service superclass name monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_shrheap_demand - Estimated sort memory resources demand monitor element
- sort_shrheap_demand_avg - Average estimated agent load target demand monitor element
- sort_shrheap_demand_top - Peak estimated sort memory demand monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- statistics_timestamp - Statistics timestamp monitor element
- temp_tablespace_top - Temporary table space top monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- uow_completed_total - Total completed units of work monitor element
- uow_lifetime_avg - Unit of work lifetime average monitor element
- uow_throughput - Unit of work throughput monitor element
- uow_total_time_top - UOW total time top monitor element
event_table logical data group
- data_object_pages - Data Object Pages monitor element
- data_partition_id - Data partition identifier monitor element
- event_time - Event Time monitor element
- evmon_activates - Number of event monitor activations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- index_object_pages - Index Object Pages monitor element
- lob_object_pages - LOB Object Pages monitor element
- long_object_pages - Long Object Pages monitor element
- overflow_accesses - Accesses to overflowed records monitor element
- page_reorgs - Page reorganizations monitor element
- partial_record - Partial Record monitor element
- rows_read - Rows read monitor element
- rows_written - Rows Written monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- table_type - Table type monitor element
- tablespace_id - Table space identification monitor element
- xda_object_pages - XDA Object Pages monitor element
event_tablespace logical data group
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- event_time - Event Time monitor element
- evmon_activates - Number of event monitor activations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- files_closed - Database files closed monitor element
- partial_record - Partial Record monitor element
- pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
- pool_async_data_reads - Buffer pool asynchronous data reads monitor element
- pool_async_data_writes - Buffer pool asynchronous data writes monitor element
- pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
- pool_async_index_reads - Buffer pool asynchronous index reads monitor element
- pool_async_index_writes - Buffer pool asynchronous index writes monitor element
- pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element
- pool_async_write_time - Buffer pool asynchronous write time monitor element
- pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
- pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
- pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_no_victim_buffer - Buffer pool no victim buffers monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- tablespace_name - Table space name monitor element
- unread_prefetch_pages - Unread prefetch pages monitor element
event_thresholdviolations logical data group
- activate_timestamp - Activate timestamp monitor element
- activity_collected - Activity collected monitor element
- activity_id - Activity ID monitor element
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- appl_name - Application name monitor element
- client_acctng - Client accounting string monitor element
- client_applname - Client application name monitor element
- client_hostname - Client hostname monitor element
- client_pid - Client process ID monitor element
- client_platform - Client operating platform monitor element
- client_port_number - Client port number monitor element
- client_prdid - Client product and version ID monitor element
- client_protocol - Client communication protocol monitor element
- client_userid - Client user ID monitor element
- client_wrkstnname - Client workstation name monitor element
- connection_start_time - Connection start time monitor element
- coord_partition_num - Coordinator partition number monitor element
- destination_service_class_id - Destination service class ID monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- session_auth_id - Session authorization ID monitor element
- source_service_class_id - Source service class ID monitor element
- system_auth_id - System authorization identifier monitor element
- tenant_id - Tenant identifier monitor element
- tenant_name - Tenant name monitor element
- threshold_action - Threshold action monitor element
- threshold_maxvalue - Threshold maximum value monitor element
- threshold_predicate - Threshold predicate monitor element
- threshold_queuesize - Threshold queue size monitor element
- thresholdid - Threshold ID monitor element
- time_of_violation - Time of violation monitor element
- uow_id - Unit of work ID monitor element
- workload_id - Workload ID monitor element
event_wcstats logical data group
- act_cpu_time_top - Activity CPU time top monitor element
- act_rows_read_top - Activity rows read top monitor element
- act_total - Activities total monitor element
- coord_act_est_cost_avg - Coordinator activity estimated cost average monitor element
- coord_act_exec_time_avg - Coordinator activities execution time average monitor element
- coord_act_interarrival_time_avg - Coordinator activity arrival time average monitor element
- coord_act_lifetime_avg - Coordinator activity lifetime average monitor element
- coord_act_lifetime_top - Coordinator activity lifetime top monitor element
- coord_act_queue_time_avg - Coordinator activity queue time average monitor element
- cost_estimate_top - Cost estimate top monitor element
- last_wlm_reset - Time of last reset monitor element
- mon_interval_id - Monitor interval identifier monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- rows_returned_top - Actual rows returned top monitor element
- statistics_timestamp - Statistics timestamp monitor element
- temp_tablespace_top - Temporary table space top monitor element
- work_action_set_id - Work action set ID monitor element
- work_action_set_name - Work action set name monitor element
- work_class_id - Work class ID monitor element
- work_class_name - Work class name monitor element
event_wlmetrics logical data group
- act_aborted_total - Total aborted activities monitor element
- act_completed_total - Total completed activities monitor element
- act_rejected_total - Total rejected activities monitor element
- act_rqsts_total - Total activity requests monitor elements
- adm_bypass_act_total - Number of times admission control was bypassed monitor element
- adm_overflows - Number of times an activity fit as an overflow monitor element
- agent_wait_time - Agent wait time monitor element
- agent_waits_total - Total agent waits monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- app_rqsts_completed_total - Total application requests completed monitor element
- appl_section_inserts - Section Inserts monitor element
- appl_section_lookups - Section Lookups monitor element
- audit_events_total - Total audit events monitor element
- audit_file_write_wait_time - Audit file write wait time monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- caching_tier_direct_reads - Direct reads from caching tier monitor element
- caching_tier_direct_read_reqs - Direct read requests from caching tier monitor element
- caching_tier_page_read_time - Caching tier page read time monitor element
- call_sql_stmts - CALL SQL statements executed monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- cf_wait_time - cluster caching facility wait time monitor element
- cf_waits - Number of cluster caching facility waits monitor element
- client_idle_wait_time - Client idle wait time monitor element
- col_vector_consumer_overflows - Columnar vector consumer overflows monitor element
- comm_exit_wait_time - Communication exit wait time monitor element
- comm_exit_waits - Communication exit number of waits monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- deadlocks - Deadlocks detected monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- disabled_peds - Disabled partial early distincts monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- evmon_wait_time - Event monitor wait time monitor element
- evmon_waits_total - Event monitor total waits monitor element
- ext_table_read_volume - Total data read by external table readers monitor element
- ext_table_recv_volume - Total data received from external table readers monitor element
- ext_table_recv_wait_time - Total agent wait time for external table readers monitor element
- ext_table_recvs_total - Total row batches received from external table readers monitor element
- ext_table_send_volume - Total data sent to external table writers monitor element
- ext_table_send_wait_time - Total agent wait time for external table writers monitor element
- ext_table_sends_total - Total row batches sent to external table writers monitor element
- ext_table_write_volume - Total data written by external table writers monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_message_recv_waits_total - Number of times spent waiting for FCM reply message monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- fcm_message_send_waits_total - Number of times spent blocking on an FCM message send monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- fcm_recv_waits_total - Number of times spent waiting to receive data through FCM monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_send_waits_total - Number of times spent blocking on an FCM send operation monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_tq_recv_waits_total - Number of times spent waiting to receive the next buffer monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_tq_send_waits_total - Number of times spent waiting to send the next buffer monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- fed_rows_deleted - Rows deleted by a federation system monitor element
- fed_rows_inserted - Rows inserted by a federation system monitor element
- fed_rows_read - Rows read by a federation system monitor element
- fed_rows_updated - Rows updated by a federation system monitor element
- fed_wait_time - Time spent by a federation server monitor element
- fed_waits_total - Total number of execution times for a federation server monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- ida_recv_volume - Total data volume received monitor element
- ida_recv_wait_time - Time spent waiting to receive data monitor element
- ida_recvs_total - Number of times data received monitor element
- ida_send_volume - Total data volume sent monitor element
- ida_send_wait_time - Time spent waiting to send data monitor element
- ida_sends_total - Number of times data sent monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- int_commits - Internal commits monitor element
- int_rollbacks - Internal rollbacks monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- ipc_recv_volume - Interprocess communication received volume monitor element
- ipc_recv_wait_time - Interprocess communication received wait time monitor element
- ipc_recvs_total - Interprocess communication receives total monitor element
- ipc_send_volume - Interprocess communication send volume monitor element
- ipc_send_wait_time - Interprocess communication send wait time monitor element
- ipc_sends_total - Interprocess communication send total monitor element
- last_wlm_reset - Time of last reset monitor element
- lob_prefetch_reqs - LOB prefetcher request count monitor element
- lob_prefetch_wait_time - Wait time for prefetcher for LOB read or write monitor element
- lock_escals - Number of lock escalations monitor element
- lock_escals_global - Number of global lock escalations monitor element
- lock_escals_locklist - Number of locklist lock escalations monitor element
- lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_timeouts_global - Lock timeouts global monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_wait_time_global - Lock wait time global monitor element
- lock_waits - Lock waits monitor element
- lock_waits_global - Lock waits global monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- merge_sql_stmts - Merge SQL statements executed monitor element
- mon_interval_id - Monitor interval identifier monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- pool_caching_tier_page_read_time - Buffer pool caching tier page read time monitor element
- pool_col_caching_tier_l_reads - Buffer pool column-organized caching tier logical reads monitor element
- pool_col_caching_tier_pages_found - Buffer pool column-organized pages found in caching tier monitor element
- pool_data_caching_tier_l_reads - Buffer pool data caching tier logical reads monitor element
- pool_data_caching_tier_pages_found - Buffer pool data pages found in caching tier monitor element
- pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_failed_async_data_reqs - Failed data prefetch requests monitor element
- pool_failed_async_index_reqs - Failed index prefetch requests monitor element
- pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
- pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
- pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
- pool_index_caching_tier_l_reads - Buffer pool index caching tier logical reads monitor element
- pool_index_caching_tier_pages_found - Buffer pool index pages found in caching tier monitor element
- pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_queued_async_data_pages - Data pages prefetch requests monitor element
- pool_queued_async_data_reqs - Data prefetch requests monitor element
- pool_queued_async_index_pages - Index pages prefetch requests monitor element
- pool_queued_async_index_reqs - Index prefetch requests monitor element
- pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
- pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
- pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
- pool_queued_async_xda_reqs - XDA prefetch requests monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_col_caching_tier_l_reads - Buffer pool temporary column-organized caching tier logical reads monitor element
- pool_temp_col_caching_tier_pages_found - Buffer pool temporary column-organized pages found in caching tier monitor element
- pool_temp_data_caching_tier_l_reads - Buffer pool temporary data caching tier logical reads monitor element
- pool_temp_data_caching_tier_pages_found - Buffer pool temporary data pages found in caching tier monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_caching_tier_l_reads - Buffer pool temporary index caching tier logical reads monitor element
- pool_temp_index_caching_tier_pages_found - Buffer pool temporary index pages found in caching tier monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_caching_tier_l_reads - Buffer pool temporary XML data caching tier logical reads monitor element
- pool_temp_xda_caching_tier_pages_found - Buffer pool temporary XDA data pages found in caching tier monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_caching_tier_l_reads - Buffer pool XML data caching tier logical reads monitor element
- pool_xda_caching_tier_pages_found - Buffer pool XDA data pages found in caching tier monitor element
- pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- post_threshold_peas - Partial early aggregation threshold monitor element
- post_threshold_peds - Partial early distincts threshold monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- prefetch_waits - Prefetcher wait count monitor element
- reclaim_wait_time - Reclaim wait time monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_modified - Rows modified monitor element
- rows_read - Rows read monitor element
- rows_returned - Rows returned monitor element
- rows_updated - Rows updated monitor element
- rqsts_completed_total - Total requests completed monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- sort_overflows - Sort overflows monitor element
- spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- statistics_timestamp - Statistics timestamp monitor element
- tcpip_recv_volume - TCP/IP received volume monitor element
- tcpip_recv_wait_time - TCP/IP received wait time monitor element
- tcpip_recvs_total - TCP/IP receives total monitor element
- tcpip_send_volume - TCP/IP send volume monitor element
- tcpip_send_wait_time - TCP/IP send wait time monitor element
- tcpip_sends_total - TCP/IP sends total monitor element
- thresh_violations - Number of threshold violations monitor element
- total_act_time - Total activity time monitor element
- total_act_wait_time - Total activity wait time monitor element
- total_app_commits - Total application commits monitor elements
- total_app_rollbacks - Total application rollbacks monitor element
- total_app_rqst_time - Total application request time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_backup_proc_time - Total non-wait time for online backups monitor element
- total_backup_time - Total elapsed time for doing online backups monitor element
- total_backups - Total online backups monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
- total_commit_proc_time - Total commits processing time monitor element
- total_commit_time - Total commit time monitor element
- total_compilations - Total compilations monitor element
- total_compile_proc_time - Total compile processing time monitor element
- total_compile_time - Total compile time monitor element
- total_connect_authentication_proc_time - Total connection authentication processing time monitor element
- total_connect_authentication_time - Total connection or switch user authentication request time monitor element
- total_connect_authentications - Connections or switch user authentications performed monitor element
- total_connect_request_proc_time - Total connection or switch user request processing time monitor element
- total_connect_request_time - Total connection or switch user request time monitor element
- total_connect_requests - Connection or switch user requests monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- total_extended_latch_wait_time - Total extended latch wait time monitor element
- total_extended_latch_waits - Total extended latch waits monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- total_implicit_compilations - Total implicit compilations monitor element
- total_implicit_compile_proc_time - Total implicit compile processing time monitor element
- total_implicit_compile_time - Total implicit compile time monitor element
- 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 - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_load_proc_time - Total load processing time monitor element
- total_load_time - Total load time monitor element
- total_loads - Total loads monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_peas - Total partial early aggregations monitor element
- total_peds - Total partial early distincts monitor element
- total_reorg_proc_time - Total reorganization processing time monitor element
- total_reorg_time - Total reorganization time monitor element
- total_reorgs - Total reorganizations monitor element
- total_rollback_proc_time - Total rollback processing time monitor element
- total_rollback_time - Total rollback time monitor element
- total_routine_invocations - Total routine invocations monitor elements
- total_routine_time - Total routine time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- total_rqst_mapped_in - Total request mapped-in monitor element
- total_rqst_mapped_out - Total request mapped-out monitor element
- total_rqst_time - Total request time monitor element
- total_runstats - Total runtime statistics monitor element
- total_runstats_proc_time - Total runtime statistics processing time monitor element
- total_runstats_time - Total runtime statistics time monitor element
- total_section_proc_time - Total section processing time monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sort_time - Total section sort time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_time - Total section time monitor element
- total_sorts - Total sorts monitor element
- total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
- total_wait_time - Total wait time monitor element
- tq_sort_heap_rejections - Table queue sort heap rejections monitor element
- tq_sort_heap_requests - Table queue sort heap requests monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
- workload_id - Workload ID monitor element
- workload_name - Workload name monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
event_wlstats logical data group
- act_cpu_time_top - Activity CPU time top monitor element
- act_estimated_sort_shrheap_top - Activity estimated shared sort memory high watermark monitor element
- act_sort_shrheap_top - Activity shared sort memory high watermark monitor element
- act_rows_read_top - Activity rows read top monitor element
- act_throughput - Activity throughput monitor element
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- concurrent_wlo_act_top - Concurrent WLO activity top monitor element
- concurrent_wlo_top - Concurrent workload occurrences top monitor element
- coord_act_aborted_total - Coordinator activities aborted total monitor element
- coord_act_completed_total - Coordinator activities completed total monitor element
- coord_act_est_cost_avg - Coordinator activity estimated cost average monitor element
- coord_act_exec_time_avg - Coordinator activities execution time average monitor element
- coord_act_interarrival_time_avg - Coordinator activity arrival time average monitor element
- coord_act_lifetime_avg - Coordinator activity lifetime average monitor element
- coord_act_lifetime_top - Coordinator activity lifetime top monitor element
- coord_act_queue_time_avg - Coordinator activity queue time average monitor element
- coord_act_rejected_total - Coordinator activities rejected total monitor element
- cost_estimate_top - Cost estimate top monitor element
- cpu_utilization - CPU utilization monitor element
- details_xml - Details XML monitor element
- last_wlm_reset - Time of last reset monitor element
- lock_wait_time_global_top - Top global lock wait time monitor element
- lock_wait_time_top - Lock wait time top monitor element
- metrics - Metrics monitor element
- mon_interval_id - Monitor interval identifier monitor element
- partition_key - Partitioning key monitor element
- partition_number - Partition Number monitor element
- rows_returned_top - Actual rows returned top monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- statistics_timestamp - Statistics timestamp monitor element
- temp_tablespace_top - Temporary table space top monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- uow_completed_total - Total completed units of work monitor element
- uow_lifetime_avg - Unit of work lifetime average monitor element
- uow_throughput - Unit of work throughput monitor element
- uow_total_time_top - UOW total time top monitor element
- wlo_completed_total - Workload occurrences completed total monitor element
- workload_id - Workload ID monitor element
- workload_name - Workload name monitor element
event_xact logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- lock_escals - Number of lock escalations monitor element
- lock_wait_time - Time waited on locks monitor element
- locks_held_top - Maximum number of locks held monitor element
- partial_record - Partial Record monitor element
- prev_uow_stop_time - Previous Unit of Work Completion Timestamp monitor element
- rows_read - Rows read monitor element
- rows_written - Rows Written monitor element
- sequence_no - Sequence number monitor element
- stop_time - Event stop time monitor element
- system_cpu_time - System CPU time monitor element
- tenant_id - Tenant identifier monitor element
- tenant_name - Tenant name monitor element
- tpmon_acc_str - TP monitor client accounting string monitor element
- tpmon_client_app - TP monitor client application name monitor element
- tpmon_client_userid - TP monitor client user ID monitor element
- tpmon_client_wkstn - TP monitor client workstation name monitor element
- uow_log_space_used - Unit of work log space used monitor element
- uow_start_time - Unit of work start timestamp monitor element
- uow_status - Unit of Work Status monitor element
- user_cpu_time - User CPU time monitor element
- x_lock_escals - Exclusive lock escalations monitor element
evmonstart logical data group
- db2start_time - Start Database Manager Timestamp monitor element
- db_conn_time - Database activation timestamp monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
lock logical data group
- deadlock_type - Deadlock type monitor element
- dl_conns - Connections involved in deadlock monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
- rolled_back_participant_no - Rolled back application participant monitor element
lock_activity_values logical data group
- activity_id - Activity ID monitor element
- event_id - Event ID monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- member - Database member monitor element
- participant_no - Participant within Deadlock monitor element
- partition_key - Partitioning key monitor element
- stmt_value_data - Value data monitor element
- stmt_value_index - Value index monitor element
- stmt_value_isnull - Value has null value monitor element
- stmt_value_isreopt - Variable used for statement reoptimization monitor element
- stmt_value_type - Value type monitor element
- uow_id - Unit of work ID monitor element
lock_participant_activities logical data group
- activity_id - Activity ID monitor element
- activity_type - Activity type monitor element
- consistency_token - Package consistency token monitor element
- effective_isolation - Effective isolation monitor element
- effective_query_degree - Effective query degree monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- incremental_bind - Incremental bind monitor element
- member - Database member monitor element
- package_name - Package name monitor element
- package_schema - Package schema monitor element
- package_version_id - Package version monitor element
- participant_no - Participant within Deadlock monitor element
- partition_key - Partitioning key monitor element
- query_actual_degree - Actual runtime degree of intrapartition parallelism monitor element
- reopt - Reopt bind option monitor element
- section_number - Section number monitor element
- stmt_first_use_time - Statement first use timestamp monitor element
- stmt_invocation_id - Statement invocation identifier monitor element
- stmt_last_use_time - Statement last use timestamp monitor element
- stmt_lock_timeout - Statement lock timeout monitor element
- stmt_nest_level - Statement nesting level monitor element
- stmt_operation/operation - Statement operation monitor element
- stmt_pkg_cache_id - Statement package cache identifier monitor element
- stmt_query_id - Statement query identifier monitor element
- stmt_source_id - Statement source identifier monitor element
- stmt_text - SQL statement text monitor element
- stmt_type - Statement type monitor element
- stmt_unicode - Statement unicode flag monitor element
- uow_id - Unit of work ID monitor element
lock_participants logical data group
- agent_id - Application handle (agent ID) monitor element
- agent_status - DCS Application Agents monitor element
- agent_tid - Agent thread ID monitor element
- appl_action - Application action monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- application_handle - Application handle monitor element
- auth_id - Authorization ID monitor element
- client_acctng - Client accounting string monitor element
- client_applname - Client application name monitor element
- client_userid - Client user ID monitor element
- client_wrkstnname - Client workstation name monitor element
- coord_agent_tid - Coordinator agent engine dispatchable unit ID monitor element
- current_request - Current operation request monitor element
- deadlock_member - Deadlock member monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- lock_attributes - Lock attributes monitor element
- lock_count - Lock count monitor element
- lock_current_mode - Original lock mode before conversion monitor element
- lock_escalation - Lock escalation monitor element
- lock_hold_count - Lock hold count monitor element
- lock_mode - Lock mode monitor element
- lock_mode_requested - Lock mode requested monitor element
- lock_name - Lock name monitor element
- lock_object_type - Lock object type waited on monitor element
- lock_object_type_id - Internal lock object type waited on monitor element
- lock_release_flags - Lock release flags monitor element
- lock_status - Lock status monitor element
- lock_timeout_val - Lock timeout value monitor element
- lock_wait_end_time - Lock wait end timestamp monitor element
- lock_wait_start_time - Lock wait start timestamp monitor element
- lock_wait_val - Lock wait value monitor element
- member - Database member monitor element
- object_requested - Requested object monitor element
- participant_no - Participant within Deadlock monitor element
- participant_no_holding_lk - Participant Holding a Lock on the Object Required by Application monitor element
- participant_type - Participant type monitor element
- partition_key - Partitioning key monitor element
- past_activities_wrapped - Past activities list wrapped monitor element
- queue_start_time - Queue start timestamp monitor element
- queued_agents - Queued threshold agents monitor element
- service_class_id - Service class ID monitor element
- service_subclass_name - Service subclass name monitor element
- service_superclass_name - Service superclass name monitor element
- table_file_id - Table file ID monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- tablespace_name - Table space name monitor element
- tenant_id - Tenant identifier monitor element
- tenant_name - Tenant name monitor element
- threshold_name - Threshold name monitor element
- thresholdid - Threshold ID monitor element
- utility_invocation_id - Utility invocation ID monitor element
- workload_id - Workload ID monitor element
- workload_name - Workload name monitor element
- xid - Transaction ID monitor element
pkgcache logical data group
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- agents_top - Number of Agents Created monitor element
- comp_env_desc - Compilation environment monitor element
- effective_isolation - Effective isolation monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- executable_id - Executable ID monitor element
- insert_timestamp - Insert timestamp monitor element
- last_metrics_update - Metrics last update timestamp monitor element
- max_coord_stmt_exec_time - Maximum coordinator statement execution time monitor element
- max_coord_stmt_exec_timestamp - Maximum coordinator statement execution timestamp monitor element
- member - Database member monitor element
- num_coord_exec - Number of executions by coordinator agent monitor element
- num_coord_exec_with_metrics - Number of executions by coordinator agent with metrics monitor element
- num_exec_with_metrics - Number of executions with metrics collected monitor element
- num_executions - Statement executions monitor element
- num_routines - Number of routines monitor element
- package_name - Package name monitor element
- package_schema - Package schema monitor element
- package_version_id - Package version monitor element
- partition_key - Partitioning key monitor element
- planid - Query plan ID monitor element
- prep_time - Preparation time monitor element
- prep_warning - Prepare warning SQLCODE monitor element
- prep_warning_reason - Prepare warning SQLCODE reason identifier monitor element
- query_cost_estimate - Query cost estimate monitor element
- query_data_tag_list - Estimated query data tag list monitor element
- routine_id - Routine ID monitor element
- section_env - Section environment monitor element
- section_number - Section number monitor element
- section_type - Section type indicator monitor element
- semantic_env_id - Query semantic compilation environment ID monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- stmt_pkg_cache_id - Statement package cache identifier monitor element
- stmt_comments - Comments in SQL statement text monitor element
- stmt_text - SQL statement text monitor element
- stmt_type_id - Statement type identifier monitor element
- stmtid - Query statement ID monitor element
- stmtno - Statement number monitor element
- tenant_id - Tenant identifier monitor element
- tenant_name - Tenant name monitor element
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
pkgcache_metrics logical data group
- adm_bypass_act_total - Number of times admission control was bypassed monitor element
- adm_overflows - Number of times an activity fit as an overflow monitor element
- audit_events_total - Total audit events monitor element
- audit_file_write_wait_time - Audit file write wait time monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- caching_tier_direct_reads - Direct reads from caching tier monitor element
- caching_tier_direct_read_reqs - Direct read requests from caching tier monitor element
- caching_tier_page_read_time - Caching tier page read time monitor element
- cf_wait_time - cluster caching facility wait time monitor element
- cf_waits - Number of cluster caching facility waits monitor element
- col_vector_consumer_overflows - Columnar vector consumer overflows monitor element
- coord_stmt_exec_time - Execution time for statement by coordinator agent monitor element
- deadlocks - Deadlocks detected monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- disabled_peds - Disabled partial early distincts monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- evmon_wait_time - Event monitor wait time monitor element
- evmon_waits_total - Event monitor total waits monitor element
- ext_table_read_volume - Total data read by external table readers monitor element
- ext_table_recv_volume - Total data received from external table readers monitor element
- ext_table_recv_wait_time - Total agent wait time for external table readers monitor element
- ext_table_recvs_total - Total row batches received from external table readers monitor element
- ext_table_send_volume - Total data sent to external table writers monitor element
- ext_table_send_wait_time - Total agent wait time for external table writers monitor element
- ext_table_sends_total - Total row batches sent to external table writers monitor element
- ext_table_write_volume - Total data written by external table writers monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- fed_rows_deleted - Rows deleted by a federation system monitor element
- fed_rows_inserted - Rows inserted by a federation system monitor element
- fed_rows_read - Rows read by a federation system monitor element
- fed_rows_updated - Rows updated by a federation system monitor element
- fed_wait_time - Time spent by a federation server monitor element
- fed_waits_total - Total number of execution times for a federation server monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- lob_prefetch_reqs - LOB prefetcher request count monitor element
- lob_prefetch_wait_time - Wait time for prefetcher for LOB read or write monitor element
- lock_escals - Number of lock escalations monitor element
- lock_escals_global - Number of global lock escalations monitor element
- lock_escals_locklist - Number of locklist lock escalations monitor element
- lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_timeouts_global - Lock timeouts global monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_wait_time_global - Lock wait time global monitor element
- lock_waits - Lock waits monitor element
- lock_waits_global - Lock waits global monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- member - Database member monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- partition_key - Partitioning key monitor element
- pool_caching_tier_page_read_time - Buffer pool caching tier page read time monitor element
- pool_col_caching_tier_l_reads - Buffer pool column-organized caching tier logical reads monitor element
- pool_col_caching_tier_pages_found - Buffer pool column-organized pages found in caching tier monitor element
- pool_data_caching_tier_l_reads - Buffer pool data caching tier logical reads monitor element
- pool_data_caching_tier_pages_found - Buffer pool data pages found in caching tier monitor element
- pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_failed_async_data_reqs - Failed data prefetch requests monitor element
- pool_failed_async_index_reqs - Failed index prefetch requests monitor element
- pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
- pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
- pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
- pool_index_caching_tier_l_reads - Buffer pool index caching tier logical reads monitor element
- pool_index_caching_tier_pages_found - Buffer pool index pages found in caching tier monitor element
- pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_queued_async_data_pages - Data pages prefetch requests monitor element
- pool_queued_async_data_reqs - Data prefetch requests monitor element
- pool_queued_async_index_pages - Index pages prefetch requests monitor element
- pool_queued_async_index_reqs - Index prefetch requests monitor element
- pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
- pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
- pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
- pool_queued_async_xda_reqs - XDA prefetch requests monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_col_caching_tier_l_reads - Buffer pool temporary column-organized caching tier logical reads monitor element
- pool_temp_col_caching_tier_pages_found - Buffer pool temporary column-organized pages found in caching tier monitor element
- pool_temp_data_caching_tier_l_reads - Buffer pool temporary data caching tier logical reads monitor element
- pool_temp_data_caching_tier_pages_found - Buffer pool temporary data pages found in caching tier monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_caching_tier_l_reads - Buffer pool temporary index caching tier logical reads monitor element
- pool_temp_index_caching_tier_pages_found - Buffer pool temporary index pages found in caching tier monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_caching_tier_l_reads - Buffer pool temporary XML data caching tier logical reads monitor element
- pool_temp_xda_caching_tier_pages_found - Buffer pool temporary XDA data pages found in caching tier monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_caching_tier_l_reads - Buffer pool XML data caching tier logical reads monitor element
- pool_xda_caching_tier_pages_found - Buffer pool XDA data pages found in caching tier monitor element
- pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- post_threshold_peas - Partial early aggregation threshold monitor element
- post_threshold_peds - Partial early distincts threshold monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- prefetch_waits - Prefetcher wait count monitor element
- reclaim_wait_time - Reclaim wait time monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_modified - Rows modified monitor element
- rows_read - Rows read monitor element
- rows_returned - Rows returned monitor element
- rows_updated - Rows updated monitor element
- sort_overflows - Sort overflows monitor element
- spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
- stmt_exec_time - Statement execution time monitor element
- thresh_violations - Number of threshold violations monitor element
- total_act_time - Total activity time monitor element
- total_act_wait_time - Total activity wait time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- total_extended_latch_wait_time - Total extended latch wait time monitor element
- total_extended_latch_waits - Total extended latch waits monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- 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 - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_peas - Total partial early aggregations monitor element
- total_peds - Total partial early distincts monitor element
- total_routine_invocations - Total routine invocations monitor elements
- total_routine_non_sect_proc_time - Non-section processing time monitor element
- total_routine_non_sect_time - Non-section routine execution time monitor elements
- total_routine_time - Total routine time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- total_section_proc_time - Total section processing time monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sort_time - Total section sort time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_time - Total section time monitor element
- total_sorts - Total sorts monitor element
- tq_sort_heap_rejections - Table queue sort heap rejections monitor element
- tq_sort_heap_requests - Table queue sort heap requests monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
pkgcache_stmt_args logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
- stmt_value_data - Value data monitor element
- stmt_value_index - Value index monitor element
- stmt_value_isnull - Value has null value monitor element
- stmt_value_isreopt - Variable used for statement reoptimization monitor element
- stmt_value_type - Value type monitor element
regvar logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
- regvar_collection_type - Registry variable collection type monitor element
- regvar_level - Registry variable level monitor element
- regvar_name - Registry variable name monitor element
- regvar_old_value - Registry variable old value monitor element
- regvar_value - Registry variable value monitor element
txncompletion logical data group
- ddl_classification - DDL classification monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- global_transaction_id - Global transaction identifier monitor element
- local_transaction_id - Local transaction identifier monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
- savepoint_id - Savepoint ID monitor element
- txn_completion_status - Transaction completion status monitor element
- uow_id - Unit of work ID monitor element
uow logical data group
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- application_handle - Application handle monitor element
- caching_tier_direct_reads - Direct reads from caching tier monitor element
- caching_tier_direct_read_reqs - Direct read requests from caching tier monitor element
- caching_tier_page_read_time - Caching tier page read time monitor element
- client_acctng - Client accounting string monitor element
- client_applname - Client application name monitor element
- client_hostname - Client hostname monitor element
- client_pid - Client process ID monitor element
- client_platform - Client operating platform monitor element
- client_port_number - Client port number monitor element
- client_prdid - Client product and version ID monitor element
- client_protocol - Client communication protocol monitor element
- client_userid - Client user ID monitor element
- client_wrkstnname - Client workstation name monitor element
- completion_status - Completion status monitor element
- conn_time - Time of database connection monitor element
- connection_start_time - Connection start time monitor element
- coord_member - Coordinator member monitor element
- db_conn_time - Database activation timestamp monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- executable_list_size - Size of executable list monitor element
- executable_list_truncated - Executable list truncated monitor element
- global_transaction_id - Global transaction identifier monitor element
- intra_parallel_state - Current state of intrapartition parallelism monitor element
- local_transaction_id - Local transaction identifier monitor element
- member - Database member monitor element
- metrics - Metrics monitor element
- mon_interval_id - Monitor interval identifier monitor element
- package_list_exceeded - Package list exceeded monitor element
- package_list_size - Size of package list monitor element
- partition_key - Partitioning key monitor element
- pool_caching_tier_page_read_time - Buffer pool caching tier page read time monitor element
- pool_col_caching_tier_l_reads - Buffer pool column-organized caching tier logical reads monitor element
- pool_data_caching_tier_l_reads - Buffer pool data caching tier logical reads monitor element
- pool_index_caching_tier_l_reads - Buffer pool index caching tier logical reads monitor element
- pool_temp_col_caching_tier_l_reads - Buffer pool temporary column-organized caching tier logical reads monitor element
- pool_temp_col_caching_tier_pages_found - Buffer pool temporary column-organized pages found in caching tier monitor element
- pool_temp_data_caching_tier_l_reads - Buffer pool temporary data caching tier logical reads monitor element
- pool_temp_data_caching_tier_pages_found - Buffer pool temporary data pages found in caching tier monitor element
- pool_temp_index_caching_tier_l_reads - Buffer pool temporary index caching tier logical reads monitor element
- pool_temp_index_caching_tier_pages_found - Buffer pool temporary index pages found in caching tier monitor element
- pool_temp_xda_caching_tier_l_reads - Buffer pool temporary XML data caching tier logical reads monitor element
- pool_temp_xda_caching_tier_pages_found - Buffer pool temporary XDA data pages found in caching tier monitor element
- pool_xda_caching_tier_l_reads - Buffer pool XML data caching tier logical reads monitor element
- service_class_id - Service class ID
- service_subclass_name - Service subclass name
- service_superclass_name - Service superclass name
- session_auth_id - Session authorization ID monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- start_time - Event start time
- stop_time - Event stop time
- system_auth_id - System authorization identifier monitor element
- tenant_id - Tenant identifier monitor element
- tenant_name - Tenant name monitor element
- uow_id - Unit of work ID
- uow_log_space_used - Unit of work log space used monitor element
- workload_id - Workload ID
- workload_name - Workload name
- workload_occurrence_id - Workload occurrence identifier
uow_executable_list logical data group
- appl_id - Application ID monitor element
- executable_id - Executable ID monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- member - Database member monitor element
- num_executions - Statement executions monitor element
- partition_key - Partitioning key monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- rows_read - Rows read monitor element
- sort_overflows - Sort overflows monitor element
- total_act_time - Total activity time monitor element
- total_act_wait_time - Total activity wait time monitor element
- total_cpu_time - Total CPU time monitor element
- total_sorts - Total sorts monitor element
- uow_id - Unit of work ID
uow_metrics logical data group
- act_aborted_total - Total aborted activities monitor element
- act_completed_total - Total completed activities monitor element
- act_rejected_total - Total rejected activities monitor element
- act_rqsts_total - Total activity requests monitor elements
- adm_bypass_act_total - Number of times admission control was bypassed monitor element
- adm_overflows - Number of times an activity fit as an overflow monitor element
- agent_wait_time - Agent wait time monitor element
- agent_waits_total - Total agent waits monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- app_rqsts_completed_total - Total application requests completed monitor element
- appl_id - Application ID monitor element
- appl_section_inserts - Section Inserts monitor element
- appl_section_lookups - Section Lookups monitor element
- audit_events_total - Total audit events monitor element
- audit_file_write_wait_time - Audit file write wait time monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- caching_tier_direct_reads - Direct reads from caching tier monitor element
- caching_tier_direct_read_reqs - Direct read requests from caching tier monitor element
- caching_tier_page_read_time - Caching tier page read time monitor element
- call_sql_stmts - CALL SQL statements executed monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- cf_wait_time - cluster caching facility wait time monitor element
- cf_waits - Number of cluster caching facility waits monitor element
- client_idle_wait_time - Client idle wait time monitor element
- col_vector_consumer_overflows - Columnar vector consumer overflows monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- deadlocks - Deadlocks detected monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- evmon_wait_time - Event monitor wait time monitor element
- evmon_waits_total - Event monitor total waits monitor element
- ext_table_read_volume - Total data read by external table readers monitor element
- ext_table_recv_volume - Total data received from external table readers monitor element
- ext_table_recv_wait_time - Total agent wait time for external table readers monitor element
- ext_table_recvs_total - Total row batches received from external table readers monitor element
- ext_table_send_volume - Total data sent to external table writers monitor element
- ext_table_send_wait_time - Total agent wait time for external table writers monitor element
- ext_table_sends_total - Total row batches sent to external table writers monitor element
- ext_table_write_volume - Total data written by external table writers monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- fed_rows_deleted - Rows deleted by a federation system monitor element
- fed_rows_inserted - Rows inserted by a federation system monitor element
- fed_rows_read - Rows read by a federation system monitor element
- fed_rows_updated - Rows updated by a federation system monitor element
- fed_wait_time - Time spent by a federation server monitor element
- fed_waits_total - Total number of execution times for a federation server monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- int_commits - Internal commits monitor element
- int_rollbacks - Internal rollbacks monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- ipc_recv_volume - Interprocess communication received volume monitor element
- ipc_recv_wait_time - Interprocess communication received wait time monitor element
- ipc_recvs_total - Interprocess communication receives total monitor element
- ipc_send_volume - Interprocess communication send volume monitor element
- ipc_send_wait_time - Interprocess communication send wait time monitor element
- ipc_sends_total - Interprocess communication send total monitor element
- lob_prefetch_reqs - LOB prefetcher request count monitor element
- lob_prefetch_wait_time - Wait time for prefetcher for LOB read or write monitor element
- lock_escals - Number of lock escalations monitor element
- lock_escals_global - Number of global lock escalations monitor element
- lock_escals_locklist - Number of locklist lock escalations monitor element
- lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_timeouts_global - Lock timeouts global monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_wait_time_global - Lock wait time global monitor element
- lock_waits - Lock waits monitor element
- lock_waits_global - Lock waits global monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- member - Database member monitor element
- merge_sql_stmts - Merge SQL statements executed monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- partition_key - Partitioning key monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- pool_caching_tier_page_read_time - Buffer pool caching tier page read time monitor element
- pool_col_caching_tier_l_reads - Buffer pool column-organized caching tier logical reads monitor element
- pool_col_caching_tier_pages_found - Buffer pool column-organized pages found in caching tier monitor element
- pool_data_caching_tier_l_reads - Buffer pool data caching tier logical reads monitor element
- pool_data_caching_tier_pages_found - Buffer pool data pages found in caching tier monitor element
- pool_index_caching_tier_l_reads - Buffer pool index caching tier logical reads monitor element
- pool_index_caching_tier_pages_found - Buffer pool index pages found in caching tier monitor element
- pool_temp_col_caching_tier_l_reads - Buffer pool temporary column-organized caching tier logical reads monitor element
- pool_temp_col_caching_tier_pages_found - Buffer pool temporary column-organized pages found in caching tier monitor element
- pool_temp_data_caching_tier_l_reads - Buffer pool temporary data caching tier logical reads monitor element
- pool_temp_data_caching_tier_pages_found - Buffer pool temporary data pages found in caching tier monitor element
- pool_temp_index_caching_tier_l_reads - Buffer pool temporary index caching tier logical reads monitor element
- pool_temp_index_caching_tier_pages_found - Buffer pool temporary index pages found in caching tier monitor element
- pool_temp_xda_caching_tier_l_reads - Buffer pool temporary XML data caching tier logical reads monitor element
- pool_temp_xda_caching_tier_pages_found - Buffer pool temporary XDA data pages found in caching tier monitor element
- pool_xda_caching_tier_l_reads - Buffer pool XML data caching tier logical reads monitor element
- pool_xda_caching_tier_pages_found - Buffer pool XDA data pages found in caching tier monitor element
- pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_failed_async_data_reqs - Failed data prefetch requests monitor element
- pool_failed_async_index_reqs - Failed index prefetch requests monitor element
- pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
- pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
- pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_queued_async_data_pages - Data pages prefetch requests monitor element
- pool_queued_async_data_reqs - Data prefetch requests monitor element
- pool_queued_async_index_pages - Index pages prefetch requests monitor element
- pool_queued_async_index_reqs - Index prefetch requests monitor element
- pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
- pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
- pool_queued_async_xda_reqs - XDA prefetch requests monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- post_threshold_peas - Partial early aggregation threshold monitor element
- post_threshold_peds - Partial early distincts threshold monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- prefetch_waits - Prefetcher wait count monitor element
- reclaim_wait_time - Reclaim wait time monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_modified - Rows modified monitor element
- rows_read - Rows read monitor element
- rows_returned - Rows returned monitor element
- rows_updated - Rows updated monitor element
- rqsts_completed_total - Total requests completed monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- sort_overflows - Sort overflows monitor element
- spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- tcpip_recv_volume - TCP/IP received volume monitor element
- tcpip_recv_wait_time - TCP/IP received wait time monitor element
- tcpip_recvs_total - TCP/IP receives total monitor element
- tcpip_send_volume - TCP/IP send volume monitor element
- tcpip_send_wait_time - TCP/IP send wait time monitor element
- tcpip_sends_total - TCP/IP sends total monitor element
- thresh_violations - Number of threshold violations monitor element
- total_act_time - Total activity time monitor element
- total_act_wait_time - Total activity wait time monitor element
- total_app_commits - Total application commits monitor elements
- total_app_rollbacks - Total application rollbacks monitor element
- total_app_rqst_time - Total application request time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_backup_proc_time - Total non-wait time for online backups monitor element
- total_backup_time - Total elapsed time for doing online backups monitor element
- total_backups - Total online backups monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
- total_commit_proc_time - Total commits processing time monitor element
- total_commit_time - Total commit time monitor element
- total_compilations - Total compilations monitor element
- total_compile_proc_time - Total compile processing time monitor element
- total_compile_time - Total compile time monitor element
- total_connect_authentications - Connections or switch user authentications performed monitor element
- total_connect_request_time - Total connection or switch user request time monitor element
- total_connect_requests - Connection or switch user requests monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- total_extended_latch_wait_time - Total extended latch wait time monitor element
- total_extended_latch_waits - Total extended latch waits monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- total_implicit_compilations - Total implicit compilations monitor element
- total_implicit_compile_proc_time - Total implicit compile processing time monitor element
- total_implicit_compile_time - Total implicit compile time monitor element
- 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 - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_load_proc_time - Total load processing time monitor element
- total_load_time - Total load time monitor element
- total_loads - Total loads monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_peas - Total partial early aggregations monitor element
- total_peds - Total partial early distincts monitor element
- total_reorg_proc_time - Total reorganization processing time monitor element
- total_reorg_time - Total reorganization time monitor element
- total_reorgs - Total reorganizations monitor element
- total_rollback_proc_time - Total rollback processing time monitor element
- total_rollback_time - Total rollback time monitor element
- total_routine_invocations - Total routine invocations monitor elements
- total_routine_time - Total routine time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- total_rqst_time - Total request time monitor element
- total_runstats - Total runtime statistics monitor element
- total_runstats_proc_time - Total runtime statistics processing time monitor element
- total_runstats_time - Total runtime statistics time monitor element
- total_section_proc_time - Total section processing time monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sort_time - Total section sort time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_time - Total section time monitor element
- total_sorts - Total sorts monitor element
- total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
- total_wait_time - Total wait time monitor element
- tq_sort_heap_rejections - Table queue sort heap rejections monitor element
- tq_sort_heap_requests - Table queue sort heap requests monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- uow_id - Unit of work ID monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
uow_package_list logical data group
- appl_id - Application ID monitor element
- invocation_id - Invocation ID monitor element
- member - Database member monitor element
- nesting_level - Nesting level monitor element
- package_elapsed_time - Package elapsed time monitor element
- package_id - Package identifier monitor element
- partition_key - Partitioning key monitor element
- routine_id - Routine ID monitor element
- uow_id - Unit of work ID monitor element
utillocation logical data group
- device_type - Device type monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- location - Location monitor element
- location_type - Location type monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
- utility_invocation_id - Utility invocation ID monitor element
- utility_type - Utility Type monitor element
utilphase logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- member - Database member monitor element
- object_name - Object name monitor element
- object_schema - Object schema monitor element
- objtype - Object type monitor element
- partition_key - Partitioning key monitor element
- phase_start_event_id - Phase start event ID monitor element
- phase_start_event_timestamp - Phase start event timestamp monitor element
- utility_invocation_id - Utility invocation ID monitor element
- utility_phase_detail - Utility phase detail monitor element
- utility_phase_type - Utility phase type monitor element
- utility_type - Utility Type monitor element
utilstart logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- member - Database member monitor element
- num_tbsps - Number of table spaces monitor element
- object_name - Object name monitor element
- object_schema - Object schema monitor element
- objtype - Object type monitor element
- partition_key - Partitioning key monitor element
- tbsp_names - Table space names monitor element
- utility_detail - Utility detail monitor element
- utility_invocation_id - Utility invocation ID monitor element
- utility_invoker_type - Utility Invoker Type monitor element
- utility_operation_type - Utility operation type monitor element
- utility_priority - Utility Priority monitor element
- utility_start_type - Utility start type monitor element
- utility_type - Utility Type monitor element
utilstop logical data group
- bytes_total - Total number of bytes monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
- sqlca - SQL Communications Area (SQLCA) monitor element
- start_event_id - Start event ID monitor element
- start_event_timestamp - Start event timestamp monitor element
- utility_invocation_id - Utility invocation ID monitor element
- utility_invoker_type - Utility Invoker Type monitor element
- utility_operation_type - Utility operation type monitor element
- utility_stop_type - Utility stop type monitor element
- utility_type - Utility Type monitor element