DS_ADM_POLICY

onconfig.std
value

FAIR

if not present

FAIR

range of values

STRICT or FAIR

utilities

onutil

refer to

Your IBM Informix: Performance Guide

The DS_ADM_POLICY parameter specifies how the Resource Grant Manager (RGM) should schedule queries.

If DS_ADM_POLICY is set to STRICT, the RGM processes queries in the order determined by the SET SCHEDULE LEVEL setting specified in the query and the order in which queries are submitted. The RGM processes the oldest query with the highest scheduling level before other queries, which means that a more recent query with a lower scheduling level might never run.

If DS_ADM_POLICY is set to FAIR, the RGM takes scheduling level, PDQ priority, and wait time into account when it decides which query to process. In general, the query with the highest scheduling level runs first, but a query with a lower scheduling level can run if it has been waiting for a long time.

To modify the DS_ADM_POLICY parameter dynamically, use the onutil SET command. Example:

% onutil
1> SET DS_ADM_POLICY "STRICT";