DB2 Version 10.1 for Linux, UNIX, and Windows

MON_GET_UNIT_OF_WORK table function - Get unit of work metrics

The MON_GET_UNIT_OF_WORK table function returns metrics for one or more units of work.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-MON_GET_UNIT_OF_WORK--(--application_handle--,--member--)---><

The schema is SYSPROC.

Table function parameters

application_handle
An optional input argument of type BIGINT that specifies a valid application handle in the same database as the one currently connected to when calling this function. If the argument is null, metrics are retrieved for units of work running in all superclasses in the database.
member
Start of changeAn optional input argument of type INTEGER that specifies a valid member in the same instance as the currently connected database when calling this function. Specify -1 for the current database member, or -2 for all active database members. If the NULL value is specified, -1 is set implicitly.End of change
Start of changesystem_applsEnd of change
Start of changeAn input parameter of data type SMALLINT that specifies whether information for system applications is returned. The following values are valid:
  • 0 or NULL: System application information is not returned. NULL is the default if a value for system_appls is not provided.
  • 1: User and system application information is returned.
End of change

Authorization

One of the following authorities is required to execute the routine:
  • EXECUTE privilege on the routine
  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority

Default PUBLIC privilege

None

Example

Identify the units of work that are consuming the highest amount of CPU time on the system.

SELECT application_handle, 
       uow_id, 
       total_cpu_time, 
       app_rqsts_completed_total, 
       rqsts_completed_total 
FROM TABLE(MON_GET_UNIT_OF_WORK(NULL,-1)) AS t 
ORDER BY total_cpu_time DESC

The following is an example of output from this query.

APPLICATION_HANDLE   UOW_ID      TOTAL_CPU_TIME       ... 
-------------------- ----------- -------------------- ... 
                  46           5                27959 ... 

  1 record(s) selected.

Output for query (continued).

... APP_RQSTS_COMPLETED_TOTAL RQSTS_COMPLETED_TOTAL
... ------------------------- ---------------------
...                        72                    48

Usage notes

The metrics returned by the MON_GET_UNIT_OF_WORK table function represent the accumulation of all metrics for requests that were submitted during a unit of work. Metrics are rolled up periodically during the unit of work. Therefore, the values reported by this table function reflect the current state of the system at the time of the most recent rollup. Metrics are strictly increasing in value. To determine the value of a given metric for an in interval of time, use the function to query the metric at the start and end of the interval, and compute the difference.

Request metrics are controlled through the COLLECT REQUEST METRICS clause on service superclasses and the mon_req_metrics database configuration parameter at the database level. Metrics are only collected for a request if the request is processed by an agent in a service subclass whose parent service superclass has request metrics enabled, or if request metrics collection is enabled for the entire database. By default, request metrics are enabled at the database level. If request metrics have been disabled at the database level, and for a service superclass, the metrics reported for each unit of work mapped to that service superclass stop increasing (or remain at 0 if request metrics were disabled at database activation time).

The MON_GET_UNIT_OF_WORK table function returns one row of data per unit of work and per member. No aggregation across units of work (on a member), or across members (for a service class or more), is performed. However, aggregation can be achieved through SQL queries. The input parameters have the effect of being ANDed together.

Information returned

