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:
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.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]