Snapshot Information Level Database Manager |
API Structure(s) sqlm_db2 |
Monitor Group Basic |
Resettable |
No |
|
API Element Name Element Type |
agents_from_pool counter |
Description: The number of agents assigned from the agent pool.
Usage: This element can be used with Agents Created Due to Empty Agent Pool to determine how often an agent must be created because the pool is empty.
If the ratio of Agents Created Due to Empty Agent Pool / Agents Assigned From Pool is high, it may indicate that the num_poolagents configuration parameter should be increased. A low ratio suggests that num_poolagents is set too high, and that some of the agents in the pool are rarely used and are wasting system resources.
A high ratio can indicate that the overall workload for this node is too high. You can adjust the workload by lowering the maximum number of coordinating agents specified by the maxcagents configuration parameter, or by redistributing data among the nodes.
See the Administration Guide for more information on the Agent Pool Size (num_poolagents) and Maximum Number of Concurrent Coordinating Agents (maxcagents) configuration parameters.
[ Top of Page | Table of Contents | Glossary | Index ]