Part V. DB2 Performance Tuning
Now that you understand how to monitor the DB2 environment, you must develop a plan to analyze the performance data you have accumulated and tune DB2 to boost performance. As you will see in this section, diverse tuning strategies are involved in making DB2 perform optimally.
It is not sufficient to merely monitor and tune DB2 alone. A comprehensive DB2 tuning program involves monitoring and tuning the following five areas:
• The z/OS (MVS) system
• The DB2 subsystem
• The teleprocessing and networking environments (including Internet connectivity for web applications)
• DB2 database design
• DB2 application program design
Some areas require more DB2 tuning attention than others. The DB2 performance tuning pie, ...
Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition 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.
