Previous Topic: DB2BPH – DB2 Daily Buffer Pool Hit PercentNext Topic: Uses


Overview

The DB2BPH query produces a daily chart. The chart shows the total Get Page Requests for each buffer pool and the percentage of requests that were satisfied from the buffer pool (hits). The hit percentage is displayed using vertical bars and the total Get Page Requests are shown using a horizontal line.

The example shows the daily chart generated for DB2 Region DXP1 running on SYSID W29W. Buffer pool 31 had the greatest number of Get Page Requests (62,489) with a buffer pool hit percentage of 82.3 percent.