Monitoring enhancements
Db2 11.5.6 provides you with more comprehensive monitoring of your Db2 database environments, and a higher granularity of control.
Attention: This mod pack release is currently available for the following Db2 products:
- Db2 on-premises
- The single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS)
- The container micro-service deployment of Db2 on Red Hat OpenShift
| Enhancement | Description |
| New monitoring elements to report peak estimated and actual shared sort memory consumption by any activity in a service class or workload. | The new act_estimated_sort_shrheap_top and act_sort_shrheap_top monitor elements report the peak estimated and actual activity shared sort memory usage across all activities executing in a service class or workload. These elements are reported by the statistics event monitor and by WLM statistics table functions. Use these elements to understand which workloads or service classes have queries executing with high individual memory requirements. Queries with high memory requirements will impact the concurrency allowed by the adaptive workload manager. |