Setting thread limits for database access threads

You can specify the maximum number of concurrently active allocated database access threads (DBATs) in the Db2 subsystem.

To control the maximum number of concurrently allocated active threads, use the following approaches:

• Specify the value of the CTHREAD subsystem parameter to control the maximum number of allied threads that can be concurrently allocated.
  The sum of the values of the CTHREAD and MAXDBAT subsystem parameters must not exceed 20000.
• Specify the value of the CONDBAT subsystem parameter to control the concurrent inbound DDF connections.
  The CONDBAT value must be greater than or equal to the sum of the connection pool sizes for all applications that connect to Db2 concurrently. The maximum acceptable value for CONDBAT subsystem parameter is 150000. However, this upper limit is obtained only if you specify INACTIVE for value of the CMTSTAT subsystem parameter.