Section 15.11. Summary

15.11. Summary

DB2 provides you with a very flexible way to configure your databases for optimal performance. By understanding how and when DB2 uses and allocates memory, you can tune your system to handle any workload.

For each instance you can control the instance-level memory for such things as the agents that work on behalf of your applications, the overall memory available for private sorts to ensure that you do not overwhelm your server, and for the memory available for inter-partition communications.

For each database you can control the size of each individual sort, the amount of space available for such things as locking and logging, as well as the size of the buffer pools available to retrieve data and index pages that need to be read and/or updated.

Now that you understand when and how these memory areas are allocated, and how they work together, you can better understand how changes to particular configuration parameters will impact the overall memory used on the system as well as how the configuration parameters will interact with each other.