Accessing information about buffer pool performance

You can review buffer pool information (such as getpages and buffer pool hit ratios), to evaluate how well a thread is performing and to determine if excessive I/O is being consumed for a thread.

1. To access information about buffer pool performance from Db2 Active Threads:
   1. From the OMEGAMON main menu, select the DB2 tab (KOBSDB2).
   2. In the entry field next to the appropriate Db2 subsystem, type T to access Db2 Active Threads panel (KDPTHD52).
   3. In the entry field next to the appropriate active thread:
      • Type B and press enter to access the Db2 Thread Detail Buffer Pool panel (KDPTHDBP). In the Buffer Pools section, type S next to the buffer pool of interest to access the DB2 Thread Detail Buffer Pool panel (KDPTHDBD).
      • Type G and press enter to access the Db2 Thread Detail Group Buffer Pool panel (KDPTHGBP). In the Group Buffer Pools section, type S next to the buffer pool of interest to access the DB2 Thread Detail Group Buffer Pool panel (KDPTHGBD).
2. To access information about buffer pool performance from Thread History:
   1. From the OMEGAMON main menu, select the DB2 tab (KOBSDB2).
   2. In the entry field next to the appropriate DB2 subsystem, type R.
   3. On the Thread History Timespan Selection panel (KDPHFIL1), specify the appropriate selection criteria and click OK.
   4. On the Thread History Summary panel (KDPHISTL) panel:
      • Type B and press enter to access the DB2 Thread History Detail Buffer Pools > BP tab (KDPHBP). In the Buffer Pools section, type S next to the buffer pool of interest to access the DB2 Thread History Detail Buffer Pool panel (KDPHBPD).
      • Type G and press enter to access the Db2 Thread History Detail Buffer Pools > GBP tab (KDPHGBP). In the Group Buffer Pools section, type S next to the buffer pool of interest to access the DB2 Thread History Detail Buffer Pool panel (KDPHGBPD).