DB2 Version 9.7 for Linux, UNIX, and Windows

Information written to relational 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 INTEGER NOT NULL  
TYPE VARCHAR(128) NOT NULL  
EVENT_TIMESTAMP TIMESTAMP NOT NULL  
MEMBER SMALLINT member - Database member monitor element
COORD_MEMBER SMALLINT coord_member - Coordinator member monitor element
COMPLETION_STATUS VARCHAR(128) completion_status - Completion status monitor element
START_TIME TIMESTAMP start_time - Event Start Time monitor element
STOP_TIME TIMESTAMP stop_time - Event Stop Time monitor element
WORKLOAD_NAME VARCHAR(128) workload_name - Workload name monitor element
WORKLOAD_ID INTEGER workload_id - Workload ID monitor element
SERVICE_SUPERCLASS_NAME VARCHAR(128) service_superclass_name - Service superclass name monitor element
SERVICE_SUBCLASS_NAME VARCHAR(128) service_subclass_name - Service subclass name monitor element
SERVICE_CLASS_ID INTEGER service_class_id - Service class ID monitor element
UOW_ID INTEGER uow_id - Unit of work ID monitor element
WORKLOAD_OCCURRENCE_ID INTEGER workload_occurrence_id - Workload occurrence identifier monitor element
CONNECTION_TIME TIMESTAMP  
MEMBER_ACTIVATION_TIME TIMESTAMP  
APPLICATION_ID VARCHAR(128)  
APPLICATION_HANDLE BIGINT application_handle - Application handle monitor element
APPLICATION_NAME VARCHAR(128)  
SYSTEM_AUTHID VARCHAR(128)  
SESSION_AUTHID VARCHAR(128)  
CLIENT_PLATFORM VARCHAR(12) client_platform - Client operating platform monitor element
CLIENT_PID BIGINT client_pid - Client process ID monitor element
CLIENT_PRODUCT_ID VARCHAR(128)  
CLIENT_PROTOCOL VARCHAR(10) client_protocol - Client communication protocol monitor element
CLIENT_HOSTNAME VARCHAR(255) client_hostname - Client hostname monitor element
CLIENT_PORT_NUMBER INTEGER client_port_number - Client port number monitor element
CLIENT_WRKSTNNAME VARCHAR(255) client_wrkstnname - Client workstation name monitor element
CLIENT_ACCTNG VARCHAR(255) client_acctng - Client accounting string monitor element
CLIENT_USERID VARCHAR(255) client_userid - Client user ID monitor element
CLIENT_APPLNAME VARCHAR(255) client_applname - Client application name monitor element
LOCAL_TRANSACTION_ID VARCHAR(16)  
GLOBAL_TRANSACTION_ID VARCHAR(40)  
UOW_LOG_SPACE_USED BIGINT uow_log_space_used - Unit of work log space used monitor element
PACKAGE_LIST_SIZE INTEGER  
PACKAGE_LIST_EXCEEDED CHAR(3)  
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.
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 monitor element
UOW_ID INTEGER uow_id - Unit of work ID monitor element
APPLICATION_ID VARCHAR(128)  
PACKAGE_ID BIGINT  
NESTING_LEVEL INTEGER nesting_level - Nesting level monitor element
ROUTINE_ID INTEGER routine_id - Routine ID monitor element
INVOCATION_ID INTEGER invocation_id - Invocation ID monitor element
PACKAGE_ELAPSED_TIME BIGINT  
Table 3. 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 monitor element
UOW_ID INTEGER uow_id - Unit of work ID monitor element
APPLICATION_ID VARCHAR(128)  
ACT_ABORTED_TOTAL BIGINT act_aborted_total - Total aborted activities monitor element
ACT_COMPLETED_TOTAL BIGINT act_completed_total - Total completed activities monitor element
ACT_REJECTED_TOTAL BIGINT act_rejected_total - Total rejected activities monitor element
AGENT_WAIT_TIME BIGINT agent_wait_time - Agent wait time monitor element
AGENT_WAITS_TOTAL BIGINT agent_waits_total - Total agent waits monitor element
POOL_DATA_L_READS BIGINT pool_data_l_reads - Buffer pool data logical reads monitor element
POOL_INDEX_L_READS BIGINT pool_index_l_reads - Buffer pool index logical reads monitor element
POOL_TEMP_DATA_L_READS BIGINT pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
POOL_TEMP_INDEX_L_READS BIGINT pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
POOL_TEMP_XDA_L_READS BIGINT pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
POOL_XDA_L_READS BIGINT pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
POOL_DATA_P_READS BIGINT pool_data_p_reads - Buffer pool data physical reads monitor element
POOL_INDEX_P_READS BIGINT pool_index_p_reads - Buffer pool index physical reads monitor element
POOL_TEMP_DATA_P_READS BIGINT pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
POOL_TEMP_INDEX_P_READS BIGINT pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
POOL_TEMP_XDA_P_READS BIGINT pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
POOL_XDA_P_READS BIGINT pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
POOL_DATA_WRITES BIGINT pool_data_writes - Buffer pool data writes monitor element
POOL_INDEX_WRITES BIGINT pool_index_writes - Buffer pool index writes monitor element
POOL_XDA_WRITES BIGINT pool_xda_writes - Buffer pool XDA data writes monitor element
POOL_READ_TIME BIGINT pool_read_time - Total buffer pool physical read time monitor element
POOL_WRITE_TIME BIGINT pool_write_time - Total buffer pool physical write time monitor element
CLIENT_IDLE_WAIT_TIME BIGINT client_idle_wait_time - Client idle wait time monitor element
DEADLOCKS BIGINT deadlocks - Deadlocks detected monitor element
DIRECT_READS BIGINT direct_reads - Direct reads from database monitor element
DIRECT_READ_TIME BIGINT direct_read_time - Direct read time monitor element
DIRECT_WRITES BIGINT direct_writes - Direct writes to database monitor element
DIRECT_WRITE_TIME BIGINT direct_write_time - Direct write time monitor element
DIRECT_READ_REQS BIGINT direct_read_reqs - Direct read requests monitor element
DIRECT_WRITE_REQS BIGINT direct_write_reqs - Direct write requests monitor element
FCM_RECV_VOLUME BIGINT fcm_recv_volume - FCM received volume monitor element
FCM_RECVS_TOTAL BIGINT fcm_recvs_total - FCM receives total monitor element
FCM_SEND_VOLUME BIGINT fcm_send_volume - FCM send volume monitor element
FCM_SENDS_TOTAL BIGINT fcm_sends_total - FCM sends total monitor element
FCM_RECV_WAIT_TIME BIGINT fcm_recv_wait_time - FCM received wait time monitor element
FCM_SEND_WAIT_TIME BIGINT fcm_send_wait_time - FCM send wait time monitor element
IPC_RECV_VOLUME BIGINT ipc_recv_volume - Interprocess communication received volume monitor element
IPC_RECV_WAIT_TIME BIGINT ipc_recv_wait_time - Interprocess communication received wait time monitor element
IPC_RECVS_TOTAL BIGINT ipc_recvs_total - Interprocess communication receives total monitor element
IPC_SEND_VOLUME BIGINT ipc_send_volume - Interprocess communication send volume monitor element
IPC_SEND_WAIT_TIME BIGINT ipc_send_wait_time - Interprocess communication send wait time monitor element
IPC_SENDS_TOTAL BIGINT ipc_sends_total - Interprocess communication send total monitor element
LOCK_ESCALS BIGINT lock_escals - Number of lock escalations monitor element
LOCK_TIMEOUTS BIGINT lock_timeouts - Number of lock timeouts monitor element
LOCK_WAIT_TIME BIGINT lock_wait_time - Time waited on locks monitor element
LOCK_WAITS BIGINT lock_waits - Lock waits monitor element
LOG_BUFFER_WAIT_TIME BIGINT log_buffer_wait_time - Log buffer wait time monitor element
NUM_LOG_BUFFER_FULL BIGINT num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
LOG_DISK_WAIT_TIME BIGINT log_disk_wait_time - Log disk wait time monitor element
LOG_DISK_WAITS_TOTAL BIGINT log_disk_waits_total - Total log disk waits monitor element
RQSTS_COMPLETED_TOTAL BIGINT rqsts_completed_total - Total requests completed monitor element
ROWS_MODIFIED BIGINT rows_modified - Rows modified monitor element
ROWS_READ BIGINT rows_read - Rows read monitor element
ROWS_RETURNED BIGINT rows_returned - Rows returned monitor element
TCPIP_RECV_VOLUME BIGINT tcpip_recv_volume - TCP/IP received volume monitor element
TCPIP_SEND_VOLUME BIGINT tcpip_send_volume - TCP/IP send volume monitor element
TCPIP_RECV_WAIT_TIME BIGINT tcpip_recv_wait_time - TCP/IP received wait time monitor element
TCPIP_RECVS_TOTAL BIGINT tcpip_recvs_total - TCP/IP receives total monitor element
TCPIP_SEND_WAIT_TIME BIGINT tcpip_send_wait_time - TCP/IP send wait time monitor element
TCPIP_SENDS_TOTAL BIGINT tcpip_sends_total - TCP/IP sends total monitor element
TOTAL_APP_RQST_TIME BIGINT total_app_rqst_time - Total application request time monitor element
TOTAL_RQST_TIME BIGINT total_rqst_time - Total request time monitor element
WLM_QUEUE_TIME_TOTAL BIGINT wlm_queue_time_total - Workload manager total queue time monitor element
WLM_QUEUE_ASSIGNMENTS_TOTAL BIGINT wlm_queue_assignments_total - Workload manager total queue assignments monitor element
TOTAL_CPU_TIME BIGINT total_cpu_time - Total CPU time monitor element
TOTAL_WAIT_TIME BIGINT total_wait_time - Total wait time monitor element
APP_RQSTS_COMPLETED_TOTAL BIGINT app_rqsts_completed_total - Total application requests completed monitor element
TOTAL_SECTION_SORT_TIME BIGINT total_section_sort_time - Total section sort time monitor element
TOTAL_SECTION_SORT_PROC_TIME BIGINT total_section_sort_proc_time - Total section sort processing time monitor element
TOTAL_SECTION_SORTS BIGINT total_section_sorts - Total section sorts monitor element
TOTAL_SORTS BIGINT total_sorts - Total sorts monitor element
POST_THRESHOLD_SORTS BIGINT post_threshold_sorts - Post threshold sorts monitor element
POST_SHRTHRESHOLD_SORTS BIGINT post_shrthreshold_sorts - Post shared threshold sorts monitor element
SORT_OVERFLOWS BIGINT sort_overflows - Sort overflows monitor element
TOTAL_COMPILE_TIME BIGINT total_compile_time - Total compile time monitor element
TOTAL_COMPILE_PROC_TIME BIGINT total_compile_proc_time - Total compile processing time monitor element
TOTAL_COMPILATIONS BIGINT total_compilations - Total compilations monitor element
TOTAL_IMPLICIT_COMPILE_TIME BIGINT total_implicit_compile_time - Total implicit compile time monitor element
TOTAL_IMPLICIT_COMPILE_PROC_TIME BIGINT total_implicit_compile_proc_time - Total implicit compile processing time monitor element
TOTAL_IMPLICIT_COMPILATIONS BIGINT total_implicit_compilations - Total implicit complications monitor element
TOTAL_SECTION_TIME BIGINT total_section_time - Total section time monitor element
TOTAL_SECTION_PROC_TIME BIGINT total_section_proc_time - Total section processing time monitor element
TOTAL_APP_SECTION_EXECUTIONS BIGINT total_app_section_executions - Total application section executions monitor element
TOTAL_ACT_TIME BIGINT total_act_time - Total activity time monitor element
TOTAL_ACT_WAIT_TIME BIGINT total_act_wait_time - Total activity wait time monitor element
ACT_RQSTS_TOTAL BIGINT act_rqsts_total - Total activity requests monitor elements
TOTAL_ROUTINE_TIME BIGINT total_routine_time - Total routine time monitor element
TOTAL_ROUTINE_INVOCATIONS BIGINT total_routine_invocations - Total routine invocations monitor elements
TOTAL_COMMIT_TIME BIGINT total_commit_time - Total commit time monitor element
TOTAL_COMMIT_PROC_TIME BIGINT total_commit_proc_time - Total commits processing time monitor element
TOTAL_APP_COMMITS BIGINT total_app_commits - Total application commits monitor elements
INT_COMMITS BIGINT int_commits - Internal commits monitor element
TOTAL_ROLLBACK_TIME BIGINT total_rollback_time - Total rollback time monitor element
TOTAL_ROLLBACK_PROC_TIME BIGINT total_rollback_proc_time - Total rollback processing time monitor element
TOTAL_APP_ROLLBACKS BIGINT total_app_rollbacks - Total application rollbacks monitor element
INT_ROLLBACKS BIGINT int_rollbacks - Internal rollbacks monitor element
TOTAL_RUNSTATS_TIME BIGINT total_runstats_time - Total runtime statistics time monitor element
TOTAL_RUNSTATS_PROC_TIME BIGINT total_runstats_proc_time - Total runtime statistics processing time monitor element
TOTAL_RUNSTATS BIGINT total_runstats - Total runtime statistics monitor element
TOTAL_REORG_TIME BIGINT total_reorg_time - Total reorganization time monitor element
TOTAL_REORG_PROC_TIME BIGINT total_reorg_proc_time - Total reorganization processing time monitor element
TOTAL_REORGS BIGINT total_reorgs - Total reorganizations monitor element
TOTAL_LOAD_TIME BIGINT total_load_time - Total load time monitor element
TOTAL_LOAD_PROC_TIME BIGINT total_load_proc_time - Total load processing time monitor element
TOTAL_LOADS BIGINT total_loads - Total loads monitor element
CAT_CACHE_INSERTS BIGINT cat_cache_inserts - Catalog cache inserts monitor element
CAT_CACHE_LOOKUPS BIGINT cat_cache_lookups - Catalog cache lookups monitor element
PKG_CACHE_INSERTS BIGINT pkg_cache_inserts - Package cache inserts monitor element
PKG_CACHE_LOOKUPS BIGINT pkg_cache_lookups - Package cache lookups monitor element
THRESH_VIOLATIONS BIGINT thresh_violations - Number of threshold violations monitor element
NUM_LW_THRESH_EXCEEDED BIGINT num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
FCM_TQ_RECV_WAIT_TIME BIGINT fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
FCM_MESSAGE_RECV_WAIT_TIME BIGINT fcm_message_recv_wait_time - FCM message received wait time monitor element
FCM_TQ_SEND_WAIT_TIME BIGINT fcm_tq_send_wait_time - FCM table queue send wait time monitor element
FCM_MESSAGE_SEND_WAIT_TIME BIGINT fcm_message_send_wait_time - FCM message send wait time monitor element
AUDIT_FILE_WRITE_WAIT_TIME BIGINT audit_file_write_wait_time - Audit file write wait time monitor element
AUDIT_FILE_WRITES_TOTAL BIGINT audit_file_writes_total - Total audit files written monitor element
AUDIT_SUBSYSTEM_WAIT_TIME BIGINT audit_subsystem_wait_time - Audit subsystem wait time monitor element
AUDIT_SUBSYSTEM_WAITS_TOTAL BIGINT audit_subsystem_waits_total - Total audit subsystem waits monitor element
DIAGLOG_WRITE_WAIT_TIME BIGINT diaglog_write_wait_time - Diagnostic log file write wait time monitor element
DIAGLOG_WRITES_TOTAL BIGINT diaglog_writes_total - Total diagnostic log file writes monitor element
FCM_MESSAGE_SENDS_TOTAL BIGINT fcm_message_sends_total - Total FCM message sends monitor element
FCM_MESSAGE_RECVS_TOTAL BIGINT fcm_message_recvs_total - Total FCM message receives monitor element
FCM_MESSAGE_SEND_VOLUME BIGINT fcm_message_send_volume - FCM message send volume monitor element
FCM_MESSAGE_RECV_VOLUME BIGINT fcm_message_recv_volume - FCM message received volume monitor element
FCM_TQ_SENDS_TOTAL BIGINT fcm_tq_sends_total - FCM table queue send total monitor element
FCM_TQ_RECVS_TOTAL BIGINT fcm_tq_recvs_total - FCM table queue receives total monitor element
FCM_TQ_SEND_VOLUME BIGINT fcm_tq_send_volume - FCM table queue send volume monitor element
FCM_TQ_RECV_VOLUME BIGINT fcm_tq_recv_volume - FCM table queue received volume monitor element
TQ_TOT_SEND_SPILLS BIGINT tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
AUDIT_EVENTS_TOTAL BIGINT audit_events_total - Total audit events monitor element
TOTAL_ROUTINE_USER_CODE_PROC_TIME BIGINT total_routine_user_code_proc_time - Total routine user code processing time monitor element
TOTAL_ROUTINE_USER_CODE_TIME BIGINT total_routine_user_code_time - Total routine user code time monitor element
Parent topic: Monitoring unit of work events
Related concepts:
Interfaces that return monitor data in XML documents
Related reference:
Information written to XML for system_metrics and activity_metrics monitor elements
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics