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 sets the maximum number of active workers in the work queue manager category to an arbitrarily large number equal to the number of CPU cores multiplied by fifty.
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 the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).