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.