This statement specifies the number of concurrent threads.
Definition
A lower-level DBH option of SYSTEM-LIMITS
Function
In multithread mode, the DBH processes several requests simultaneously. Each request is stored in a thread.
You use the DBH option THREADS to specify how many threads are to be available in the DBH session for requests from applications. This restricts indirectly the number of concurrent requests.
You will avoid system bottlenecks by specifying a number of threads that is less than or equal to the number of tasks of all the application programs. You should also count applications such as the SESUTI utility monitor or the SESADM administration program for this purpose. If a system bottleneck occurs because the value specified for the THREADS option is too low, it is removed by rolling back the transaction. This ensures that not all threads are blocked by blocked requests.
For an independent DBH an internal comparison is carried out so that the value for THREADS is greater than or equal to twice the value of the DBH-TASKS option. For a linked-in DBH the DBH option THREADS is ignored, i.e. the value 1 is the default value for threads.
You can adjust the value of the option with the administration statement RELOAD-DBH-SESSION (see "RELOAD-DBH-SESSION") when the DBH modules are reloaded.
THREADS |
= 1 / <integer 1..1024> |
THREADS = 1 / <integer 1..1024>
Specifies the maximum number of concurrently active threads.
Information on thread utilization
You can obtain information on the current utilization of the threads from the “SYSTEM-INFORMATION” form of the SESAM/SQL monitor SESMON (see "DBH form SYSTEM INFORMATION"). The “ Performance” manual describes the cases in which it makes sense to modify the number of threads at the next DBH startup.