Workload manager enhancements
Db2® 11.5.2 extends the workload management capabilities provided in previous releases.
Attention: The enhancements in this topic are included in the
Db2 11.5.2 mod pack release, which is available only for single container deployments of Db2 Warehouse
and IBM Integrated
Analytics System (IIAS).
| Enhancement | Description |
|---|---|
| New shared sort memory utilization (SORTSHRHEAPUTIL) threshold | A new shared sort memory utilization (SORTSHRHEAPUTIL) threshold lets you specify the maximum amount of shared sort memory that can be requested by a query. See SORTSHRHEAPUTIL for more information. |
| New session priority parameter | A new session priority parameter lets you specify whether the priority of requests is CRITICAL, HIGH, MEDIUM, or LOW. |