DB2 10.5 for Linux, UNIX, and Windows

Enabling workload management dispatcher

To enable the DB2® workload management dispatcher, set the value of the wlm_dispatcher database manager configuration parameter to YES. The workload management dispatcher manages CPU resources allocated to DB2 user and maintenance service classes.

Procedure

To enable workload management dispatcher by using the command line processor (CLP):

Attach to your DB2 instance.
```
ATTACH TO instance-name
```
Issue the UPDATE DATABASE MANAGER CONFIGURATION (or UPDATE DBM CFG) command. Set the value of the wlm_dispatcher database manager configuration parameter to YES.
```
UPDATE DBM CFG USING wlm_dispatcher yes
```
Optional: Detach from your DB2 instance.
```
DETACH
```

Results

The workload management dispatcher is enabled. You can now specify CPU limit allocations of CPU resources to DB2 service classes.

What to do next

After having enabled the workload management dispatcher to manage CPU resources, you must consider completing the following tasks:

Create or alter a service class and configure the CPU limit by using the CREATE SERVICE CLASS or ALTER SERVICE CLASS statement. See: Setting a CPU limit.
Enable hard and soft CPU shares by configuring the wlm_disp_cpu_shares database manager configuration parameter. See step 1 in: Enabling and setting CPU shares.
Create or alter a service class and configure a hard or soft CPU share by using the CREATE SERVICE CLASS or ALTER SERVICE CLASS statement. See: Enabling and setting CPU shares.
Set the minimum CPU utilization percentage for workload management dispatcher to consider service classes to be active by configuring the wlm_disp_min_util database manager configuration parameter. See: Setting minimum CPU resource utilization for service class to be considered active.
Set the dispatch concurrency level by configuring the wlm_disp_concur database manager configuration parameter. See: Setting dispatch concurrency level.