Summary
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
