Tablespace management | DB2 monitoring


DB2 Agent management

For each database that an application accesses, various processes or threads start to perform the various application tasks. These tasks include logging, communication, and prefetching.

There are four types of agents defined in the DB2 system:

Most applications establish a one-to-one relationship between the number of connected applications and the number of application requests that can be processed by the database. However, it may be that your work environment is such that you require a many-to-one relationship between the number of connected applications and the number of application requests that can be processed.

The ability to control these factors separately is provided by two database manager configuration parameters, max_connections and max_coordagents. Before applying these two parameters to modify your agent working mechanism, we highly recommend thoroughly analyzing the database system based on your requirement, to prevent reaching the upper limitation of available database system resources.