Buffer Pool Analyzer You can use Buffer Pool Analyzer to analyze and tune the buffer pool performance of Db2® systems. OverviewBuffer Pool Analyzer provides a suite of tools that support in-depth analysis of the performance of Db2 buffer pools.Collecting dataCollect the performance data that is used by Buffer Pool Analyzer. Creating activity reports and bpd filesThis topic describes how to create activity reports and buffer pool data (bpd) files from collected trace data. It describes an example of a batch job and the use of the BPACTIVITY command.Interpreting activity reportsThis topic shows examples of a summary report and a detail report and describes the layout and the elements of these reports. This topic helps to understand the host reports created by Buffer Pool Analyzer.Viewing performance data on the clientThis topic describes how to view detailed buffer pool performance data on the client.Optimizing object placements and initial buffer pool sizesThis topic describes how to optimize the object placements in buffer pools and buffer pool sizes on the client.Simulating buffer pool behaviorThis topic describes how to simulate buffer pool behavior on the client.Analyzing long-term buffer pool performanceThis topic describes how to view performance data from several bpd files on the client to perform a long-term analysis of buffer pool performance.Example of a use caseThis section describes an example of a use case that explains how Buffer Pool Analyzer tools can be used.Downloading files from the host to the clientThis section describes how to download the input data for these functions from the host to the client.Concatenating trace data for activity reports and bpd filesThis section outlines some possibilities of using trace data from SMF or GTF data sets and concatenating multiple data sets as input for activity reports and bpd files.Loading a bpd file into a Db2 tableThis section briefly describes how to store trace data from bpd files into Db2 tables.The TRSMAIN terse utilityThis section provides information about the TRSMAIN terse utility that is used to compress collected trace data, and it shows batch job examples using the utility.Troubleshooting for Buffer Pool AnalyzerThis section categorizes possible Buffer Pool Analyzer problems and describes steps to solve them. The intention of this section is to provide a fast problem determination.