the relation between agent pool size(num_poolagents) and worker agents and coordinating agents in IBM DB2 (LUW)

Question

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

Answer 1

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.

Answer 2

The agent pool is used to avoid frequent process kills and creations. If an agent gets idle it can wait in the pool for a new request - avoiding the overhead of destroying it and creating a new process if needed.

Also check out the helpful page about the Db2 process model

Agent processes will only get destroyed if the pool is already full of idle agents.