New monitor elements report thread and memory usage for workload and service class objects

A set of new monitor elements are introduced to report thread (parallelism) and memory usage for WLM WORKLOAD and SERVICE CLASS objects.

The following monitor elements have been added to the MON_GET_WORKLOAD, MON_GET_SERVICE_SUPERCLASS and MON_GET_SERVICE_SUBCLASS table functions. These new monitor elements show the total effective and actual query degree for all currently executing activities, and the current shared sort memory usage expressed as a percentage of sheapthres_shr:

• EFF_PARALLELISM
• ACTUAL_PARALLELISM
• SORT_SHRHEAP_UTILIZATION

The following monitor elements have been added to the MON_GET_WORKLOAD_STATS, MON_GET_SERVICE_SUPERCLASS_STATS and MON_GET_SERVICE_SUBCLASS_STATS table functions. These new monitor elements show the average effective, peak effective, and actual query degree for all currently executing activities, and the average and peak shared sort memory usage expressed as a percentage of sheapthres_shr:

• EFF_PARALLELISM_TOP
• EFF_PARALLELISM_AVG
• ACTUAL_PARALLELISM_TOP
• ACTUAL_PARALLELISM_AVG
• SORT_SHRHEAP_UTILIZATION_TOP
• SORT_SHRHEAP_UTILIZATION_AVG

Use these elements to understand the point in time, average and peak threading, and shared sort demands for different workloads and service classes.