DB2 10.5 for Linux, UNIX, and Windows

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

Immediate

Default [range]

NO [NO; YES]

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.