Change Decision- Support Parameters:
|--+- -D--max_priority-+----------------------------------------|
+- -M--kilobytes----+
+- -Q--queries------+
'- -S--scans--------'
| 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, see MAX_PDQPRIORITYand the IBM Informix Performance Guide. |
| -M kilobytes | Changes the value of DS_TOTAL_MEMORY | Restrictions: This value has a platform-dependent upper limit.
The value for 32-bit systems must be an unsigned integer between 128
* DS_MAX_QUERIES and 1,048,576. On 64-bit systems, the limit is generally
higher and varies with the operating system. On HP 9000 platforms, for example,
the maximum value is 4,294,967,296.
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. References: For information on parameters used for controlling PDQ, see DS_MAX_QUERIESand the IBM Informix Performance Guide. |
| -S scans | Changes the value of DS_MAX_SCANS | Restrictions: This value must be
an unsigned integer between 10 and 1,048,576.
Additional Information: Specify scans for the maximum number of concurrently executing parallel scans. References: For information on parameters used for controlling PDQ, see DS_MAX_SCANSand the IBM Informix Performance Guide. |
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 shut down and restart the database server, the values of the parameters revert to the values in the ONCONFIG file. For more information about these configuration parameters, see Configuration Parameters.
To check the current values for the MAX_PDQPRIORITY, DS_TOTAL_MEMORY, DS_MAX_SCANS, DS_MAX_QUERIES, and the DS_NONPDQ_QUERY_MEM configuration parameters, use onstat -g mgm. See The onstat -g mgm Option.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]