onmode and Q arguments: Set maximum number for decision-support queries (SQL administration API)
Use the onmode and Q arguments with the admin() or task() function to change the maximum number of concurrently executing decision-support queries.
Syntax
EXECUTE FUNCTION
{
admin
| task
}
( "onmode"
,"Q","queries"
);
| Element | Description | Key Considerations |
|---|---|---|
| queries | The maximum number of concurrently executing parallel queries. | The number must be an unsigned integer from 1 to 8,388,608. |
Usage
Use this function to override the limit set by the DS_MAX_QUERIES configuration parameter 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 parameter revert to the values in the ONCONFIG file.
For information on parameters used for controlling PDQ, see the HCL OneDB™ Performance Guide.
This function is equivalent to the onmode -Q command.
Example
The following example sets the maximum number of concurrently executing parallel queries to 8:EXECUTE FUNCTION task("onmode","Q","8");