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

Read syntax diagramSkip visual syntax diagram
>>-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 Informix® 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");

Copyright© 2019 HCL Technologies Limited