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 […]
Tag: bufferpool
db2top Bufferpools Screen (Part 2)
In the first post on db2top’s Bufferpools screen, we saw aggregates across all of the buffer pools in the database. In this second part, you will see what db2top reports for individual buffer pools. For […]
db2top Bufferpools Screen (Part 1)
Considering the dramatic differences in speed between memory access and disk access, it is not surprising that DB2’s own documentation claims that configuring buffer pools is the single most important tuning area for DB2. In […]