As this chapter has explained, the performance of a database and the applications that access it are influenced by many factors, including the database and database manager configuration, as well as DB2 registry variables. This chapter discussed how to configure DB2 for optimal performance, using database and database manager configuration parameters and DB2 registry variables , as well as how to monitor the database to ensure that the configuration parameters are configured correctly.

This chapter also introduced and discussed the performance tuning commandments :

  • Understand the Magic Triangle of Performance

  • Ensure enough available memory

  • Ensure sufficient I/O handling capability

  • Use proper indexes

  • Do not hold locks longer than absolutely necessary

  • Use efficient SQL

  • Use parallelism only when workload requires it

  • Ensure that the catalog statistics are current

Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows
ISBN: 0130463884
EAN: 2147483647
Year: 2003
Pages: 121 © 2008-2017.
If you may any questions please contact us: