DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
This parameter specifies the minimum amount of CPU utilization that is necessary for a service class to be included in the DB2® WLM-managed sharing of CPU resources.
When upgrading DB2 database manager, the value of the wlm_disp_min_util database manager configuration parameter is 5.
To illustrate the usage of this database manager configuration parameter with an example, suppose there are three service classes, A, B, and C, and each has 1000 shares of the CPU resources. In this example, the same result is obtained whether the service class shares are hard or soft CPU shares. Service classes A and B each have a CPU utilization that is greater than or equal to the 8% value set for the wlm_disp_min_util configuration parameter. Service class C has a 3% CPU utilization that is less than the 8% value set for the wlm_disp_min_util configuration parameter. In CPU share calculations, service class C is considered to not have any executing work. Therefore, only service classes A and B equally share the CPU resources and each receives a 50% share. When service class C begins to execute work to an extent that the CPU utilization is greater than or equal to the 8% value set for the wlm_disp_min_util configuration parameter, at this point service classes A, B, and C are now considered to equally share the CPU resources and each receives a 33.3% share.
In multimember database environments, it is the aggregate of the CPU utilizations of all the members on a host or LPAR that is compared to the wlm_disp_min_util configuration parameter to determine if the host or LPAR is included in the WLM-managed sharing of CPU resources.