>>-SET SCHEDULE LEVEL--level-----------------------------------><
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| level | Integer value that specifies the scheduling priority of a query | Must be between 1 and 100. If the value falls outside the range of 1 and 100, the database server uses the default value of 50. | Literal Number,
p. Literal Number |
The highest priority level is 100. That is, a query at level 100 is more important than a query at level 1. In general, the Resource Grant Manager (RGM) processes a query with a higher scheduling level before a query with a lower scheduling level. The exact behavior of the RGM is also influenced by the setting of the DS_ADM_POLICY configuration parameter.
Related statement: SET PDQPRIORITY
For information about the Resource Grant Manager, see your IBM Informix Administrator's Guide.
For information about the DS_ADM_POLICY configuration parameter, see your IBM Informix Administrator's Reference.