Workload management dispatcher behavior in multimember environments
When the workload management dispatcher is enabled on multimember Db2® instances, CPU resource scheduling operates across all of the members on a given host. Note that the workload management dispatcher also supports shared LPAR (micropartition) environments on AIX®.
Multimember database environments
On multimember Db2 instances, the
dispatcher behaves in the following ways:
- The value of the wlm_disp_concur database manager configuration parameter applies to each host or LPAR. In multimember databases, the dispatch concurrency level specified by the wlm_disp_concur configuration parameter is applied across all of the members.
- For multimember databases, CPU limits are enforced on a per host or LPAR basis - when multiple members are used, each partition is allowed to use all of a specified CPU limit as long as the sum across all members is less than or equal to the CPU limit. If the CPU limit on the single service class A is 35% and there are 2 members, then member 1 can use up to 35% if the sum of the CPU utilization across member 1 and 2 does not exceed 35%.
Micropartition (shared LPAR) environments
The workload management dispatcher supports micropartition environments in AIX. In micropartition environments, the percentage CPU utilization for both
controls and monitoring in the workload management dispatcher is computed relative to the CPU
resources allocated to the LPAR by the operating system or hypervisor over the most recent
dispatcher CPU resource scheduling cycle, using the entitled (guaranteed) CPU resources for the LPAR
as a baseline level. In cases when the CPU resource allocated to the LPAR is greater than the
entitled CPU resources, the dispatcher computes the CPU utilization relative to the greater amount,
and when the CPU resource allocation is less than the entitled CPU resources, the dispatcher
computes the CPU utilization relative to the entitled CPU resources.
Note: The workload management
dispatcher behavior is consistent with the way AIX WLM
performs its calculations. For dedicated LPARs on AIX, and for
all non-AIX environments, the CPU utilization is calculated relative to the full CPU capacity of the
physical cores available to the Db2 database
manager.