14.5. The Connection Concentrator

By default, each application is assigned a coordinator agent (MAX_CONNECTIONS = MAX_COORDAGENTS). Each agent operates within its own private memory and shares other memory sets with other agents. If an application connects to the database and does nothing, the resources associated with its coordinator agent are wasted. You can use the connection concentrator to avoid this.

The connection concentrator is enabled when MAX_CONNECTIONS is greater than MAX_COORDAGENTS. This means you can have more connections than the number of available coordinator agents. Each coordinator agent will service more than one connection.

When the connection concentrator is enabled, an application is in an active state only if there is ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.