January 2005
Beginner to intermediate
928 pages
22h 14m
English
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 ...
Read now
Unlock full access