DS_MAX_QUERIES

onconfig.std value

On UNIX: None
On Windows: 32

if not present

num_cpu_vps * 2 * 128

units

Number of queries

range of values

Minimum = 1
Maximum = 8,388,608 (8 megabytes)

utilities

onmode -Q (See page Change Decision-Support Parameters.)
onstat -g mgm (See The onstat -g mgm Option.)

refer to

The following material:

• Specifying the Number of CPU VPs
• Parallel database query in your IBM Informix Performance Guide

DS_MAX_QUERIES is the maximum number of PDQ queries that can run concurrently. The Memory Grant Manager (MGM) reserves memory for a query based on the following formula:

memory_reserved = DS_TOTAL_MEMORY *
                    (PDQ-priority / 100) *
                 (MAX_PDQPRIORITY / 100)

The value of PDQPRIORITY is specified in either the PDQPRIORITY environment variable or the SQL statement SET PDQPRIORITY.