Managing Db2 threads

Threads are an important resource within a Db2 subsystem. A thread is a structure that describes a connection made by an application and traces its progress in the Db2 subsystem. These values are specified at installation, and controlled by subsystem parameters.

About this task

You can specify maximum numbers of active allied and database access threads that can be allocated concurrently. Appropriate limits for threads are important to keep applications from queuing, and to provide adequate response times.

Db2 subystems use the following types of threads:

Allied threads: Db2 uses allied threadsto process local requests and connections from allied subsystems, such as TSO, batch, IMS, CICS®, CAF, or RRSAF. For more information, see Managing allied Db2 threads.
Database access threads (DBATs): Db2 uses distributed database access threads (DBATs) to process requests through a network for distributed clients that access data in a Db2 for z/OS® server. For more information, see Managing distributed database access threads (DBATs).