The specifications for global buffer pools can have a significant effect on a disk's data I/O performance. For this reason, global buffer pools should be specified so that high hit rates are achieved. This section discusses the items to be evaluated in order to improve the buffer hit rates for the global buffer pools.

If the items described here are evaluated in conjunction with HiRDB file information related to database manipulations, performance can be improved most efficiently.

Information to be collected

Global buffer pool statistical information is collected. The following resources are provided for collecting this information:

• pdbufls command
• Statistics analysis utility

The pditvtrc command can be used to execute this command and utility periodically on a regular basis.

Organization of this section

23.1.1 Using the pdbufls command to collect statistical information

23.1.2 Using the statistics analysis utility to collect statistical information