The report header

The report header is shown at the top of every report page and identifies the report and the command options that were used to create the report.

The following is an example of a report header:
1    DB2 BUFFER POOL ANALYZER (V5R4M0) - BUFFER POOL ACTIVITY REPORT   PAGE: 1-1

                              ORDER: BPID-QPAGESET
                              TOP: 11  LEVEL: DETAIL
 GROUP:     N/P         LOCATION:       PMO2D721            DB2 VERSION: V11
 MEMBER:    N/P         REQUESTED FROM: NOT SPECIFIED       TO: NOT SPECIFIED
 SUBSYSTEM: D721        INTERVAL FROM:  12/06/13 16:08:30   TO: 12/06/13 16:09:22
⋮
  • LEVEL specifies the type of report, here, a detail report.
  • ORDER specifies the aggregation, here, by buffer pool ID (BPID) and a combination of database and page set (QPAGESET).
  • SORTBY is not used for this example.
  • TOP is not used; therefore, the default 11 applies. This means that the 11 topmost aggregations are reported. If the trace data contains more than 11 objects, they are aggregated under the label Others in the report.
This example was created with the following command:
BPACTIVITY REPORT LEVEL(DETAIL)
                  ORDER(BPID-QPAGESET) 
Note that the ORDER, SORTBY, and TOP options affect only the information in The Detail Activity section.