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.
Skip to content
Watch “db2top: Buffer pool hit ratio” directly on YouTube.
Agile Transformation Leadership, Coaching, and Mentoring