Thread Pool Properties

View properties of thread pools in an Adaptive Server.

In the Thread Pools screen, select Properties on your thread pool name to initiate the Properties wizard and modify these properties:

Wizard Option	Thread Pool Properties
General	Name and type – Adaptive Server supports two types of threads: Engine (or multiplexed) or Run to completion (RTC) threads. User created thread pools are always multiplexed. Instance name (cluster environment only) – only displayed when the thread pool is created on an instance of the cluster rather than the entire cluster. Thread count – you can increase the thread count up to a maximum value of max online engines configuration parameter. Idle Time Out – set to: 0 – threads change to sleep mode if no work is available. -1 – threads never change to sleep mode even if no work is available. Description – add a description for the thread pool.
Execution Classes	Sybase Control Center displays the execution classes that are associated with each user or system thread pool. You cannot modify their properties.

Wizard Option

General

Name and type – Adaptive Server supports two types of threads: Engine (or multiplexed) or Run to completion (RTC) threads. User created thread pools are always multiplexed.
Instance name (cluster environment only) – only displayed when the thread pool is created on an instance of the cluster rather than the entire cluster.
Thread count – you can increase the thread count up to a maximum value of max online engines configuration parameter.
Idle Time Out – set to:
- 0 – threads change to sleep mode if no work is available.
- -1 – threads never change to sleep mode even if no work is available.
Description – add a description for the thread pool.

Execution Classes

Sybase Control Center displays the execution classes that are associated with each user or system thread pool. You cannot modify their properties.