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 labelOthers
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.