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.
About this task
For the sake of completeness, note that the Generalized Trace Facility (GTF) and the System Management Facility (SMF) can also collect buffer pool related trace data. The data is recorded in appropriate GTF and SMF data sets, which can be used as alternative or additional input for the creation of activity reports and bpd files. In Creating activity reports and bpd files, the description of the INPUTDD statement provides more details about specifying alternative or multiple input data sets. However, the important point is that GTF or SMF must be set up in SYS1.PROCLIB to collect, besides others, also buffer pool related data (as specified in Determining what to collect).
- Collecting data is always the first task before you can perform any of the other Buffer Pool Analyzer functions.
- After you have performed this task, the trace data is available
in named data sets and can be used for the tasks described in:
- Creating activity reports and bpd files Activity reports are created on the host. Bpd files need to be downloaded to the client before they can be used for the tasks described in:
- Simulating buffer pool behavior
DB2® trace data files need to be downloaded before this task can be performed on the client.
- Creating activity reports and bpd files
- Ensure that your output data sets are large enough. The amount
of data that is being collected depends largely on the activity in
the buffer pools. If you are going to collect
detaildata, remember that each activity produces at least one trace record. On a busy system you can rapidly generate several million records. Limit the data collection time, or the number of records to be collected, until you have a feeling about the amount of trace data being produced on your system.
- If you are going to collect data for optimizing the object placements, ensure that the Db2 catalog statistics are up to date. Among other factors, Buffer Pool Analyzer considers the size of page sets and might otherwise produce inaccurate results. Run the RUNSTATS utility, if required.
- If you are going to collect data
- Ensure that you collect
shortformat, for approximately 20 minutes continuously, which generally gives a good representation of a particular workload. If the workload varies significantly, collect a slightly smaller trace for each workload type.
- For large amounts of data you can optionally create an additional
output data set that contains the collected data in compressed format.
The size and the download time of such data sets are roughly 25 percent
of the equivalent uncompressed data sets. The simulation function
can handle both types. See The TRSMAIN terse utility for
Note that an uncompressed data set is always created. Therefore, if you choose to create the additional compressed data set, you should have approximately 1.25 times the required disk space available. However, if the data is exclusively used for simulations, you can erase the uncompressed data set after both data sets are created.
- Avoid collecting more than 2 GB of data. The simulation function
on the client can handle trace data files of up to 2 GB (no matter
whether the data is compressed or uncompressed). If you realize that
the size of a trace data file on the client is too big, create and
download a smaller file (less than 2 GB on the client), compare the
actual sizes, and estimate the approximate maximum size of the host
data set as follows:
If necessary, collect a smaller trace to keep the trace data file below its maximal size.
Size_on_host_actual Size_on_host_max --------------------- ≈ ---------------- Size_on_client_actual 2 GB
- Ensure that you collect
- If you are going to collect data for object placement and simulation, ensure that all requirements in remarks 2 and 3 are met. Furthermore, it is essential that you keep the trace data file and the bpd file together. (The bpd file must be created as described in Creating activity reports and bpd files.)
The following topics provide additional information: