Group Adaptive Server engines into thread pools.
Prerequisites
The kernel mode must be set to threaded to create a thread pool. You can change the kernel mode on the Server Configuration screen, or by executing the SQL command
sp_configure at the server level from the Administration Console.
sp_configure "kernel mode", 0, threaded
You must restart Adaptive Server for the change to take affect.
Task
Thread pools are groups of resources, such as engines, that execute user tasks, run specific jobs such as signal handling, and process requests from a work queue. Adaptive Server supports both system-defined and user-defined thread pools.
Note: Thread pools can only be configured in Adaptive Server 15.7 and later.
- In the left pane of the Administration Console, expand , then select Thread Pools.
- Select New.
You see the Add Thread Pools wizard.
- Select an Adaptive Server that is configured to run in threaded mode.
- (Optional) For a cluster environment, click Create this as local thread pool, then select the cluster instance on which the thread pool will be created.
- Specify the name of the thread pool you want to create.
Note: You cannot name thread pools starting with a syb_ prefix since that is reserved for system thread pools.
- Specify the number of threads. The maximum number of threads you can configure cannot exceed the value of max online engines.
- Specify the thread pool idle time out in microseconds.
- (Optional) Provide a description for the thread pool.
- (Optional) Click Preview to see the SQL statements for your command.
- (Optional) Click Summary to verify your selected options.