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.



    DB2 SQL PL. Deployment and Advanced Configuration Essential Guide for DB2 UDB on Linux., UNIX, Windows, i5. OS, z. OS
    Intelligent Enterprises of the 21st Century
    ISBN: N/A
    EAN: 2147483647
    Year: 2003
    Pages: 205

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net