21. Tuning

This chapter explains how to tune a database.

Databases should be tuned in order to maintain optimum performance. However, the available memory and disk space may not be adequate to achieve the desired level of performance. Therefore, a balance between performance on the one hand and memory and disk space requirements on the other hand must be considered when the system is tuned.

This chapter contains the following sections:

Organization of this chapter
21.1 Tuning global buffer pools
21.2 Tuning deferred write processing
21.3 Tuning the synchronization point processing time when deferred write processing is used
21.4 Tuning the synchronization point dump interval
21.5 Tuning buffer lengths
21.6 Tuning the number of processes
21.7 Tuning indexes
21.8 Tuning the database
21.9 Tuning SQLs
21.10 Tuning the system's internal processing