Forgot your password?
Document Actions
How to use Connection Concentrator
Description
Connection concentrator, on the other hand, allows DB2 Connect to make
a connection available to an application as soon as another application has
finished a transaction and does not require that other application to disconnect.
In essence, a database server connection and its associated host and DB2 Connect
resources are used by an application only while it has an active transaction.
As soon as the transaction completes, the connection and associated resources
are available for use by any other application that needs to have a transaction
executed.
The database manager configuration parameter MAX_CONNECTIONS sets the maximum number of logical agents. You can activate the concentrator feature by setting the value of MAX_CONNECTIONS to any number greater than the default. The default value for MAX_CONNECTIONS is equivalent to the value of MAX_COORDAGENTS. Because each application will have one logical agent, MAX_CONNECTIONS actually controls the number of applications that can be connected to the database instance, while MAX_COORDAGENTS controls the number of inbound connections that can be active at any time. MAX_CONNECTIONS will take a numeric range from MAX_COORDAGENTS up to 64,000. The default number of logical agents is equal to MAX_COORDAGENTS.
Several existing configuration parameters are used to configure agents. These parameters are as follows:
- MAXAGENTS
- Maximum number of worker agents.
- MAX_COORDAGENTS
- Maximum number of active coordinator agents.
- NUM_POOLAGENTS
- Agents pool size. The agent pool includes inactive agents and idle agents.
- NUM_INITAGENTS
- Initial number of worker agents in the pool. These will be idle agents.
To use Connection Concentrator set MAX_CONNECTION to be greater than MAX_AGENTS
db2 update dbm cfg using MAX_CONNETIONS 4000
db2stop
db2start
MAX_CONNECTIONS = 4000
MAX_AGENTS = 1000
MAX_COORDAGENTS = 1000
NUM_POOLAGENTS = 1000
Hacker Rangers - Gamification for CyberSecurity