16.1. Performance Fundamentals
When you start designing, building, and tuning your database system, you need to try to balance the three main areas that affect your performance:
CPU usage
I/O utilization
Memory usage
At least one of these three areas is affected by any change that you make, either in designing the system or tuning the system using the registry variables or DB2 configuration parameters. For example, increasing the size of one or more of your buffer pools will increase the memory consumption on the server, but it may then decrease the I/O that is required. By understanding how the various registry variables and configuration parameters impact the CPU usage, I/O, and memory usage, you will be better prepared to judge whether the changes ...
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.
