Maximum Number of Coordinating Agents (max_coordagents)

Configuration Type

Database manager

Applies to

• Database server with local and remote clients
• Database server with local clients
• Partitioned database server with local and remote clients
• Satellite database server with local clients

Parameter Type

Configurable

Default [Range]

-1 (maxagents -- num_initagents)

[-1, 0 - maxagents]

For partitioned database environments and environments in which intra_parallel is set to "Yes", the default is maxagents - num_initagents; otherwise, the default is maxagents. This ensures that, in non-partitioned database environments, max_coordagents always equals maxagents, unless the system is configured for intra-partition parallelism.

If you do not have a partitioned database environment, and have not enabled the intra_parallel parameter, max_coordagents must equal maxagents.

Related Parameters

• Initial Number of Agents in Pool (num_initagents)
• Agent Pool Size (num_poolagents)
• Maximum Number of Agents (maxagents)
• Enable Intra-Partition Parallelism (intra_parallel)

This parameter determines the maximum number of coordinating agents that can exist at one time on a server in a partitioned or non-partitioned database environment.

One coordinating agent is acquired for each local or remote application that connects to a database or attaches to an instance. Requests that require an instance attachment include CREATE DATABASE, DROP DATABASE, and Database System Monitor commands.