onmode and D arguments: Set PDQ priority (SQL administration API)

Use the onmode and D arguments with the admin() or task() function to temporarily reset the PDQ resources that the database server can allocate to any one decision-support query.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--"onmode"-- , -"D"--,--"max_priority"--)--;------------------><

Element Description Key Considerations
max_priority The percentage of the user-requested PDQ resources actually allocated to the query. The value must be an unsigned integer from 0 to 100.

Usage

Use this function to override the limit set by the MAX_PDQPRIORITY 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 reverts to the values in the onconfig file.

This function is equivalent to the onmode -D command.

Example

The following example sets the percentage of PDQ resources that can be allocated to a query to 50 percent:
EXECUTE FUNCTION task("onmode","D","50");

Copyright© 2019 HCL Technologies Limited