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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.