DS_NONPDQ_QUERY_MEM

onconfig.std

128

units

Kilobytes

range of values

From 128 Kilobytes to 25 percent of the value of DS_TOTAL_MEMORY

takes effect

When the database server is initialized

utilities

onstat -g mgm (See The onstat -g mgm Option.)
onmode
ON-Monitor

Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of memory that is a available for a query that is not a Parallel Database Query (PDQ). (You can only use this parameter if PDQ priority is set to zero.) If you specify a value for the DS_NONPDQ_QUERY_MEM parameter, determine and adjust the value based on the number and size of table rows.

The DS_NONPDQ_QUERY_MEM value is calculated during database server initialization based on the calculated DS_TOTAL_MEMORY value. If during the processing of the DS_NONPDQ_QUERY_MEM, the database server changes the value that you set, the server sends a message in this format:

DS_NONPDQ_QUERY_MEM recalculated and changed from old_value Kb to new_value Kb.

In the message, old_value represents the value that you assigned to DS_NONPDQ_QUERY_MEM in the user configuration file, and new_value represents the value determined by the database server.

The value for DS_NONPDQ_QUERY_MEM can be changed using the onmode -wf option or superseded for a session with the onmode -wm option. For more information about onmode, see Dynamically Change Certain Connection, PDQ, and Memory Parameters.