Headers used in Statistics

The headers in Statistics reports and traces are identical, except that INTERVAL FROM and INTERVAL TO in the report header is replaced by ACTUAL FROM in the trace header and the SCOPE field does not apply to Statistics traces.

Statistics report header example

Here is an example of a Statistics report header.



   LOCATION: PMODBZ1                 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                      PAGE: 1-1
      GROUP: DBZ1                                STATISTICS REPORT - LONG                       REQUESTED FROM: NOT SPECIFIED
     MEMBER: SZ11                                                                                           TO: NOT SPECIFIED
  SUBSYSTEM: SZ11                                                                                INTERVAL FROM: 07/18/15 21:30:00.38
DB2 VERSION: V10                                      SCOPE: MEMBER                                         TO: 07/18/15 21:53:00.00
The Statistics report and trace headers contain the following information:
LOCATION
The DB2 reporting location. If the DB2 subsystem is installed without a location name, either the DB2 subsystem ID (in non-data sharing environments) or the data sharing group name (in data sharing environments) is shown.
GROUP
The data sharing group that the DB2 subsystem belongs to.
MEMBER
The name of the DB2 data sharing member. This field is not printed for group-scope reports.
SUBSYSTEM
The ID of the DB2 subsystem that generated the data. This field is not printed for group-scope reports.
DB2 VERSION
The version number of the DB2 subsystem that generated the data.
Title - layout
The title of the report or trace and the layout. The layout can be the default layout (LONG or SHORT) or a layout that you have tailored yourself.
SCOPE
The scope of the report, which can be MEMBER or GROUP. A member-scope report shows a group's instrumentation data member by member without merging the data. A group-scope report merges the instrumentation data that belong to the individual members and presents it for the entire group.
Note: All reports in a non-data sharing environment are member-scope reports.
EXCEPTION
Indicates an exception report or trace.
PAGE
The page number within the report in the format lll-nnnnnn, where lll denotes the sequence number of one or multiple locations (see LOCATION), and nnnnnn denotes the page number within the location.
REQUESTED FROM and TO
The FROM and TO dates and times that were specified in the REPORT or TRACE subcommand. If both FROM and TO dates and times are omitted from the subcommand, the FROM and TO dates and times from the GLOBAL command are printed.

If only the FROM date and time or only the TO date and time has been specified, NOT SPECIFIED is printed for the unspecified value. If FROM and TO are not specified in the subcommand and GLOBAL command, NOT SPECIFIED appears for both the FROM and TO values.

If you specified FROM and TO times without dates in the subcommand and GLOBAL command, ALL DATES is printed together with the specified times.

Note: Any FROM and TO times that are specified in REDUCE can affect the GLOBAL FROM and TO times.
ACTUAL FROM
The date and time of the first DB2 Statistics record that was processed by the trace.
INTERVAL FROM
The start date and time of the first interval record that is covered by the report.
INTERVAL TO
The end date and time of the last interval record that is covered by the report.