DB2 Version 10.1 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.

When the wlm_dispatcher configuration parameter is set to YES, the following conditions apply:

If any service class has an agent priority set to any value other than the default, a warning message is written to the db2diag log and the administration notification log at the time of database activation.
Any attempt to create or alter a service class to set agent priority to a value other than the default value results in a warning being returned to the application that issued the statement to create or alter the service class.