Creating activity reports

Buffer Pool Analyzer provides the BPACTIVITY command (for Buffer Pool Activity) and its subcommand REPORT to create activity reports from collected trace data.

The command is used in batch jobs, together with data definition (DD) statements that specify, among others, one or more input data sets with collected trace data. The command creates one or more reports in table form and stores them in a sequential data set. The reports can be viewed or printed by means of appropriate system utilities.

Command options are available to specify the type of report (summary or detail), to selectively use the input data for reports (for example, to limit the time frame or to filter out uninteresting information), and to specify the aggregation and sorting of the reported data.

The reports provide you with comprehensive information about how the buffer pools and the objects are used, for example:
  • System and application hit ratios, buffer pool activity counts, I/O activity counts
  • Information sorted according to different identifiers, such as buffer pool, plan name, object, or primary authorization ID
  • Data ranked by the type of buffer pool operation, for example, by the number of Getpage requests, Sequential prefetches, or Synchronous reads
  • Changeable thresholds to show only the most active objects in reports
  • Information filtered to include, or to exclude, only specific buffer pools, plans, or time frames
  • If the trace data in the input data sets is from a member of a data sharing group, where multiple DB2® subsystems share a group buffer pool, activity reports additionally contain detailed performance information about the group buffer pool.

Creating activity reports and bpd files describes the details of using the BPACTIVITY command and its options in batch jobs to create summary and detail reports.

Interpreting activity reports shows examples of summary reports and detail reports and explains how to interpret them.