O'Reilly logo

DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition by Paul Yip, Fraser McArthur, Michael Gao, Raul Chong, Drew Bradstock, Clara Liu, Zamil Janmohamed

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required