db2top: Buffer pool hit ratio (video)

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.

Watch “db2top: Buffer pool hit ratio” directly on YouTube.

If you enjoyed this post, make sure you subscribe to my RSS feed!
Share
  • Search