Resource minimums and maximums

For each resource group, you specify parameters that determine which fraction of the net system resources are used to process the plans associated with that resource group:

resource minimum: This determines the smallest fraction of net system resources that are to be made available to the group. The value can be from 0-100, but a group is considered to be a resource group only if a nonzero value is specified. A resource group for which at least one job is pending is said to be active.
Tip: Although the resource minimum is a number from 0-100, it is not a percentage; it is a number of shares that is used to determine a proportion. For example, if the sum of the resource minimums of all active resource groups is 120, and if one resource group has a resource minimum of 40, that resource group is entitled to a minimum of 40/120 or 33% of net system resources. When you use the CREATE GROUP and ALTER GROUP nzsql commands, there is no limit to the total number of resource minimum shares you can allot.
resource maximum: This specifies the largest percentage of net system resources that the resource group is to receive, regardless of how many other resource groups are using the system. The value can be from 1-100 and can be configured only for a resource group. The default is 100. A resource group with a resource maximum of 100 is said to be unlimited.
Tip: The resource maximum is a percentage. For example, if the resource maximum of a resource group is set to 70 and its resource minimum is set to 40, and if the sum of the resource minimums of all active resource groups is 50, even though the resource group is entitled to 40/50 or 80% of net system resources, it would receive only 70%.

Note: A group can be one or both of the following types:

User group: A group with one or more members is a user group. Each member of a user group inherits its privileges and other settings, with the exception of its resource minimum, resource maximum, and job maximum settings. User groups are used to simplify access management.
Resource group: A group that specifies a nonzero minimum resource percentage is a resource group. Each resource group also specifies a resource maximum and job maximum, either explicitly or by default. These three settings are called the group's resource settings. Each user is assigned to exactly one resource group. Resource groups are used for workload management.

A group can be both a user group and a resource group, but its user group and resource group aspects, including user group membership and the assignment of users to a resource group, are completely separate:

A user might be assigned to a resource group but not be a member of that group. That user is unaffected by any privileges or settings of that group, except for the resource settings.
A user might be a member of a user group but be assigned to a different resource group. That user is unaffected by the user group's resource settings.

The resource percentage of a resource group is the percentage of the net system resources that are made available to that resource group, and is determined by the resource group's resource minimum and maximum. The system applies the resource minimum and maximum of each resource group in such a way that the resource group receives its apportioned share of net system resources.

A resource minimum applies only when the corresponding resource group has a job pending. When a resource group is idle, its system resources can be used by other, active resource groups. An active resource group might receive more than its resource minimum when other resource groups are idle; however, a resource group cannot receive more than its configured resource maximum.

The system applies the following rules in the order shown to determine how to assign system resources to the active resource groups:

Table 1. Assign resources to active resource groups
Condition	Resource allocation rule
The sum of the RESOURCE MAXIMUM settings for all active resource groups is <= 100.	The system allocates resources based on the RESOURCE MAXIMUM settings.
The sum of the RESOURCE MINIMUM settings for all active resource groups is <=100.	The system allocates resources in proportion to the RESOURCE MINIMUM settings for each resource group, but the allocations are limited by the RESOURCE MAXIMUM settings. Any excess resources are allocated in proportion to the difference between the allowed resources and the RESOURCE MAXIMUM settings.
The sum of the RESOURCE MINIMUM settings for all active resource groups is > 100.	The system allocates resources in proportion to the normalized RESOURCE MINIMUM settings for each resource group.