Buffer Pool Analyzer

You can use Buffer Pool Analyzer to analyze and tune the buffer pool performance of Db2 systems.

Overview
Buffer Pool Analyzer provides a suite of tools that support in-depth analysis of the performance of DB2 buffer pools.
Collecting data
This topic describes how to collect the performance data that is used by Buffer Pool Analyzer. It describes two methods to collect buffer pool trace data. The first method uses ISPF and the Collect Report Data (CRD) function to configure and control a collect task, the second method uses a batch job that contains equivalent specifications for a collect task.
Creating activity reports and bpd files
This 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 reports
This 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 client
This topic describes how to view detailed buffer pool performance data on the client.
Optimizing object placements and initial buffer pool sizes
This topic describes how to optimize the object placements in buffer pools and buffer pool sizes on the client.
Simulating buffer pool behavior
This topic describes how to simulate buffer pool behavior on the client.
Analyzing long-term buffer pool performance
This 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 case
This 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 client
This 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 files
This 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 table
This section briefly describes how to store trace data from bpd files into Db2 tables.
The TRSMAIN terse utility
This 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 Analyzer
This 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.