More Memory for Queries with Hash Joins, Aggregates, and Other Memory-Intensive Elements

If you want to increase the amount of memory that is available for a query that is not a PDQ query and the PDQ priority is set to 0 (zero), you can change the amount using any of the following options:

• The DS_NONPDQ_QUERY_MEM configuration parameter
• The onmode -wm or onmode -wf commands
• The Non PDQ Query Memory option on the ON-Monitor pdQ menu

For example, if you use the onmode utility, specify a value as shown in the following example:

onmode -wf DS_NONPDQ_QUERY_MEM=500

The minimum value for DS_NONPDQ_QUERY_MEM is 128 kilobytes. The maximum supported value is 25 percent of DS_TOTAL_MEMORY. 128 kilobytes is the default value of DS_NONPDQ_QUERY_MEM. 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 involved in the query.

DS_NONPDQ_QUERY_MEM is calculated during database server initialization based on the calculated DS_TOTAL_MEMORY value.

If during the processing of the DS_NONPDQ_QUERY_MEM configuration parameter, 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.