Parameters related to locking | Best practices


DB2 Parameters related to agents management


+

Search Tips   |   Advanced Search

The following database manager configuration parameters determine how DB2 database agents can be created and managed:

Maximum number of agents maxagents The number of agents that can be working at any one time. This value applies to the total number of agents that are working on all applications, including coordinator agents, subagents, inactive agents, and idle agents.
Agent pool size num_poolagents The total number of agents, including active agents and agents in the agent pool, that are kept available in the system. The default value for this parameter is half the number specified for maxagents.
Initial number of agents in pool num_initagents When the database manager is started, a pool of worker agents is created based on this value. This speeds up performance for initial queries. The worker agents all begin as idle agents.
Maximum number of connections max_connections This specifies the maximum number of connections allowed to the database manager system on each partition.
Maximum number of coordinating agents max_coordagents For partitioned database environments and environments with intra-partition parallelism enabled when the connection coordinator is enabled, this value limits the number of coordinating agents.
Maximum number of concurrent agents maxcagents This value controls the number of tokens permitted by the database manager.

In some peak usage system, where the resources for memory, CPU, and disk are almost 100% utilized, insufficient configuration might cause performance degradation for peak load periods. You can modify some of these parameters to control the load and avoid performance degradation.