Event monitor logical data groups and monitor elements

• event_activity logical data group
• event_activitymetrics logical data group (in Version 9.7 Fix Pack 4 and later fix packs)
• 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_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_table logical data group
• event_tablespace logical data group
• event_thresholdviolations logical data group
• event_wlmetrics logical data group
• event_wlstats logical data group
• event_wcstats logical data group
• event_xact logical data group
• lock logical data group
• sqlca logical data group

event_activity logical data group

• act_exec_time - Activity execution time monitor element
• activate_timestamp - Activate timestamp monitor element
• activity_id - Activity ID monitor element
• activity_secondary_id - Activity secondary ID monitor element
• activity_type - Activity type monitor element
• address - IP address from which the connection was initiated
• agent_id - Application handle (agent ID) monitor element
• appl_id - Application ID monitor element
• appl_name - Application name monitor element
• arm_correlator - Application response measurement correlator monitor element
• coord_partition_num - Coordinator partition number 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 (This XML document is a metrics document of type activity_metrics, as described in the XML schema document sqllib/misc/DB2MonCommon.xsd. In Version 9.7 Fix Pack 4 and later fix packs, you can also access the metrics reported in this document through the event_activitymetrics logical data group.)
• parent_activity_id - Parent activity ID monitor element
• parent_uow_id - Parent unit of work ID 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
• num_remaps - Number of remaps 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_overflows - Sort overflows monitor element
• sqlca - SQL Communications Area (SQLCA) 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
• 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
• workload_id - Workload ID monitor element
• workload_occurrence_id - Workload occurrence identifier 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_card_estimate - Query Number of Rows Estimate monitor element
• query_cost_estimate - Query cost estimate monitor element
• rows_fetched - Rows fetched monitor element
• rows_modified - Rows modified monitor element
• rows_returned - Rows returned monitor element
• system_cpu_time - System CPU time 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

event_activitymetrics logical data group

This logical data group is available in Version 9.7 Fix Pack 4 and later fix packs.

• audit_events_total - Total audit events 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
• 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
• 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
• 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_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
• 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
• post_shrthreshold_sorts - Post shared threshold sorts monitor element
• post_threshold_sorts - Post threshold sorts monitor element
• rows_modified - Rows modified monitor element
• rows_read - Rows read monitor element
• rows_returned - Rows returned monitor element
• sort_overflows - Sort overflows 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_cpu_time - Total CPU time 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_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

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
• comp_env_desc - Compilation environment monitor element
• creator - Application Creator monitor element
• eff_stmt_text - Effective statement text monitor element
• executable_id - Executable ID monitor element
• package_name - Package name monitor element
• package_version_id - Package version monitor element
• routine_id - Routine ID monitor element
• section_env - Section environment 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_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_pkgcache_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
• 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
• 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

• 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
• 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_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_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_write_time - Total buffer pool physical write time 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
• authority_bitmap - User authorization level monitor element
• authority_lvl - User authorization level monitor element
• binds_precompiles - Binds/Precompiles Attempted 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
• commit_sql_stmts - Commit Statements Attempted 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
• 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
• lock_escalation - Lock escalation 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
• int_rows_updated - Internal Rows Updated 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_write_time - Total buffer pool physical write time monitor element
• prefetch_wait_time - Time waited for prefetch monitor element
• priv_workspace_num_overflows - Private Workspace Overflows monitor element
• priv_workspace_section_inserts - Private Workspace Section Inserts monitor element
• priv_workspace_section_lookups - Private Workspace Section Lookups monitor element
• priv_workspace_size_top - Maximum Private Workspace Size monitor element
• rej_curs_blk - Rejected Block Cursor Requests monitor element
• rollback_sql_stmts - Rollback Statements Attempted monitor element
• rows_read - Rows read monitor element
• rows_selected - Rows Selected monitor element
• rows_written - Rows Written monitor element
• select_sql_stmts - Select SQL Statements Executed monitor element
• sequence_no - Sequence number monitor element
• shr_workspace_num_overflows - Shared Workspace Overflows monitor element
• shr_workspace_section_inserts - Shared Workspace Section Inserts monitor element
• shr_workspace_section_lookups - Shared Workspace Section Lookups monitor element
• shr_workspace_size_top - Maximum Shared Workspace Size 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/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_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

• 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_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
• 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_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_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_write_time - Total buffer pool physical write time 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
• priv_workspace_num_overflows - Private Workspace Overflows monitor element
• priv_workspace_section_inserts - Private Workspace Section Inserts monitor element
• priv_workspace_section_lookups - Private Workspace Section Lookups monitor element
• priv_workspace_size_top - Maximum Private Workspace Size 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
• shr_workspace_num_overflows - Shared Workspace Overflows monitor element
• shr_workspace_section_inserts - Shared Workspace Section Inserts monitor element
• shr_workspace_section_lookups - Shared Workspace Section Lookups monitor element
• shr_workspace_size_top - Maximum Shared Workspace Size monitor element
• sort_overflows - Sort overflows 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/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

• conn_time - Time of database connection monitor element
• db_name - Database Name monitor element
• db_path - Database Path monitor element

event_dbmemuse logical data group

• 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_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_escalation - Lock escalation monitor element
• lock_mode - Lock mode monitor element
• lock_mode_requested - Lock mode requested 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_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

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
• number_in_bin - Number in bin 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

• count - Number of Event Monitor Overflows monitor element
• first_overflow_time - Time of First Event Overflow monitor element
• last_overflow_time - Time of Last Event Overflow monitor element
• node_number - Node Number monitor element

event_qstats logical data group

• last_wlm_reset - Time of last reset 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_scmetrics logical data group

• wlm_queue_time_total - Workload manager total queue time monitor element
• wlm_queue_assignments_total - Workload manager total queue assignments monitor element
• fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
• fcm_message_recv_wait_time - FCM message received wait time monitor element
• fcm_tq_send_wait_time - FCM table queue send wait time monitor element
• fcm_message_send_wait_time - FCM message send wait time monitor element
• agent_wait_time - Agent wait time monitor element
• agent_waits_total - Total agent waits monitor element
• lock_wait_time - Time waited on locks monitor element
• lock_waits - Lock waits monitor element
• direct_read_time - Direct read time monitor element
• direct_read_reqs - Direct read requests monitor element
• direct_write_time - Direct write time monitor element
• direct_write_reqs - Direct write requests monitor element
• log_buffer_wait_time - Log buffer wait time monitor element
• num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
• log_disk_wait_time - Log disk wait time monitor element
• log_disk_waits_total - Total log disk waits monitor element
• tcpip_recv_wait_time - TCP/IP received wait time monitor element
• tcpip_recvs_total - TCP/IP receives total monitor element
• client_idle_wait_time - Client idle wait time monitor element
• ipc_recv_wait_time - Interprocess communication received wait time monitor element
• ipc_recvs_total - Interprocess communication receives total monitor element
• ipc_send_wait_time - Interprocess communication send wait time monitor element
• ipc_sends_total - Interprocess communication send total monitor element
• tcpip_send_wait_time - TCP/IP send wait time monitor element
• tcpip_sends_total - TCP/IP sends total monitor element
• pool_write_time - Total buffer pool physical write time monitor element
• pool_read_time - Total buffer pool physical read time 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
• diaglog_write_wait_time - Diagnostic log file write wait time monitor element
• diaglog_writes_total - Total diagnostic log file writes monitor element
• fcm_send_wait_time - FCM send wait time monitor element
• fcm_recv_wait_time - FCM received wait time monitor element
• total_wait_time - Total wait time monitor element
• rqsts_completed_total - Total requests completed monitor element
• total_rqst_time - Total request time monitor element
• app_rqsts_completed_total - Total application requests completed monitor element
• total_app_rqst_time - Total application request time monitor element
• total_section_sort_proc_time - Total section sort processing time monitor element
• total_section_sorts - Total section sorts monitor element
• total_section_sort_time - Total section sort time monitor element
• rows_read - Rows read monitor element
• rows_modified - Rows modified monitor element
• pool_data_l_reads - Buffer pool data logical reads monitor element
• pool_index_l_reads - Buffer pool index logical reads monitor element
• pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
• pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
• pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
• pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
• total_cpu_time - Total CPU time monitor element
• act_completed_total - Total completed activities monitor element
• pool_data_p_reads - Buffer pool data physical reads monitor element
• pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
• pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
• pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
• pool_index_p_reads - Buffer pool index physical reads monitor element
• pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
• pool_data_writes - Buffer pool data writes monitor element
• pool_xda_writes - Buffer pool XDA data writes monitor element
• pool_index_writes - Buffer pool index writes monitor element
• direct_reads - Direct reads from database monitor element
• direct_writes - Direct writes to database monitor element
• rows_returned - Rows returned monitor element
• deadlocks - Deadlocks detected monitor element
• lock_timeouts - Number of lock timeouts monitor element
• lock_escals - Number of lock escalations monitor element
• fcm_sends_total - FCM sends total monitor element
• fcm_recvs_total - FCM receives total monitor element
• fcm_send_volume - FCM send volume monitor element
• fcm_recv_volume - FCM received volume monitor element
• fcm_message_sends_total - Total FCM message sends monitor element
• fcm_message_recvs_total - Total FCM message receives monitor element
• fcm_message_send_volume - FCM message send volume monitor element
• fcm_message_recv_volume - FCM message received volume monitor element
• fcm_tq_sends_total - FCM table queue send total 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_recv_volume - FCM table queue received volume monitor element
• tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
• tcpip_send_volume - TCP/IP send volume monitor element
• tcpip_recv_volume - TCP/IP received volume monitor element
• ipc_send_volume - Interprocess communication send volume monitor element
• ipc_recv_volume - Interprocess communication received volume monitor element
• post_threshold_sorts - Post threshold sorts monitor element
• post_shrthreshold_sorts - Post shared threshold sorts monitor element
• sort_overflows - Sort overflows monitor element
• audit_events_total - Total audit events monitor element
• total_rqst_mapped_in - Total request mapped-in monitor element
• total_rqst_mapped_out - Total request mapped-out monitor element
• act_rejected_total - Total rejected activities monitor element
• act_aborted_total - Total aborted activities monitor element
• total_sorts - Total sorts monitor element
• total_routine_time - Total routine time monitor element
• total_compile_proc_time - Total compile processing time monitor element
• total_compilations - Total compilations monitor element
• total_compile_time - Total compile time monitor element
• total_implicit_compile_proc_time - Total implicit compile processing time monitor element
• total_implicit_compilations - Total implicit complications monitor element
• total_implicit_compile_time - Total implicit compile time monitor element
• total_runstats_proc_time - Total runtime statistics processing time monitor element
• total_runstats - Total runtime statistics monitor element
• total_runstats_time - Total runtime statistics time monitor element
• total_reorg_proc_time - Total reorganization processing time monitor element
• total_reorgs - Total reorganizations monitor element
• total_reorg_time - Total reorganization time monitor element
• total_load_proc_time - Total load processing time monitor element
• total_loads - Total loads monitor element
• total_load_time - Total load time monitor element
• total_section_proc_time - Total section processing time monitor element
• total_app_section_executions - Total application section executions monitor element
• total_section_time - Total section time monitor element
• total_commit_proc_time - Total commits processing time monitor element
• total_app_commits - Total application commits monitor elements
• total_commit_time - Total commit time monitor element
• total_rollback_proc_time - Total rollback processing time monitor element
• total_app_rollbacks - Total application rollbacks monitor element
• total_rollback_time - Total rollback 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
• thresh_violations - Number of threshold violations monitor element
• num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
• total_routine_invocations - Total routine invocations monitor elements
• int_commits - Internal commits monitor element
• int_rollbacks - Internal rollbacks monitor element
• cat_cache_inserts - Catalog cache inserts monitor element
• cat_cache_lookups - Catalog cache lookups monitor element
• pkg_cache_inserts - Package cache inserts monitor element
• pkg_cache_lookups - Package cache lookups monitor element
• act_rqsts_total - Total activity requests monitor elements
• total_act_wait_time - Total activity wait time monitor element
• total_act_time - Total activity time monitor element
• FCM_TQ_RECV_WAITS_TOTAL
• FCM_MESSAGE_RECV_WAITS_TOTAL
• FCM_TQ_SEND_WAITS_TOTAL
• FCM_MESSAGE_SEND_WAITS_TOTAL
• FCM_SEND_WAITS_TOTAL
• FCM_RECV_WAITS_TOTAL

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
• agg_temp_tablespace_top - Aggregate temporary table space top monitor element
• concurrent_act_top - Concurrent activity top monitor element
• concurrent_wlo_top - Concurrent workload occurrences top monitor element
• concurrent_connection_top - Concurrent connection 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
• details_xml*
• last_wlm_reset - Time of last reset monitor element
• metrics* (In Version 9.7 Fix Pack 6 and later fix packs, you can also access metrics reported in this document through the event_scmetrics logical data group.)
• 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
• statistics_timestamp - Statistics timestamp monitor element
• temp_tablespace_top - Temporary table space top monitor element
• uow_total_time_top - UOW total time top monitor element

