Today’s video is a demonstration of buffer pool hit ratio in the Bufferpools screen of db2top. To produce a hit ratio of 100%, we query a single row repeatedly to perform logical reads with no corresponding physical reads. To reduce the hit ratio, we query more data than can fit in the buffer pool, resulting in physical reads.
Click here to read the rest of "db2top: Buffer pool hit ratio (video)" at Keith's blog
db2top: Buffer pool hit ratio (video)