Setting thread limits
You can limit the maximum number of Db2 threads that can be allocated concurrently.
About this task
Set these values to provide good response time without wasting resources, such as virtual and real storage. The value that you specify depends on your machine size, your workload, and other factors. When specifying values for these subsystem parameters, consider the following factors:
- Fewer threads than needed under-use the processor and cause the queuing of threads.
- More threads than needed do not improve the response time. They require more real storage for the additional threads and might cause more paging, and therefore, performance degradation.
Procedure
To limit the number of allied and database access threads that can be allocated concurrently: