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
1- LOW
For HCL
OneDB™,
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;