15.5. Agent-Level Private Memory
Each DB2 agent process also needs to acquire memory to perform its work. As you can see in Figure 15.5, they use memory to optimize, build, and execute access plans on behalf of the application, to perform sorts, to record cursor information such as location and state, to gather statistics, and so on.
Figure 15.5. Agent-level private memory
When a DB2 agent is created, it allocates the minimum amount of memory that is required to do some basic work. As it works, it may allocate larger areas of these memory areas depending on the statements that are being processed, the number of cursors the ...