Expert Advice

DB2_CMD_Group_BP_READ_Hit_Warn  
Situation Description
Suggested Actions
Situation Description

This message is displayed when "Read hit %" exceeds the warning threshold.

 

Suggested Actions

The percentage of all Reads to the group buffer pool (Read hit %) is decreasing. The purpose of the buffer pool is to try to avoid disk I/O. Your buffer pool is efficient if you have a high hit ratio (ideally, over 99%).

You might need to resize your buffer pool or re-balance buffer pool usage by moving table spaces to a buffer pool with less usage.

 

Copyright IBM Corp. 2005, 2016. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Contact IBM.