16.13. Summary
This chapter covered the main factors that affect the performance of your database system: CPU usage, I/O utilization, and memory usage.
To configure DB2 for optimal performance, you need to understand how the database and Database Manager Configuration parameters impact your applications and the overall system. The Configuration Advisor can facilitate your tuning efforts with respect to parameter configuration.
Examining maintenance operations like REORG and RUNSTATS help keep the database running optimally, but you will also need to monitor you system using either the Snapshot Monitor or the Event Monitor to be sure it is running efficiently. If the snapshots indicate that a particular SQL statement is performing poorly, you ...
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.
