PARTITION_KEY |
INTEGER |
partition_key - Partitioning key monitor element |
ACTIVITY_ID |
BIGINT |
activity_id - Activity
ID |
ACTIVITY_SECONDARY_ID |
SMALLINT |
activity_secondary_id
- Activity secondary ID |
APPL_ID |
VARCHAR(64) |
appl_id - Application
ID |
PARTITION_NUMBER |
SMALLINT |
partition_number
- Partition number |
UOW_ID |
INTEGER |
uow_id - Unit of
work ID |
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 |
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 |
LOCK_WAIT_TIME |
BIGINT |
lock_wait_time -
Time waited on locks |
LOCK_WAITS |
BIGINT |
lock_waits - Lock
waits |
DIRECT_READ_TIME |
BIGINT |
direct_read_time
- Direct read time |
DIRECT_READ_REQS |
BIGINT |
direct_read_reqs
- Direct read requests |
DIRECT_WRITE_TIME |
BIGINT |
direct_write_time
- Direct write time |
DIRECT_WRITE_REQS |
BIGINT |
direct_write_reqs
- Direct write requests |
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 |
POOL_WRITE_TIME |
BIGINT |
pool_write_time -
Total buffer pool physical write time |
POOL_READ_TIME |
BIGINT |
pool_read_time -
Total buffer pool physical read 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_SEND_WAIT_TIME |
BIGINT |
fcm_send_wait_time
- FCM send wait time |
FCM_RECV_WAIT_TIME |
BIGINT |
fcm_recv_wait_time
- FCM received wait time |
TOTAL_ACT_WAIT_TIME |
BIGINT |
total_act_wait_time
- Total activity wait 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_SECTION_SORT_TIME |
BIGINT |
total_section_sort_time
- Total section sort time |
TOTAL_ACT_TIME |
BIGINT |
total_act_time -
Total activity time |
ROWS_READ |
BIGINT |
rows_read - Rows
read |
ROWS_MODIFIED |
BIGINT |
rows_modified - Rows
modified |
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_XDA_L_READS |
BIGINT |
pool_xda_l_reads
- Buffer pool XDA data logical reads |
POOL_TEMP_XDA_L_READS |
BIGINT |
pool_temp_xda_l_reads
- Buffer pool temporary XDA data logical reads |
TOTAL_CPU_TIME |
BIGINT |
total_cpu_time -
Total CPU time |
POOL_DATA_P_READS |
BIGINT |
pool_data_p_reads
- Buffer pool data physical reads |
POOL_TEMP_DATA_P_READS |
BIGINT |
pool_temp_data_p_reads
- Buffer pool temporary data physical reads |
POOL_XDA_P_READS |
BIGINT |
pool_xda_p_reads
- Buffer pool XDA data physical reads |
POOL_TEMP_XDA_P_READS |
BIGINT |
pool_temp_xda_p_reads
- Buffer pool temporary XDA data physical reads |
POOL_INDEX_P_READS |
BIGINT |
pool_index_p_reads
- Buffer pool index physical reads |
POOL_TEMP_INDEX_P_READS |
BIGINT |
pool_temp_index_p_reads
- Buffer pool temporary index physical reads |
POOL_DATA_WRITES |
BIGINT |
pool_data_writes
- Buffer pool data writes |
POOL_XDA_WRITES |
BIGINT |
pool_xda_writes -
Buffer pool XDA data writes |
POOL_INDEX_WRITES |
BIGINT |
pool_index_writes
- Buffer pool index writes |
DIRECT_READS |
BIGINT |
direct_reads - Direct
reads from database |
DIRECT_WRITES |
BIGINT |
direct_writes - Direct
writes to database |
ROWS_RETURNED |
BIGINT |
rows_returned - Rows
returned |
DEADLOCKS |
BIGINT |
deadlocks - Deadlocks
detected |
LOCK_TIMEOUTS |
BIGINT |
lock_timeouts - Number
of lock timeouts |
LOCK_ESCALS |
BIGINT |
lock_escals - Number
of lock escalations |
FCM_SENDS_TOTAL |
BIGINT |
fcm_sends_total -
FCM sends total |
FCM_RECVS_TOTAL |
BIGINT |
fcm_recvs_total -
FCM receives total |
FCM_SEND_VOLUME |
BIGINT |
fcm_send_volume -
FCM send volume |
FCM_RECV_VOLUME |
BIGINT |
fcm_recv_volume -
FCM received volume |
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 |
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 |
AUDIT_EVENTS_TOTAL |
BIGINT |
audit_events_total
- Total audit events |
TOTAL_SORTS |
BIGINT |
total_sorts - Total
sorts |
STMT_EXEC_TIME |
BIGINT |
stmt_exec_time -
Statement execution time |
COORD_STMT_EXEC_TIME |
BIGINT |
coord_stmt_exec_time
- Execution time for statement by coordinator agent |
TOTAL_ROUTINE_NON_SECT_PROC_TIME |
BIGINT |
total_routine_non_sect_proc_time
- Non-section processing time |
TOTAL_ROUTINE_NON_SECT_TIME |
BIGINT |
total_routine_non_sect_time
- Non-section routine execution 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_SECTION_TIME |
BIGINT |
total_section_time
- Total section time |
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 |
TOTAL_ROUTINE_TIME |
BIGINT |
total_routine_time
- Total routine time |
THRESH_VIOLATIONS |
BIGINT |
thresh_violations
- Number of threshold violations |
NUM_LW_THRESH_EXCEEDED |
BIGINT |
num_lw_thresh_exceeded
- Number of lock wait thresholds exceeded |
TOTAL_ROUTINE_INVOCATIONS |
BIGINT |
total_routine_invocations
- Total routine invocations |
LOCK_WAIT_TIME_GLOBAL |
BIGINT |
lock_wait_time_global
- Lock wait time global |
LOCK_WAITS_GLOBAL |
BIGINT |
lock_waits_global
- Lock waits global |
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 |
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 |
CF_WAIT_TIME |
BIGINT |
cf_wait_time - cluster
caching facility wait time |
CF_WAITS |
BIGINT |
cf_waits - Number
of cluster caching facility DB2 pureScale
server waits |
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_DISP_RUN_QUEUE_TIME |
BIGINT |
total_disp_run_queue_time
- Total dispatcher run queue time |
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 |
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 |
PREFETCH_WAIT_TIME |
BIGINT |
prefetch_wait_time
- Time waited for prefetch |
PREFETCH_WAITS |
BIGINT |
prefetch_waits -
Prefetcher wait count |
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 |
POST_THRESHOLD_COL_VECTOR_CONSUMERS |
BIGINT |
post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element |
TOTAL_COL_VECTOR_CONSUMERS |
BIGINT |
total_col_vector_consumers - Total columnar vector memory consumers monitor element |
TOTAL_INDEXES_BUILT |
BIGINT |
total_indexes_built - Total number of indexes built monitor element |
TOTAL_INDEX_BUILD_PROC_TIME |
BIGINT |
total_index_build_proc_time - Total non-wait time spent building indexes due to index creation or re-creation monitor element |
TOTAL_INDEX_BUILD_TIME |
BIGINT |
total_index_build_time - Total time spent building indexes due to index creation or re-creation monitor element |