IBM Support

Repository View THROUGHPUT_ALL_WL

Question & Answer


Question

Repository View THROUGHPUT_ALL_WL

Answer

Usage

 

Source

 

Columns

As with all repository views, the columns marked Y in the “Delta” column are actually two columns.  For example, the metric described here as “rows_read” is actually a pair of columns “rows_read” which is a counter of how many rows have been read by activities since the data server was activated and “rows_read_delta”, which tells how many rows have been read by activities in the collection interval.  For most purposes, the _delta version of the metrics is the most useful.  The raw counter version is provided for completeness.

Column Name

Delta

Type

Description

dbconn_int

n

integer

 

dbconn_id

n

varchar(255)

 

prev_collected

n

timestamp

 

collected

n

timestamp

 

delta_msec

n

bigint

 

workload_id

n

integer

 

workload_name

n

varchar(128)

 

total_cpu_time_wl

Y

bigint

 

cpu_user

Y

bigint

 

cpu_system

Y

bigint

 

cpu_iowait

Y

bigint

 

cpu_idle

Y

bigint

 

logical_reads

Y

bigint

 

total_act_time

Y

bigint

 

act_aborted_total

Y

bigint

 

act_completed_total

Y

bigint

 

total_app_commits

Y

bigint

 

total_sorts

Y

bigint

 

total_compilations

Y

bigint

 

deadlocks

Y

bigint

 

sort_overflows

Y

bigint

 

total_section_proc_time

Y

bigint

 

totl_rtn_u_code_prc_time

Y

bigint

 

totl_sect_sort_proc_time

Y

bigint

 

lock_wait_time

Y

bigint

 

cf_wait_time

Y

bigint

 

pool_read_time

Y

bigint

 

pool_write_time

Y

bigint

 

direct_read_time

Y

bigint

 

direct_write_time

Y

bigint

 

total_compile_proc_time

Y

bigint

 

totl_implc_cmpl_prc_time

Y

bigint

 

total_load_proc_time

Y

bigint

 

total_reorg_proc_time

Y

bigint

 

total_runstats_proc_time

Y

bigint

 

total_commit_proc_time

Y

bigint

 

total_rollback_proc_time

Y

bigint

 

totl_con_req_prc_time

Y

bigint

 

agent_wait_time

Y

bigint

 

wlm_queue_time

Y

bigint

 

log_buffer_wait_time

Y

bigint

 

log_disk_wait_time

Y

bigint

 

tcpip_wait_time

Y

bigint

 

ipc_wait_time

Y

bigint

 

ida_wait_time

Y

bigint

 

audit_subsystem_wait_time

Y

bigint

 

audit_file_wrt_wait_time

Y

bigint

 

diaglog_write_wait_time

Y

bigint

 

evmon_wait_time

Y

bigint

 

totl_ext_latch_wait_time

Y

bigint

 

prefetch_wait_time

Y

bigint

 

comm_exit_wait_time

Y

bigint

 

reclaim_wait_time

Y

bigint

 

spcmapg_reclm_wait_time

Y

bigint

 

fed_wait_time

Y

bigint

federation only, supported from DB2 V11.1

lock_wait_time_global

Y

bigint

 

total_backup_proc_time

Y

bigint

 

totl_idx_build_proc_time

Y

bigint

 

direct_reads

Y

bigint

 

lock_escals

Y

bigint

 

lock_waits

Y

bigint

 

fed_waits_total

Y

bigint

federation only, supported from DB2 V11.1

physical_reads

Y

bigint

 

rows_modified

Y

bigint

 

rows_read

Y

bigint

 

fed_rows_deleted

Y

bigint

federation only, supported from DB2 V11.1

fed_rows_inserted

Y

bigint

federation only, supported from DB2 V11.1

fed_rows_updated

Y

bigint

federation only, supported from DB2 V11.1

fed_rows_read

Y

bigint

federation only, supported from DB2 V11.1

 

Example --

[{"Product":{"code":"SS5Q8A","label":"IBM Data Server Manager"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"}],"Version":"2.1.3;2.1.2;2.1.1;2.1;2.1.4;2.1.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
31 December 2019

UID

ibm11166458

Page Feedback