event_start logical data group

• start_time - Event Start Time monitor element

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
• 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
• 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
• 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

• 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_pkgcache_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
• num_agents - Number of Agents Working on a Statement monitor element
• partial_record - Partial Record 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

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

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_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
• tablespace_name - Table space name 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
• client_acctng - Client accounting string monitor element
• client_applname - Client application name monitor element
• client_hostname - Client hostname monitor element
• appl_name - Application name 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
• 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
• 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_wlmetrics logical data group

• wlm_queue_time_total - Workload manager total queue time monitor element
• wlm_queue_assignments_total - Workload manager total queue assignments monitor element
• fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
• fcm_message_recv_wait_time - FCM message received wait time monitor element
• fcm_tq_send_wait_time - FCM table queue send wait time monitor element
• fcm_message_send_wait_time - FCM message send wait time monitor element
• agent_wait_time - Agent wait time monitor element
• agent_waits_total - Total agent waits monitor element
• lock_wait_time - Time waited on locks monitor element
• lock_waits - Lock waits monitor element
• direct_read_time - Direct read time monitor element
• direct_read_reqs - Direct read requests monitor element
• direct_write_time - Direct write time monitor element
• direct_write_reqs - Direct write requests monitor element
• log_buffer_wait_time - Log buffer wait time monitor element
• num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
• log_disk_wait_time - Log disk wait time monitor element
• log_disk_waits_total - Total log disk waits monitor element
• tcpip_recv_wait_time - TCP/IP received wait time monitor element
• tcpip_recvs_total - TCP/IP receives total monitor element
• client_idle_wait_time - Client idle wait time monitor element
• ipc_recv_wait_time - Interprocess communication received wait time monitor element
• ipc_recvs_total - Interprocess communication receives total monitor element
• ipc_send_wait_time - Interprocess communication send wait time monitor element
• ipc_sends_total - Interprocess communication send total monitor element
• tcpip_send_wait_time - TCP/IP send wait time monitor element
• tcpip_sends_total - TCP/IP sends total monitor element
• pool_write_time - Total buffer pool physical write time monitor element
• pool_read_time - Total buffer pool physical read time 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
• diaglog_write_wait_time - Diagnostic log file write wait time monitor element
• diaglog_writes_total - Total diagnostic log file writes monitor element
• fcm_send_wait_time - FCM send wait time monitor element
• fcm_recv_wait_time - FCM received wait time monitor element
• total_wait_time - Total wait time monitor element
• rqsts_completed_total - Total requests completed monitor element
• total_rqst_time - Total request time monitor element
• app_rqsts_completed_total - Total application requests completed monitor element
• total_app_rqst_time - Total application request time monitor element
• total_section_sort_proc_time - Total section sort processing time monitor element
• total_section_sorts - Total section sorts monitor element
• total_section_sort_time - Total section sort time monitor element
• rows_read - Rows read monitor element
• rows_modified - Rows modified monitor element
• pool_data_l_reads - Buffer pool data logical reads monitor element
• pool_index_l_reads - Buffer pool index logical reads monitor element
• pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
• pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
• pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
• pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
• total_cpu_time - Total CPU time monitor element
• act_completed_total - Total completed activities monitor element
• pool_data_p_reads - Buffer pool data physical reads monitor element
• pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
• pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
• pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
• pool_index_p_reads - Buffer pool index physical reads monitor element
• pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
• pool_data_writes - Buffer pool data writes monitor element
• pool_xda_writes - Buffer pool XDA data writes monitor element
• pool_index_writes - Buffer pool index writes monitor element
• direct_reads - Direct reads from database monitor element
• direct_writes - Direct writes to database monitor element
• rows_returned - Rows returned monitor element
• deadlocks - Deadlocks detected monitor element
• lock_timeouts - Number of lock timeouts monitor element
• lock_escals - Number of lock escalations monitor element
• fcm_sends_total - FCM sends total monitor element
• fcm_recvs_total - FCM receives total monitor element
• fcm_send_volume - FCM send volume monitor element
• fcm_recv_volume - FCM received volume monitor element
• fcm_message_sends_total - Total FCM message sends monitor element
• fcm_message_recvs_total - Total FCM message receives monitor element
• fcm_message_send_volume - FCM message send volume monitor element
• fcm_message_recv_volume - FCM message received volume monitor element
• fcm_tq_sends_total - FCM table queue send total 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_recv_volume - FCM table queue received volume monitor element
• tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
• tcpip_send_volume - TCP/IP send volume monitor element
• tcpip_recv_volume - TCP/IP received volume monitor element
• ipc_send_volume - Interprocess communication send volume monitor element
• ipc_recv_volume - Interprocess communication received volume monitor element
• post_threshold_sorts - Post threshold sorts monitor element
• post_shrthreshold_sorts - Post shared threshold sorts monitor element
• sort_overflows - Sort overflows monitor element
• audit_events_total - Total audit events monitor element
• act_rejected_total - Total rejected activities monitor element
• act_aborted_total - Total aborted activities monitor element
• total_sorts - Total sorts monitor element
• total_routine_time - Total routine time monitor element
• total_compile_proc_time - Total compile processing time monitor element
• total_compilations - Total compilations monitor element
• total_compile_time - Total compile time monitor element
• total_implicit_compile_proc_time - Total implicit compile processing time monitor element
• total_implicit_compilations - Total implicit complications monitor element
• total_implicit_compile_time - Total implicit compile time monitor element
• total_runstats_proc_time - Total runtime statistics processing time monitor element
• total_runstats - Total runtime statistics monitor element
• total_runstats_time - Total runtime statistics time monitor element
• total_reorg_proc_time - Total reorganization processing time monitor element
• total_reorgs - Total reorganizations monitor element
• total_reorg_time - Total reorganization time monitor element
• total_load_proc_time - Total load processing time monitor element
• total_loads - Total loads monitor element
• total_load_time - Total load time monitor element
• total_section_proc_time - Total section processing time monitor element
• total_app_section_executions - Total application section executions monitor element
• total_section_time - Total section time monitor element
• total_commit_proc_time - Total commits processing time monitor element
• total_app_commits - Total application commits monitor elements
• total_commit_time - Total commit time monitor element
• total_rollback_proc_time - Total rollback processing time monitor element
• total_app_rollbacks - Total application rollbacks monitor element
• total_rollback_time - Total rollback 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
• thresh_violations - Number of threshold violations monitor element
• num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
• total_routine_invocations - Total routine invocations monitor elements
• int_commits - Internal commits monitor element
• int_rollbacks - Internal rollbacks monitor element
• cat_cache_inserts - Catalog cache inserts monitor element
• cat_cache_lookups - Catalog cache lookups monitor element
• pkg_cache_inserts - Package cache inserts monitor element
• pkg_cache_lookups - Package cache lookups monitor element
• act_rqsts_total - Total activity requests monitor elements
• total_act_wait_time - Total activity wait time monitor element
• total_act_time - Total activity time monitor element
• FCM_TQ_RECV_WAITS_TOTAL
• FCM_MESSAGE_RECV_WAITS_TOTAL
• FCM_TQ_SEND_WAITS_TOTAL
• FCM_MESSAGE_SEND_WAITS_TOTAL
• FCM_SEND_WAITS_TOTAL
• FCM_RECV_WAITS_TOTAL

event_wlstats logical data group

• act_cpu_time_top - Activity CPU time top monitor element
• act_rows_read_top - Activity rows read top 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
• details_xml*
• last_wlm_reset - Time of last reset monitor element
• lock_wait_time_top - Lock wait time top monitor element
• metrics* (In Version 9.7 Fix Pack 6 and later fix packs, you can also access metrics reported in this document through the event_wlmetrics logical data group.)
• rows_returned_top - Actual rows returned top monitor element
• statistics_timestamp - Statistics timestamp monitor element
• uow_total_time_top - UOW total time top monitor element
• temp_tablespace_top - Temporary table space 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_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
• 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_xact logical data group

• agent_id - Application handle (agent ID) monitor element
• appl_id - Application ID 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
• system_cpu_time - System CPU time 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
• stop_time - Event Stop Time monitor element
• user_cpu_time - User CPU time monitor element
• x_lock_escals - Exclusive lock escalations monitor element

lock 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

sqlca logical data group

• sqlcabc
• sqlcaid
• sqlcode
• sqlerrd
• sqlerrmc
• sqlerrml
• sqlerrp
• sqlstate
• sqlwarn