21.1 Tuning global buffer pools

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 hits rates are achieved. This section discusses the items to be evaluated in order to improve the buffer hits 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
21.1.1 Using the pdbufls command to collect statistical information
21.1.2 Using the statistics analysis utility to collect statistical information