SQL1226N The maximum number of client connections are already
started.
Explanation:
The number of client connections is already equal to the maximum
value defined in the system configuration file.
The operation cannot be processed.
User Response:
Wait for other applications to disconnect from the database.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.
sqlcode :-1226
sqlstate :57030
tunning the following parameter:
Max number of existing agents
(MAXAGENTS) = 200
Agent pool size
(NUM_POOLAGENTS) = 100(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) = MAX_COORDAGENTS