Chapter 12. Performance Tuning
In this chapter, you will learn
How to tune your database
How to analyze and improve SQL access plans
Performance tuning tips for each of the platforms (LUW, iSeries, zSeries)
How to use the Design Advisor on LUW to create efficient indexes
This chapter is divided into three sections, one for each of the platforms.
Performance Considerations for LUW
This section discusses how to obtain the best performance of your database system with relative ease. When available, the focus is placed on the GUI tools of the various platforms; otherwise, commands will be discussed.
The Configuration Advisor
After you have created stored procedures, triggers, and UDFs, it is a good idea to perform an overall tuning of the database system to ...
Get DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second 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.
