DB2 10.5 for Linux, UNIX, and Windows

Setting minimum CPU resource utilization for service class to be considered active

Set the minimum CPU utilization for a service class by setting the value of the wlm_disp_min_util database manager configuration parameter to a percentage. Service classes utilizing CPU resources equal to or greater than that percentage are considered active on the host or logical partition (LPAR) and the CPU shares of the active service classes are factored into CPU allocation calculations.

Procedure

To set the minimum CPU utilization percentage for service classes to be considered active:

Using the command line processor (CLP), issue the UPDATE DATABASE MANAGER CONFIGURATION (or UPDATE DBM CFG) command and set the value of the wlm_disp_min_util database manager configuration parameter to 6%; the parameter value is updated immediately by first attaching to your DB2® instance:

attach to instance-name
update dbm cfg using wlm_disp_min_util 6
detach

Results

The minimum CPU utilization percentage for service classes to be considered active has been set. Service classes that have a CPU utilization percentage that is less than this minimum are considered to be idle and their CPU allocations can then be proportionally reallocated to service classes that can claim spare CPU resources.

What to do next

After having set the minimum CPU utilization percentage for service classes to be considered active by the workload management dispatcher, consider completing the following tasks:

For the minimum CPU utilization setting to be effective, you must enable the workload management dispatcher by configuring the wlm_dispatcher database manager configuration parameter. See: Enabling workload management dispatcher.
Set the dispatch concurrency level by configuring the wlm_disp_concur database manager configuration parameter. See: Setting dispatch concurrency level.
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.