DataPgHitRatio (DB2UDB_BUFFERPOOL)
Indicates the percentage of the data reads that did not require physical disk access. This type of data read may be performed because the data is already in the cached memory buffer pool. This parameter can be used to help determine the correct setting for the buffpage configuration parameter.
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 DataPgHitRatio parameter would not populate a value since there is no value for the previous pool data physical reads and logical reads. From next collection cycle, parameter will compute and populate the value. Also, the DataPgHitRatio 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
Attribute | Default value |
|---|---|
Application class | DB2UDB_BUFFERPOOL |
Command type | not applicable |
Platform | All |
Active at installation | yes |
Parameter type | Consumer |
Scheduling (poll time) | not applicable |
Icon style | Graph |
Alarm 1 range | not applicable |
Alarm 2 range | not applicable |
Border range | not applicable |
Unit | Percentage |
Annotated? | No |
Value set by | CollBufferpool |