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