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     OMEGAMON XE FOR DB2 PE (V5R4M0) - BUFFER POOL ACTIVITY REPORT    PAGE: 1-1
                              ORDER: BPID-QPAGESET
                 SORTBY: BPID,ASYNCPAGE  TOP: 17  LEVEL: SUMMARY
 GROUP:     DSNJ        LOCATION:       PMODSNJ             DB2 VERSION: V11
 MEMBER:    SGJ1        REQUESTED FROM: NOT SPECIFIED       TO: NOT SPECIFIED
 SUBSYSTEM: SGJ1        INTERVAL FROM:  01/24/13 07:21:46   TO: 01/24/13 09:27:13
⋮
  • LEVEL specifies the type of report, here, a summary report.
  • ORDER specifies the aggregation, here, by buffer pool ID (BPID) and a combination of database and page set (QPAGESET).
  • SORTBY specifies the sorting of the aggregated information, here, by buffer pool ID (BPID) and asynchronous page (ASYNCPAGE).
  • TOP specifies that the 17 topmost aggregations are reported. If the trace data contains more than 17 objects, they are aggregated under the label Others in the report.
This example was created with the following command:
BPACTIVITY REPORT LEVEL(SUMMARY)
                  ORDER(BPID-QPAGESET SORTBY(BPID, ASYNCPAGE) TOP(17)) 
Note that the ORDER, SORTBY, and TOP options affect only the information in The Data Set Statistics section.