Allocating Database Server Resources

You can specify an integer in the range from -1 to 100 to indicate a query priority level as the percent of database server resources to process the query. Resources include the amount of memory and the number of processors. The higher the number you specify, the more resources the database server uses.

Use of more resources usually indicates better performance for a given query. Using excessive resources, however, can cause contention for resources and remove resources from other queries, so that degraded performance results. With the resources option, the following values are numeric equivalents of the keywords that indicate query priority level.

Value

Equivalent Keyword-Priority Level

-1

DEFAULT

0

OFF (Dynamic Server only)

1

LOW

For Dynamic Server, the following statements are equivalent. The first statement uses the keyword LOW to establish a low query-priority level. The second uses a value of 1 in the resources parameter to establish a low query-priority level.

SET PDQPRIORITY LOW;

SET PDQPRIORITY 1;