I am going to configure the size of agents pool in IBM DB2, the default size is Automatic(100). As I understand there are coordinator agents which responsible to connection to clients(remote application or local clients). Also, There are worker agents where handle requests from applications and assigned by coordinators. The default value of Maximum Number of Coordinating agents is set to Automatic(200) which means maximum number of connected applications. The question is that is the sum of coordinating agents and worker agents is equal to num_poolagents?I mean if I set Num_poolagents to 100, the sum of coordinating agents and worker agents will not exceed 100?
I run db2 get database manager configuration and see the default values: enter image description here
There is no relation between max_coordagents and num_poolagents.
You may think about num_poolagents
as a number of apples on a shelf. If there are no more apples there, a shop manager can bring you a number of apples needed from a store.