Maximum Number of Agents (maxagents)

Configuration Type
Database manager

Applies to

Parameter Type
Configurable

Default [Range]
200 [ 1 - 64 000 ]

400 [ 1 - 64 000 ] on Partitioned database server with local and remote clients

10 [ 1 - 64 000 ] on Satellite database server with local clients

Unit of Measure
Counter

Related Parameters

This parameter indicates the maximum number of database manager agents, whether coordinating agents or subagents, available at any given time to accept application requests. If you want to limit the number of coordinating agents, use the max_coordagents parameter.

This parameter can be useful in memory constrained environments to limit the total memory usage of the database manager, because each additional agent requires additional memory.

Recommendation: The value of maxagents should be at least the sum of the values for maxappls in each database allowed to be accessed concurrently. If the number of databases is greater than the numdb parameter, then the safest course is to use the product of numdb with the largest value for maxappls.

Each additional agent requires some resource overhead that is allocated at the time the database manager is started.