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.
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
