DS_MAX_QUERIES

onconfig.std
value

None

if not present

DS_TOTAL_MEMORY / NUMCPUVPS * 4 * 128

units

Number of queries

range of values

Minimum = 1

Maximum = 8 million

utilities

onutil

refer to

Your IBM Informix: Performance Guide

In Extended Parallel Server, DS_MAX_QUERIES is the maximum number of memory-consuming queries that can run concurrently. A memory-consuming query is defined as a query with PDQ priority set to a high value. The Resource Grant Manager (RGM) enforces this limit.

The value of PDQPRIORITY is specified by the PDQPRIORITY configuration parameter, the PDQPRIORITY environment variable, or the SQL statement SET PDQPRIORITY.

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

% onutil
1> SET DS_MAX_QUERIES 100;