SQL
Define the “SQL” work queue manager category.
Synopsis
[WorkQueues] SQL=MaxActiveWorkers,DefaultWorkers,MaxWorkers
SQL is the name of this work queue manager category. MaxActiveWorkers, DefaultWorkers, and MaxWorkers are three comma-separated integers. Any of these may be left blank or specified as 0 to use the default value. If using default values for MaxActiveWorkers and MaxWorkers, the only hard limit on the parameters is the number of MaxActiveWorkers in the work queue manager category. Specifying a value of -1 for MaxActiveWorkers allows for an unlimited number of active workers in the work queue manager category.
Description
The [WorkQueues] section of the configuration parameter file (CPF) contains an entry for every work queue manager category. A category has up to three comma-separated properties. None of the arguments are required; if any are left blank, they are resolved as the default value. For more information, see Managing CategoriesOpens in a new tab.
Changing This Parameter
On the Work Queue Manager Categories page of the Management Portal (System Administration > Configuration > System Configuration > WQM Categories), click SQL to edit this category. you can instead click Create Category to create a new WQM category.
Instead of using the Management Portal, you can change the SQL category in the Config.WorkQueuesOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).
See Also
