Repository View THROUGHPUT_ALL

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

row_id

n

char(5)

This column always contains the string “(all)”

total_cpu_usec

Y

bigint

Microseconds of CPU time consumed by the data server.  Divide by 1,000,000 to scale this as seconds.

CPU consumption is a good indication of how much work is being done.  All activities, including overhead such as compiling queries and utility work are reflected in CPU consumption.  Inefficiencies that increase the cost of doing business, such as excessive recompilation or lock contention can sometimes be seen by observing that CPU consumption has risen disproportionately to the amount of useful work that is being accomplished.

act_completed_total

Y

bigint

Activities completed by the data server.

Activities typically correspond to a query.

The number of activities completed is a measure of work accomplished.

rows_read

Y

bigint

Rows read is a good indication of how much work is being done by queries.  Non-query work such as utilities and overhead for internal activities of the data server is largely excluded from rows read.  So it is a better measure than CPU time for evaluating how much useful work is being accomplished.

rows_modified

Y

bigint

Rows modified includes updates and deletes of table data.  Modifying data is much more expensive than reading it.

rows_returned

Y

bigint

This is the number of rows returned to the client by queries.  Excessive amounts of data returned to the client can indicate a run-away query (cross product, missing filters) or abuse (people in the process of making unauthorized copies of the data) or even bad practices such as mis-guided attempts to pull large portions of the data into a spreadsheet or an application for post processing that could be better done inside the server.

logical_reads

Y

bigint

direct_reads

Y

bigint

direct_writes

Y

bigint

total_sorts

Y

bigint

total_app_commits

Y

bigint

total_commit_time

Y

bigint

total_app_rollbacks

Y

bigint

total_section_time

Y

bigint

total_routine_time

Y

bigint

pool_read_time

Y

bigint

msec

pool_write_time

Y

bigint

msec

direct_read_time

Y

bigint

msec

direct_write_time

Y

bigint

msec

total_section_sort_time

Y

bigint

wlm_queue_time_total

Y

bigint

lock_wait_time

Y

bigint

log_buffer_wait_time

Y

bigint

log_disk_wait_time

Y

bigint

total_compile_proc_time

Y

bigint

total_implicit_compile_proc_time

Y

bigint

lock_waits

Y

bigint

lock_timeouts

Y

bigint

lock_escals

Y

bigint

deadlocks

Y

bigint

agent_wait_time

Y

bigint

lock_wait_time_global

Y

bigint

tcpip_wait_time

Y

bigint

ipc_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

total_extended_latch_wait_time

Y

bigint

total extended latch wait time

prefetch_wait_time

Y

bigint

comm_exit_wait_time

Y

bigint

ida_wait_time

Y

bigint

cf_wait_time

Y

bigint

reclaim_wait_time

Y

bigint

spcmapg_reclaim_wait_time

Y

bigint

spacemappage_reclaim_wait_time

total_rtn_u_code_proc_time

Y

bigint

total_rountine_user_code_proc_time

total_section_proc_time

Y

bigint

total_sect_sort_proc_time

Y

bigint

total_section_sort_proc_time

total_col_proc_time

Y

bigint

total_commit_proc_time

Y

bigint

total_rollback_proc_time

Y

bigint

total_runstats_proc_time

Y

bigint

total_reorg_proc_time

Y

bigint

total_load_proc_time

Y

bigint

total_backup_proc_time

Y

bigint

total_idx_build_proc_time

Y

bigint

total_index_build_proc_time

total_con_req_prc_time

Y

bigint

total_connect_request_proc_time

total_con_auth_prc_time

Y

bigint

total_connect_authentication_proc_time

client_idle_wait_time

Y

bigint

total_rqst_time

Y

bigint

total_wait_time

Y

bigint

sum_sql_execution_time

Y

bigint

sum_nonsql_proc_time

Y

bigint

sum_io_time

Y

bigint

local_lock_wait_time

Y

bigint

other_wait_time

Y

bigint

total_act_time

    Y

bigint

The total amount of time spent executing activities. Unit: msec

act_aborted_total

    Y

bigint

The total number of coordinator activities at any nesting level that completed with errors

total_compilations

    Y

bigint

sort_overflows

    Y

bigint

physical_reads

    Y

bigint

fed_wait_time

    Y

bigint

federation only, supported from DB2 V11.1

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

fed_waits_total

    Y

bigint

federation only, supported from DB2 V11.1