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 ⋮
LEVELspecifies the type of report, here, a summary report.
ORDERspecifies the aggregation, here, by buffer pool ID (BPID) and a combination of database and page set (QPAGESET).
SORTBYspecifies the sorting of the aggregated information, here, by buffer pool ID (BPID) and asynchronous page (ASYNCPAGE).
TOPspecifies that the 17 topmost aggregations are reported. If the trace data contains more than 17 objects, they are aggregated under the label
Othersin the report.
This example was created with the following command:
Note that the
BPACTIVITY REPORT LEVEL(SUMMARY) ORDER(BPID-QPAGESET SORTBY(BPID, ASYNCPAGE) TOP(17))
TOPoptions affect only the information in The Data Set Statistics section.