Tuning Subsystems › Buffer Pools › Buffer Pool Tuning

Buffer Pool Tuning

Buffer pools can be tuned effectively using the DISPLAY BUFFER POOL command. When a tool is not available for tuning, the following items can be used to help tune buffer pools.

• Use command and view statistics.
• Make changes (for example, thresholds, size, object placement).
• Use command again during processing and view statistics.
• Measure statistics.

The output from the following items contains valuable information about the tuning information:

• Sequential, List, Dynamic Requests
• Pages Read
• Prefetch I/O and Disablement

The incremental detail display shifts the time frame every time a new display is performed.