STRANGE DISPLAY OF READ EFF IN BUFFER POOL LIST DISPLAY PANEL

Document ID : KB000049398
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

The Buffer Pool List displays the value of Read Eff as *******. What does this mean?

Answer: 

READ EFF stands for Read Effectiveness and is the ratio of Getpage requests to Synchronous I/O operations. When Synchronous I/O value is 0 (zero) and getpage value is NON ZERO, since you can't divide by zero, that's when the value of Read Eff is displayed as ********.