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