SyncBPHitRatio (DB2UDB_BUFFERPOOL)

Indicates the percentage of the synchronous buffer pool accesses that resulted in requests for data, which did not require a disk access.

The BUFFERPOOL DB2 Monitor Switch must be set ON to make this parameter active and collect data.

This parameter uses the delta calculations.

Parameter value calculation

Note: During first collection cycle, the SyncBPHitRatio parameter would not populate a value since there is no value for the previous buffer pool physical and logical reads. From next collection cycle, parameter will compute and populate the value. Also, the SyncBPHitRatio parameter will go into an offline state during first collection cycle, however, parameter will return to online state from the next collection cycle.

Default parameter attributes