wlm_dispatcher - Workload management dispatcher configuration parameter

This parameter enables (YES) or disables (NO) the Db2® workload management dispatcher. By default, an enabled dispatcher allows the setting of the CPU limits.

Configuration type
Database manager
Applies to
  • Database server with local and remote clients
  • Database server with local clients
  • Partitioned database server with local and remote clients
Parameter type
Configurable Online
Propagation class
Default [range]

When upgrading the Db2 database manager, the value of the wlm_dispatcher database manager configuration parameter is set to NO.

The workload management dispatcher provides CPU scheduling capabilities at the service class level in the Db2 database manager using shares-based allocation of CPU resources, or CPU limits, or both.

With the workload management dispatcher enabled, all work running in user and maintenance service classes is placed under the control of the dispatcher. When enabled, CPU limit settings are enforced by the dispatcher as the default case. In order to use shares-based allocation of CPU resources, the wlm_disp_cpu_shares database manager configuration parameter must be enabled.