Throughput - Workloads

Purpose

Show how much work is happening in each WLM workload.

One of the intended purposes of workloads in WLM is to split particular users or applications into separate categories for monitoring and reporting purposes. For example, you might create a workload where all Cognos reports will run so that you can track the impact of Cognos on your production database.

Histograms and Summaries (Gauges)

(none)

Metrics Shown

Workload Name

Source: mon_get_workload.workload_name

Eval Order

Source: syscat.workloads.evaluationorder

CPU Time

Source: mon_get_workload.total_cpu_time

Activities Completed / m

The number of activities completed per minute is one measure of how much work is being accomplished by connections associated with this workload. Activities typically correspond to a query, although there a few additional things that count as an activity including LOAD and stored procedures calls.

Source: mon_get_workload.act_completed_total

Activities Aborted / m

Source: mon_get_workload.act_aborted_total

Activities Rejected / m

Source: mon_get_workload.act_rejected_total

App Rqsts Completed / m

Source: mon_get_workload.app_rqsts_completed_total

Avg App Rqst Time (ms)

Activities Queued / m

Source: mon_get_workload.wlm_queue_assignments_total

Rows Read / m

Source: mon_get_workload.rows_read

Rows Modified / m

Source: mon_get_workload.rows_modified

Rows Returned / m

Source: mon_get_workload.rows_returned

Logical Reads / m

Source: mon_get_workload

pool_data_l_reads + pool_index_l_reads + pool_xda_l_reads + pool_col_l_reads +

pool_temp_data_l_reads + pool_temp_index_l_reads + pool_temp_xda_l_reads + pool_temp_col_l_reads

Direct Reads / m

Source: mon_get_workload.direct_reads

Direct Writes / m

Source: mon_get_workload.direct_writes

Lock Waits / m

Source: mon_get_workload.lock_waits

Lock Timeouts / m

Source: mon_get_workload.lock_timeouts

Lock Escal / m

Source: mon_get_workload.lock_escals

Deadlocks / m

Source: mon_get_workload.deadlocks

Threshold Violations / m

Source: mon_get_workload.thresh_violations

Sorts / m

Source: mon_get_workload.total_sorts

Sort Overflows / m

Source: mon_get_workload.sort_overflows

Hash Group By Ops / m

Source: mon_get_workload.total_hash_grpbys

Hash Group By Overflows / m

Source: mon_get_workload.hash_grpby_overflows

Application Commits / m

Source: mon_get_workload.total_app_commits

Commit Time

Source: mon_get_workload.total_commit_time

Default Sort Column

CPU Time, descending

Keyboard navigation: Vtw

Dedicated shortcut key: (none)

Author: KevinLBeck

Throughput - Workload Assignment