ChannelDB2

The number of client connections is already equal to the maximum value defined in the system configuration file

If one or more applications are required to run concurrently, increase the value for max_connections. The new value takes effect after the next successful database manager start. If the value for max_connections is larger than the value for max_coordagents, the concentrator feature is turned on.


Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 400
Agent pool size (NUM_POOLAGENTS) = 200(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) = 1500



db2 update dbm cfg using MAX_CONNECTIONS 1600 IMMEDIATE
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
$ db2 get dbm cfg



Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 440
Agent pool size (NUM_POOLAGENTS) = 220(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) = 1600


source: http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp

Views: 455

Comment

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service