Skip to main content

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 Categories.

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

FeedbackOpens in a new tab