Table 1. Information returned for MON_GET_UNIT_OF_WORK
Column Name Data Type Description or corresponding monitor element
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
MEMBER SMALLINT member- Database member
COORD_MEMBER SMALLINT coord_member - Coordinator member
APPLICATION_HANDLE BIGINT application_handle - Application handle
APPLICATION_ID VARCHAR(128) appl_id - Application ID
WORKLOAD_NAME VARCHAR(128) workload_name - Workload name
WORKLOAD_OCCURRENCE_ID INTEGER workload_occurrence_id - Workload occurrence identifier. This ID does not uniquely identify the workload occurrence unless it is coupled with the coordinator member and the workload name.
UOW_ID INTEGER uow_id - Unit of work ID
WORKLOAD_OCCURRENCE_STATE VARCHAR(32) workload_occurrence_state - Workload occurrence state
CLIENT_WRKSTNNAME VARCHAR(255) CURRENT CLIENT_WRKSTNNAME special register
CLIENT_ACCTNG VARCHAR(255) CURRENT CLIENT_ACCTNG special register
CLIENT_USERID VARCHAR(255) CURRENT CLIENT_USERID special register
CLIENT_APPLNAME VARCHAR(255) CURRENT CLIENT_APPLNAME special register
UOW_START_TIME TIMESTAMP uow_start_time - Unit of Work Start Timestamp
SESSION_AUTH_ID VARCHAR(128) session_auth_id - Session authorization ID
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 recv volume
FCM_RECVS_TOTAL BIGINT fcm_recvs_total - FCM recvs 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 recv wait time
FCM_SEND_WAIT_TIME BIGINT fcm_send_wait_time - FCM send wait time
IPC_RECV_VOLUME BIGINT ipc_recv_volume - Interprocess communication recv volume
IPC_RECV_WAIT_TIME BIGINT ipc_recv_wait_time - Interprocess communication recv wait time
IPC_RECVS_TOTAL BIGINT ipc_recvs_total - Interprocess communication recvs 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 - Log disk waits total
NUM_LOCKS_HELD BIGINT locks_held - Locks held
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 recv wait time
TCPIP_RECVS_TOTAL BIGINT tcpip_recvs_total - TCP/IP recvs 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 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
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 thresholds exceeded
UOW_LOG_SPACE_USED BIGINT uow_log_space_used - Unit of Work Log Space Used
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 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
AUDIT_EVENTS_TOTAL BIGINT audit_events_total - Total audit events
AUDIT_FILE_WRITES_TOTAL BIGINT audit_file_writes_total - Total Audit files written
AUDIT_FILE_WRITE_WAIT_TIME BIGINT audit_file_write_wait_time - Audit file write wait time
AUDIT_SUBSYSTEM_WAITS_TOTAL BIGINT audit_subsystem_waits_total - Total audit subsystem waits
AUDIT_SUBSYSTEM_WAIT_TIME BIGINT audit_subsystem_wait_time - Audit subsystem wait time
CLIENT_HOSTNAME VARCHAR(255) client_hostname - Client hostname monitor element
CLIENT_PORT_NUMBER INTEGER client_port_number - Client port number monitor element
DIAGLOG_WRITES_TOTAL BIGINT diaglog_writes_total - Diag log total writes
DIAGLOG_WRITE_WAIT_TIME BIGINT diaglog_write_wait_time - Diag log write time
FCM_MESSAGE_RECVS_TOTAL BIGINT fcm_message_recvs_total - FCM message recvs total
FCM_MESSAGE_RECV_VOLUME BIGINT fcm_message_recv_volume - FCM message recv volume
FCM_MESSAGE_RECV_WAIT_TIME BIGINT fcm_message_recv_wait_time - FCM message recv wait time
FCM_MESSAGE_SENDS_TOTAL BIGINT fcm_message_sends_total - FCM message sends total
FCM_MESSAGE_SEND_VOLUME BIGINT fcm_message_send_volume - FCM message send volume
FCM_MESSAGE_SEND_WAIT_TIME BIGINT fcm_message_send_wait_time - FCM message send wait time
FCM_TQ_RECVS_TOTAL BIGINT fcm_tq_recvs_total - FCM tablequeue recvs total
FCM_TQ_RECV_VOLUME BIGINT fcm_tq_recv_volume - FCM tablequeue recv volume
FCM_TQ_RECV_WAIT_TIME BIGINT fcm_tq_recv_wait_time - FCM tablequeue recv wait time
FCM_TQ_SENDS_TOTAL BIGINT fcm_tq_sends_total - FCM tablequeue send total
FCM_TQ_SEND_VOLUME BIGINT fcm_tq_send_volume - FCM tablequeue send volume
FCM_TQ_SEND_WAIT_TIME BIGINT fcm_tq_send_wait_time - FCM tablequeue send wait time
LAST_EXECUTABLE_ID VARCHAR(32) FOR BIT DATA last_executable_id - Last executable identifier
LAST_REQUEST_TYPE VARCHAR(32) last_request_type - Last request type
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
TQ_TOT_SEND_SPILLS BIGINT tq_tot_send_spills - Total number of table queue buffers overflowed
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
INTRA_PARALLEL_STATE VARCHAR(3) intra_parallel_state - Current state of intrapartition parallelism
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
DISABLED_PEDS BIGINT disabled_peds - Disabled partial early distincts
POOL_QUEUED_ASYNC_DATA_REQS BIGINT pool_queued_async_data_reqs - Data prefetch requests monitor element
POOL_QUEUED_ASYNC_INDEX_REQS BIGINT pool_queued_async_index_reqs - Index prefetch requests monitor element
POOL_QUEUED_ASYNC_XDA_REQS BIGINT pool_queued_async_xda_reqs - XDA prefetch requests monitor element
POOL_QUEUED_ASYNC_TEMP_DATA_REQS BIGINT pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_INDEX_REQS BIGINT pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_XDA_REQS BIGINT pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_OTHER_REQS BIGINT pool_queued_async_other_reqs - Non-prefetch requests monitor element
POOL_QUEUED_ASYNC_DATA_PAGES BIGINT pool_queued_async_data_pages - Data pages prefetch requests monitor element
POOL_QUEUED_ASYNC_INDEX_PAGES BIGINT pool_queued_async_index_pages - Index pages prefetch requests monitor element
POOL_QUEUED_ASYNC_XDA_PAGES BIGINT pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
POOL_QUEUED_ASYNC_TEMP_DATA_PAGES BIGINT pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES BIGINT pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_XDA_PAGES BIGINT pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_DATA_REQS BIGINT pool_failed_async_data_reqs - Failed data prefetch requests monitor element
POOL_FAILED_ASYNC_INDEX_REQS BIGINT pool_failed_async_index_reqs - Failed index prefetch requests monitor element
POOL_FAILED_ASYNC_XDA_REQS BIGINT pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
POOL_FAILED_ASYNC_TEMP_DATA_REQS BIGINT pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_TEMP_INDEX_REQS BIGINT pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_TEMP_XDA_REQS BIGINT pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_OTHER_REQS BIGINT pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
PREFETCH_WAIT_TIME BIGINT prefetch_wait_time - Time waited for prefetch
PREFETCH_WAITS BIGINT prefetch_waits - Prefetcher wait count monitor element
POST_THRESHOLD_PEAS BIGINT post_threshold_peas - Partial early aggregation threshold
POST_THRESHOLD_PEDS BIGINT post_threshold_peds - Partial early distincts threshold
TOTAL_PEAS BIGINT total_peas - Total partial early aggregations
TOTAL_PEDS BIGINT total_peds - Total partial early distincts
TQ_SORT_HEAP_REJECTIONS BIGINT tq_sort_heap_rejections - Table queue sort heap rejections
TQ_SORT_HEAP_REQUESTS BIGINT tq_sort_heap_requests - Table queue sort heap requests
APP_ACT_ABORTED_TOTAL BIGINT app_act_aborted_total - Total failed external coordinator activities monitor element
APP_ACT_COMPLETED_TOTAL BIGINT app_act_completed_total - Total successful external coordinator activities monitor element
APP_ACT_REJECTED_TOTAL BIGINT app_act_rejected_total - Total rejected external coordinator activities monitor element
TOTAL_CONNECT_REQUEST_TIME BIGINT total_connect_request_time - Total connection or switch user request time monitor element
TOTAL_CONNECT_REQUEST_PROC_TIME BIGINT total_connect_request_proc_time - Total connection or switch user request processing time monitor element
TOTAL_CONNECT_REQUESTS BIGINT total_connect_requests - Connection or switch user requests monitor element
TOTAL_CONNECT_AUTHENTICATION_TIME BIGINT total_connect_authentication_time - Total connection or switch user authentication request time monitor element
TOTAL_CONNECT_AUTHENTICATION_PROC_TIME BIGINT total_connect_authentication_proc_time - Total connection authentication processing time monitor element
TOTAL_CONNECT_AUTHENTICATIONS BIGINT total_connect_authentications - Connections or switch user authentications performed monitor element
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
IDA_SEND_WAIT_TIME BIGINT The total amount of time spent waiting to send data to an in-database analytics process.
IDA_SENDS_TOTAL BIGINT The total number of times data was sent to an in-database analytics process.
IDA_SEND_VOLUME BIGINT The total volume of data sent from the database server to an in-database analytics process. The value is reported in bytes.
IDA_RECV_WAIT_TIME BIGINT The total amount of time spent waiting to receive data from an in-database analytics process.
IDA_RECVS_TOTAL BIGINT The total number of times data was received from an in-database analytics process.
IDA_RECV_VOLUME BIGINT The total volume of data the database server received from an in-database analytics process. The value is reported in bytes.
Related concepts:
Buffer pool monitoring in a DB2 pureScale environment
Real-time monitoring with table functions
Unit of work event monitoring
Related tasks:
Calculating buffer pool hit ratios in a DB2 pureScale environment
Collecting unit of work event data and generating reports
Related reference:
ALTER SERVICE CLASS statement
CREATE EVENT MONITOR (unit of work) statement
CREATE SERVICE CLASS statement
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics