
300 DB2 Performance Expert for Multiplatforms V2.2
Drilling down for more details by double-clicking on a particular buffer pool
opens up another tabbed page with size information. We select the FRUITS
buffer pool, since it has a low hit ratio. In this case, the hit ratio problem is due
to the buffer pool having been allocated a small amount of space. This can be
seen in Figure 5-35.
Figure 5-35 Current size of problem buffer pool
Finally, in Statistics Details, from the Main tabbed page, click Memory Pool
Usage to show the buffer pools’ contribution to Current Size of Memory Pool,
Maximum Fragment Size, and number of Fragments.
System Health ...