Premier advisor for DB2 buffer pool optimization.
BPA4DB2 facilitates the tuning and optimal reallocation of DB2 buffer pools. Unlike other tools which focus on his ratio, number of getpages and page residency time, BPA4DB2 concentrates on the ReReads as the main indicator for tuning potential. Re-Reads are unnecessary, avoidable reads of the same data page within a short period of time. We say, there is definitely tuning potential, if amongst the Reads are more than 10% Re-Reads.
More information : Data Sheet – BPA4DB2 11V03