Information written to relational tables by EVMON_FORMAT_UE_TO_TABLES for a unit of work event monitor

Information written for a unit of work event monitor from the EVMON_FORMAT_UE_TO_TABLES table function. This is also documented in the sqllib/misc/DB2EvmonUOW.xsd file.
Table 1. Information returned for a unit of work event monitor: Table name: UOW_EVENT
Column Name Data Type Description
EVENT_ID BIGINT NOT NULL event_id - Event ID monitor element
TYPE VARCHAR(128) NOT NULL  
EVENT_TIMESTAMP TIMESTAMP NOT NULL event_timestamp - Event timestamp monitor element
MEMBER SMALLINT member - Database member
COORD_MEMBER SMALLINT coord_member - Coordinator member
COMPLETION_STATUS VARCHAR(128) completion_status - Completion status
START_TIME TIMESTAMP start_time - Event start time
STOP_TIME TIMESTAMP stop_time - Event stop time
WORKLOAD_NAME VARCHAR(128) workload_name - Workload name
WORKLOAD_ID INTEGER workload_id - Workload ID
SERVICE_SUPERCLASS_NAME VARCHAR(128) service_superclass_name - Service superclass name
SERVICE_SUBCLASS_NAME VARCHAR(128) service_subclass_name - Service subclass name
SERVICE_CLASS_ID INTEGER service_class_id - Service class ID
UOW_ID INTEGER uow_id - Unit of work ID
WORKLOAD_OCCURRENCE_ID INTEGER workload_occurrence_id - Workload occurrence identifier
CONNECTION_TIME TIMESTAMP connection_start_time - Connection start time monitor element
MEMBER_ACTIVATION_TIME TIMESTAMP db_conn_time - Database activation timestamp monitor element
APPLICATION_ID VARCHAR(128) appl_id - Application ID monitor element
APPLICATION_HANDLE BIGINT application_handle - Application handle
APPLICATION_NAME VARCHAR(128) appl_name - Application name monitor element
SYSTEM_AUTHID VARCHAR(128) system_auth_id - System authorization identifier monitor element
SESSION_AUTHID VARCHAR(128) session_auth_id - Session authorization ID monitor element
CLIENT_PLATFORM VARCHAR(12) client_platform - Client operating platform
CLIENT_PID BIGINT client_pid - Client process ID
CLIENT_PRODUCT_ID VARCHAR(128) client_prdid - Client product and version ID monitor element
CLIENT_PROTOCOL VARCHAR(10) client_protocol - Client communication protocol
CLIENT_HOSTNAME VARCHAR(255) client_hostname - Client hostname
CLIENT_PORT_NUMBER INTEGER client_port_number - Client port number
CLIENT_WRKSTNNAME VARCHAR(255) client_wrkstnname - Client workstation name
CLIENT_ACCTNG VARCHAR(255) client_acctng - Client accounting string
CLIENT_USERID VARCHAR(255) client_userid - Client user ID
CLIENT_APPLNAME VARCHAR(255) client_applname - Client application name
LOCAL_TRANSACTION_ID VARCHAR(16) local_transaction_id - Local transaction identifier monitor element
GLOBAL_TRANSACTION_ID VARCHAR(40) global_transaction_id - Global transaction identifier monitor element
UOW_LOG_SPACE_USED BIGINT uow_log_space_used - Unit of work log space used
PACKAGE_LIST_SIZE INTEGER package_list_size - Size of package list monitor element
PACKAGE_LIST_EXCEEDED CHAR(3) package_list_exceeded - Package list exceeded
EXECUTABLE_LIST_SIZE BIGINT executable_list_size - Size of executable list monitor element
EXECUTABLE_LIST_TRUNCATED CHAR(3) executable_list_truncated - Executable list truncated monitor element
METRICS BLOB(1M) XML document containing metrics-related monitor elements. The metrics in this document are the same as those described in the UOW_METRICS table that appears later in this topic. See Interfaces that return monitor data in XML documents for more information.
INTRA_PARALLEL_STATE VARCHAR(3) intra_parallel_state - Current state of intrapartition parallelism
MON_INTERVAL_ID BIGINT mon_interval_id - Monitor interval identifier
Table 2. Information returned for a unit of work event monitor: Table name: UOW_PACKAGE_LIST
Column Name Data Type Description
MEMBER SMALLINT member - Database member
UOW_ID INTEGER uow_id - Unit of work ID
APPLICATION_ID VARCHAR(128) appl_id - Application ID monitor element
PACKAGE_ID BIGINT package_id - Package identifier
NESTING_LEVEL INTEGER nesting_level - Nesting level
ROUTINE_ID BIGINT routine_id - Routine ID
INVOCATION_ID INTEGER invocation_id - Invocation ID
PACKAGE_ELAPSED_TIME BIGINT package_elapsed_time - Package elapsed time
Table 3. Information returned for a unit of work event monitor: Table name: UOW_EXECUTABLE_LIST
Column Name Data Type Description
MEMBER SMALLINT member - Database member
UOW_ID INTEGER uow_id - Unit of work ID
APPLICATION_ID VARCHAR(128) appl_id - Application ID monitor element
EXECUTABLE_ID VARCHAR(32) FOR BIT DATA executable_id - Executable ID
NUM_EXECUTIONS BIGINT num_executions - Statement executions
ROWS_READ BIGINT rows_read - Rows read
TOTAL_CPU_TIME BIGINT total_cpu_time - Total CPU time
TOTAL_ACT_TIME BIGINT total_act_time - Total activity time
TOTAL_ACT_WAIT_TIME BIGINT total_act_wait_time - Total activity wait time
LOCK_WAIT_TIME BIGINT lock_wait_time - Time waited on locks
LOCK_WAITS BIGINT lock_waits - Lock waits
TOTAL_SORTS BIGINT total_sorts - Total sorts
POST_THRESHOLD_SORTS BIGINT post_threshold_sorts - Post threshold sorts
POST_SHRTHRESHOLD_SORTS BIGINT post_shrthreshold_sorts - Post shared threshold sorts
SORT_OVERFLOWS BIGINT sort_overflows - Sort overflows
Table 4. Information returned for a unit of work event monitor: Table name: UOW_METRICS. The metrics in this table are the same as those returned in the METRICS monitor element in the UOW_EVENT table
Column Name Data Type Description
MEMBER SMALLINT member - Database member
UOW_ID INTEGER uow_id - Unit of work ID
APPLICATION_ID VARCHAR(128) appl_id - Application ID monitor element
ACT_ABORTED_TOTAL BIGINT act_aborted_total - Total aborted activities
ACT_COMPLETED_TOTAL BIGINT act_completed_total - Total completed activities
ACT_REJECTED_TOTAL BIGINT act_rejected_total - Total rejected activities
AGENT_WAIT_TIME BIGINT agent_wait_time - Agent wait time
AGENT_WAITS_TOTAL BIGINT agent_waits_total - Total agent waits
POOL_DATA_L_READS BIGINT pool_data_l_reads - Buffer pool data logical reads
POOL_INDEX_L_READS BIGINT pool_index_l_reads - Buffer pool index logical reads
POOL_TEMP_DATA_L_READS BIGINT pool_temp_data_l_reads - Buffer pool temporary data logical reads
POOL_TEMP_INDEX_L_READS BIGINT pool_temp_index_l_reads - Buffer pool temporary index logical reads
POOL_TEMP_XDA_L_READS BIGINT pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads
POOL_XDA_L_READS BIGINT pool_xda_l_reads - Buffer pool XDA data logical reads
POOL_DATA_P_READS BIGINT pool_data_p_reads - Buffer pool data physical reads
POOL_INDEX_P_READS BIGINT pool_index_p_reads - Buffer pool index physical reads
POOL_TEMP_DATA_P_READS BIGINT pool_temp_data_p_reads - Buffer pool temporary data physical reads
POOL_TEMP_INDEX_P_READS BIGINT pool_temp_index_p_reads - Buffer pool temporary index physical reads
POOL_TEMP_XDA_P_READS BIGINT pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads
POOL_XDA_P_READS BIGINT pool_xda_p_reads - Buffer pool XDA data physical reads
POOL_DATA_WRITES BIGINT pool_data_writes - Buffer pool data writes
POOL_INDEX_WRITES BIGINT pool_index_writes - Buffer pool index writes
POOL_XDA_WRITES BIGINT pool_xda_writes - Buffer pool XDA data writes
POOL_READ_TIME BIGINT pool_read_time - Total buffer pool physical read time
POOL_WRITE_TIME BIGINT pool_write_time - Total buffer pool physical write time
CLIENT_IDLE_WAIT_TIME BIGINT client_idle_wait_time - Client idle wait time
DEADLOCKS BIGINT deadlocks - Deadlocks detected
DIRECT_READS BIGINT direct_reads - Direct reads from database
DIRECT_READ_TIME BIGINT direct_read_time - Direct read time
DIRECT_WRITES BIGINT direct_writes - Direct writes to database
DIRECT_WRITE_TIME BIGINT direct_write_time - Direct write time
DIRECT_READ_REQS BIGINT direct_read_reqs - Direct read requests
DIRECT_WRITE_REQS BIGINT direct_write_reqs - Direct write requests
FCM_RECV_VOLUME BIGINT fcm_recv_volume - FCM received volume
FCM_RECVS_TOTAL BIGINT fcm_recvs_total - FCM receives total
FCM_SEND_VOLUME BIGINT fcm_send_volume - FCM send volume
FCM_SENDS_TOTAL BIGINT fcm_sends_total - FCM sends total
FCM_RECV_WAIT_TIME BIGINT fcm_recv_wait_time - FCM received wait time
FCM_SEND_WAIT_TIME BIGINT fcm_send_wait_time - FCM send wait time
IPC_RECV_VOLUME BIGINT ipc_recv_volume - Interprocess communication received volume
IPC_RECV_WAIT_TIME BIGINT ipc_recv_wait_time - Interprocess communication received wait time
IPC_RECVS_TOTAL BIGINT ipc_recvs_total - Interprocess communication receives total
IPC_SEND_VOLUME BIGINT ipc_send_volume - Interprocess communication send volume
IPC_SEND_WAIT_TIME BIGINT ipc_send_wait_time - Interprocess communication send wait time
IPC_SENDS_TOTAL BIGINT ipc_sends_total - Interprocess communication send total
LOCK_ESCALS BIGINT lock_escals - Number of lock escalations
LOCK_TIMEOUTS BIGINT lock_timeouts - Number of lock timeouts
LOCK_WAIT_TIME BIGINT lock_wait_time - Time waited on locks
LOCK_WAITS BIGINT lock_waits - Lock waits
LOG_BUFFER_WAIT_TIME BIGINT log_buffer_wait_time - Log buffer wait time
NUM_LOG_BUFFER_FULL BIGINT num_log_buffer_full - Number of full log buffers
LOG_DISK_WAIT_TIME BIGINT log_disk_wait_time - Log disk wait time
LOG_DISK_WAITS_TOTAL BIGINT log_disk_waits_total - Total log disk waits
RQSTS_COMPLETED_TOTAL BIGINT rqsts_completed_total - Total requests completed
ROWS_MODIFIED BIGINT rows_modified - Rows modified
ROWS_READ BIGINT rows_read - Rows read
ROWS_RETURNED BIGINT rows_returned - Rows returned
TCPIP_RECV_VOLUME BIGINT tcpip_recv_volume - TCP/IP received volume
TCPIP_SEND_VOLUME BIGINT tcpip_send_volume - TCP/IP send volume
TCPIP_RECV_WAIT_TIME BIGINT tcpip_recv_wait_time - TCP/IP received wait time
TCPIP_RECVS_TOTAL BIGINT tcpip_recvs_total - TCP/IP receives total
TCPIP_SEND_WAIT_TIME BIGINT tcpip_send_wait_time - TCP/IP send wait time
TCPIP_SENDS_TOTAL BIGINT tcpip_sends_total - TCP/IP sends total
TOTAL_APP_RQST_TIME BIGINT total_app_rqst_time - Total application request time
TOTAL_RQST_TIME BIGINT total_rqst_time - Total request time
WLM_QUEUE_TIME_TOTAL BIGINT wlm_queue_time_total - Workload manager total queue time
WLM_QUEUE_ASSIGNMENTS_TOTAL BIGINT wlm_queue_assignments_total - Workload manager total queue assignments
TOTAL_CPU_TIME BIGINT total_cpu_time - Total CPU time
TOTAL_WAIT_TIME BIGINT total_wait_time - Total wait time
APP_RQSTS_COMPLETED_TOTAL BIGINT app_rqsts_completed_total - Total application requests completed
TOTAL_SECTION_SORT_TIME BIGINT total_section_sort_time - Total section sort time
TOTAL_SECTION_SORT_PROC_TIME BIGINT total_section_sort_proc_time - Total section sort processing time
TOTAL_SECTION_SORTS BIGINT total_section_sorts - Total section sorts
TOTAL_SORTS BIGINT total_sorts - Total sorts
POST_THRESHOLD_SORTS BIGINT post_threshold_sorts - Post threshold sorts
POST_SHRTHRESHOLD_SORTS BIGINT post_shrthreshold_sorts - Post shared threshold sorts
SORT_OVERFLOWS BIGINT sort_overflows - Sort overflows
TOTAL_COMPILE_TIME BIGINT total_compile_time - Total compile time
TOTAL_COMPILE_PROC_TIME BIGINT total_compile_proc_time - Total compile processing time
TOTAL_COMPILATIONS BIGINT total_compilations - Total compilations
TOTAL_IMPLICIT_COMPILE_TIME BIGINT total_implicit_compile_time - Total implicit compile time
TOTAL_IMPLICIT_COMPILE_PROC_TIME BIGINT total_implicit_compile_proc_time - Total implicit compile processing time
TOTAL_IMPLICIT_COMPILATIONS BIGINT total_implicit_compilations - Total implicit complications
TOTAL_SECTION_TIME BIGINT total_section_time - Total section time
TOTAL_SECTION_PROC_TIME BIGINT total_section_proc_time - Total section processing time
TOTAL_APP_SECTION_EXECUTIONS BIGINT total_app_section_executions - Total application section executions
TOTAL_ACT_TIME BIGINT total_act_time - Total activity time
TOTAL_ACT_WAIT_TIME BIGINT total_act_wait_time - Total activity wait time
ACT_RQSTS_TOTAL BIGINT act_rqsts_total - Total activity requests
TOTAL_ROUTINE_TIME BIGINT total_routine_time - Total routine time
TOTAL_ROUTINE_INVOCATIONS BIGINT total_routine_invocations - Total routine invocations
TOTAL_COMMIT_TIME BIGINT total_commit_time - Total commit time
TOTAL_COMMIT_PROC_TIME BIGINT total_commit_proc_time - Total commits processing time
TOTAL_APP_COMMITS BIGINT total_app_commits - Total application commits
INT_COMMITS BIGINT int_commits - Internal commits
TOTAL_ROLLBACK_TIME BIGINT total_rollback_time - Total rollback time
TOTAL_ROLLBACK_PROC_TIME BIGINT total_rollback_proc_time - Total rollback processing time
TOTAL_APP_ROLLBACKS BIGINT total_app_rollbacks - Total application rollbacks
INT_ROLLBACKS BIGINT int_rollbacks - Internal rollbacks
TOTAL_RUNSTATS_TIME BIGINT total_runstats_time - Total runtime statistics time
TOTAL_RUNSTATS_PROC_TIME BIGINT total_runstats_proc_time - Total runtime statistics processing time
TOTAL_RUNSTATS BIGINT total_runstats - Total runtime statistics
TOTAL_REORG_TIME BIGINT total_reorg_time - Total reorganization time
TOTAL_REORG_PROC_TIME BIGINT total_reorg_proc_time - Total reorganization processing time
TOTAL_REORGS BIGINT total_reorgs - Total reorganizations
TOTAL_LOAD_TIME BIGINT total_load_time - Total load time
TOTAL_LOAD_PROC_TIME BIGINT total_load_proc_time - Total load processing time
TOTAL_LOADS BIGINT total_loads - Total loads
CAT_CACHE_INSERTS BIGINT cat_cache_inserts - Catalog cache inserts
CAT_CACHE_LOOKUPS BIGINT cat_cache_lookups - Catalog cache lookups
PKG_CACHE_INSERTS BIGINT pkg_cache_inserts - Package cache inserts
PKG_CACHE_LOOKUPS BIGINT pkg_cache_lookups - Package cache lookups
THRESH_VIOLATIONS BIGINT thresh_violations - Number of threshold violations
NUM_LW_THRESH_EXCEEDED BIGINT num_lw_thresh_exceeded - Number of lock wait thresholds exceeded
FCM_TQ_RECV_WAIT_TIME BIGINT fcm_tq_recv_wait_time - FCM table queue received wait time
FCM_MESSAGE_RECV_WAIT_TIME BIGINT fcm_message_recv_wait_time - FCM message received wait time
FCM_TQ_SEND_WAIT_TIME BIGINT fcm_tq_send_wait_time - FCM table queue send wait time
FCM_MESSAGE_SEND_WAIT_TIME BIGINT fcm_message_send_wait_time - FCM message send wait time
AUDIT_FILE_WRITE_WAIT_TIME BIGINT audit_file_write_wait_time - Audit file write wait time
AUDIT_FILE_WRITES_TOTAL BIGINT audit_file_writes_total - Total audit files written
AUDIT_SUBSYSTEM_WAIT_TIME BIGINT audit_subsystem_wait_time - Audit subsystem wait time
AUDIT_SUBSYSTEM_WAITS_TOTAL BIGINT audit_subsystem_waits_total - Total audit subsystem waits
DIAGLOG_WRITE_WAIT_TIME BIGINT diaglog_write_wait_time - Diagnostic log file write wait time
DIAGLOG_WRITES_TOTAL BIGINT diaglog_writes_total - Total diagnostic log file writes
FCM_MESSAGE_SENDS_TOTAL BIGINT fcm_message_sends_total - Total FCM message sends
FCM_MESSAGE_RECVS_TOTAL BIGINT fcm_message_recvs_total - Total FCM message receives
FCM_MESSAGE_SEND_VOLUME BIGINT fcm_message_send_volume - FCM message send volume
FCM_MESSAGE_RECV_VOLUME BIGINT fcm_message_recv_volume - FCM message received volume
FCM_TQ_SENDS_TOTAL BIGINT fcm_tq_sends_total - FCM table queue send total
FCM_TQ_RECVS_TOTAL BIGINT fcm_tq_recvs_total - FCM table queue receives total
FCM_TQ_SEND_VOLUME BIGINT fcm_tq_send_volume - FCM table queue send volume
FCM_TQ_RECV_VOLUME BIGINT fcm_tq_recv_volume - FCM table queue received volume
TQ_TOT_SEND_SPILLS BIGINT tq_tot_send_spills - Total number of table queue buffers overflowed
AUDIT_EVENTS_TOTAL BIGINT audit_events_total - Total audit events
TOTAL_ROUTINE_USER_CODE_PROC_TIME BIGINT total_routine_user_code_proc_time - Total routine user code processing time
TOTAL_ROUTINE_USER_CODE_TIME BIGINT total_routine_user_code_time - Total routine user code time
LOCK_WAITS_GLOBAL BIGINT lock_waits_global - Lock waits global
LOCK_WAIT_TIME_GLOBAL BIGINT lock_wait_time_global - Lock wait time global
LOCK_TIMEOUTS_GLOBAL BIGINT lock_timeouts_global - Lock timeouts global
LOCK_ESCALS_MAXLOCKS BIGINT lock_escals_maxlocks - Number of maxlocks lock escalations
LOCK_ESCALS_LOCKLIST BIGINT lock_escals_locklist - Number of locklist lock escalations
LOCK_ESCALS_GLOBAL BIGINT lock_escals_global - Number of global lock escalations
RECLAIM_WAIT_TIME BIGINT reclaim_wait_time - Reclaim wait time
SPACEMAPPAGE_RECLAIM_WAIT_TIME BIGINT spacemappage_reclaim_wait_time - Space map page reclaim wait time
CF_WAITS BIGINT cf_waits - Number of cluster caching facility DB2 pureScale server waits
CF_WAIT_TIME BIGINT cf_wait_time - cluster caching facility wait time
POOL_DATA_GBP_L_READS BIGINT pool_data_gbp_l_reads - Group buffer pool data logical reads
POOL_DATA_GBP_P_READS BIGINT pool_data_gbp_p_reads - Group buffer pool data physical reads
POOL_DATA_LBP_PAGES_FOUND BIGINT pool_data_lbp_pages_found - Local buffer pool found data pages
POOL_DATA_GBP_INVALID_PAGES BIGINT pool_data_gbp_invalid_pages - Group buffer pool invalid data pages
POOL_INDEX_GBP_L_READS BIGINT pool_index_gbp_l_reads - Group buffer pool index logical reads
POOL_INDEX_GBP_P_READS BIGINT pool_index_gbp_p_reads - Group buffer pool index physical reads
POOL_INDEX_LBP_PAGES_FOUND BIGINT pool_index_lbp_pages_found - Local buffer pool index pages found
POOL_INDEX_GBP_INVALID_PAGES BIGINT pool_index_gbp_invalid_pages - Group buffer pool invalid index pages
POOL_XDA_GBP_L_READS BIGINT pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests
POOL_XDA_GBP_P_READS BIGINT pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests
POOL_XDA_LBP_PAGES_FOUND BIGINT pool_xda_lbp_pages_found - Local buffer pool XDA data pages found
POOL_XDA_GBP_INVALID_PAGES BIGINT pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages
EVMON_WAIT_TIME BIGINT evmon_wait_time - Event monitor wait time
EVMON_WAITS_TOTAL BIGINT evmon_waits_total - Event monitor total waits
TOTAL_EXTENDED_LATCH_WAIT_TIME BIGINT total_extended_latch_wait_time - Total extended latch wait time
TOTAL_EXTENDED_LATCH_WAITS BIGINT total_extended_latch_waits - Total extended latch waits
TOTAL_STATS_FABRICATION_TIME BIGINT total_stats_fabrication_time - Total statistics fabrication time
TOTAL_STATS_FABRICATION_PROC_TIME BIGINT total_stats_fabrication_proc_time - Total statistics fabrication processing time
TOTAL_STATS_FABRICATIONS BIGINT total_stats_fabrications - Total statistics fabrications
TOTAL_SYNC_RUNSTATS_TIME BIGINT total_sync_runstats_time - Total synchronous RUNSTATS time
TOTAL_SYNC_RUNSTATS_PROC_TIME BIGINT total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time
TOTAL_SYNC_RUNSTATS BIGINT total_sync_runstats - Total synchronous RUNSTATS activities
TOTAL_DISP_RUN_QUEUE_TIME BIGINT total_disp_run_queue_time - Total dispatcher run queue time
TOTAL_PEDS BIGINT total_peds - Total partial early distincts
DISABLED_PEDS BIGINT disabled_peds - Disabled partial early distincts monitor element
POST_THRESHOLD_PEDS BIGINT post_threshold_peds - Partial early distincts threshold
TOTAL_PEAS BIGINT total_peas - Total partial early aggregations
POST_THRESHOLD_PEAS BIGINT post_threshold_peas - Partial early aggregation threshold
TQ_SORT_HEAP_REQUESTS BIGINT tq_sort_heap_requests - Table queue sort heap requests
TQ_SORT_HEAP_REJECTIONS BIGINT tq_sort_heap_rejections - Table queue sort heap rejections
POOL_QUEUED_ASYNC_DATA_REQS BIGINT pool_queued_async_data_reqs - Data prefetch requests
POOL_QUEUED_ASYNC_INDEX_REQS BIGINT pool_queued_async_index_reqs - Index prefetch requests
POOL_QUEUED_ASYNC_XDA_REQS BIGINT pool_queued_async_xda_reqs - XDA prefetch requests
POOL_QUEUED_ASYNC_TEMP_DATA_REQS BIGINT pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces
POOL_QUEUED_ASYNC_TEMP_INDEX_REQS BIGINT pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces
POOL_QUEUED_ASYNC_TEMP_XDA_REQS BIGINT pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces
POOL_QUEUED_ASYNC_OTHER_REQS BIGINT pool_queued_async_other_reqs - Non-prefetch requests
POOL_QUEUED_ASYNC_DATA_PAGES BIGINT pool_queued_async_data_pages - Data pages prefetch requests
POOL_QUEUED_ASYNC_INDEX_PAGES BIGINT pool_queued_async_index_pages - Index pages prefetch requests
POOL_QUEUED_ASYNC_XDA_PAGES BIGINT pool_queued_async_xda_pages - XDA pages prefetch requests
POOL_QUEUED_ASYNC_TEMP_DATA_PAGES BIGINT pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces
POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES BIGINT pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces
POOL_QUEUED_ASYNC_TEMP_XDA_PAGES BIGINT pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces
POOL_FAILED_ASYNC_DATA_REQS BIGINT pool_failed_async_data_reqs - Failed data prefetch requests
POOL_FAILED_ASYNC_INDEX_REQS BIGINT pool_failed_async_index_reqs - Failed index prefetch requests
POOL_FAILED_ASYNC_XDA_REQS BIGINT pool_failed_async_xda_reqs - Failed XDA prefetch requests
POOL_FAILED_ASYNC_TEMP_DATA_REQS BIGINT pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces
POOL_FAILED_ASYNC_TEMP_INDEX_REQS BIGINT pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces
POOL_FAILED_ASYNC_TEMP_XDA_REQS BIGINT pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces
POOL_FAILED_ASYNC_OTHER_REQS BIGINT pool_failed_async_other_reqs - Failed non-prefetch requests
PREFETCH_WAIT_TIME BIGINT prefetch_wait_time - Time waited for prefetch
PREFETCH_WAITS BIGINT prefetch_waits - Prefetcher wait count
APP_ACT_COMPLETED_TOTAL BIGINT app_act_completed_total - Total successful external coordinator activities
APP_ACT_ABORTED_TOTAL BIGINT app_act_aborted_total - Total failed external coordinator activities
APP_ACT_REJECTED_TOTAL BIGINT app_act_rejected_total - Total rejected external coordinator activities
TOTAL_CONNECT_REQUEST_TIME BIGINT total_connect_request_time - Total connection or switch user request time
TOTAL_CONNECT_REQUEST_PROC_TIME BIGINT total_connect_request_proc_time - Total connection or switch user request processing time
TOTAL_CONNECT_REQUESTS BIGINT total_connect_requests - Connection or switch user requests
TOTAL_CONNECT_AUTHENTICATION_TIME BIGINT total_connect_authentication_time - Total connection or switch user authentication request time
TOTAL_CONNECT_AUTHENTICATION_PROC_TIME BIGINT total_connect_authentication_proc_time - Total connection authentication processing time
TOTAL_CONNECT_AUTHENTICATIONS BIGINT total_connect_authentications - Connections or switch user authentications performed
POOL_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
POOL_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
POOL_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
COMM_EXIT_WAIT_TIME BIGINT comm_exit_wait_time - Communication buffer exit wait time monitor element
COMM_EXIT_WAITS BIGINT comm_exit_waits - Communication buffer exit number of waits monitor element