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 ...

Get Understanding DB2®: Learning Visually with Examples now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.