Change Decision- Support Parameters:
|--+- -D--max_priority-+----------------------------------------|
+- -M--kilobytes----+
'- -Q--queries------'
| Element | Purpose | Key Considerations |
|---|---|---|
| -D max_priority | Changes the value of MAX_PDQPRIORITY. | Restrictions: This value
must be an unsigned integer between 0 and 100.
Additional Information: Specify max_priority as a factor to temper user requests for PDQ resources. References: For information on parameters used for controlling PDQ in Dynamic Server, see the chapter on table fragmentation and PDQ in the IBM Informix: Administrator's Guide, MAX_PDQPRIORITY and the IBM Informix: Performance Guide. |
| -M kilobytes | Changes the value of DS_TOTAL_MEMORY. | Restrictions: This value
must be an unsigned integer between 128 * DS_MAX_QUERIES and 1,048,576.
Additional Information: Specify kilobytes for the maximum amount of memory available for parallel queries. References: For more information, see DS_TOTAL_MEMORY and the IBM Informix: Performance Guide. |
| -Q queries | Changes the value of DS_MAX_QUERIES. | Restrictions: This value
must be an unsigned integer between 1 and 8,388,608.
Additional Information: Specify queries for the maximum number of concurrently executing parallel queries. |
These options allow you to change configuration parameters while the database server is online. The new values affect only the current instance of the database server; the values are not recorded in the ONCONFIG file. If you reinitialize shared memory, the values of the parameters revert to the values in the ONCONFIG file. For more information about these configuration parameters, see Configuration Parameters.
IBM recommends using the onutil SET command to change these parameters, instead of onmode. Please see SET for more information on this onutil command.
To check the current values for the MAX_PDQPRIORITY, DS_TOTAL_MEMORY, and DS_MAX_QUERIES configuration parameters, use onstat -g rgm.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]