STATISTICS command with REPORT subcommand

This section describes the STATISTICS command with the REPORT subcommand.

Usage

Use the REPORT subcommand to present statistics interval records. For the definition of the interval records see Report Reference.

The duration and alignment of the interval records are specified by the REDUCE subcommand.

The interval records can be either presented individually (if the ORDER(INTERVAL) subcommand option is specified) or aggregated into a new interval record for the duration that is specified with the FROM and TO options in the REPORT subcommand.

Usage notes

  • Up to five REPORT subcommands can be specified within a STATISTICS command.

Syntax of the REPORT subcommand

Read syntax diagramSkip visual syntax diagramREPORTFROM/TO blockNOEXCEPTIONEXCEPTIONSCOPE(MEMBERGROUP)DDNAME(STRPTDDddname)ORDER(INTERVAL)LAYOUT(SHORTLONGname)INCLUDE/EXCLUDE blockDSETSTAT

Subcommand options

The syntax diagram shows the options that are available with this subcommand. See Subcommand options for comprehensive descriptions of these options. The following list gives additional or specific descriptions of selected options, where appropriate.

FROM/TO
Limits the range of interval records included in the reporting process by date and time.

Combinations of FROM date and time, and TO date and time can be specified. Interval records are included from the first with an ending timestamp greater than or equal to the FROM date and time, to the last with an ending timestamp less than the TO date and time.

If you do not specify a date and time, FROM/TO defaults to the dates and times specified in the GLOBAL command. If FROM/TO is not specified in GLOBAL, all records are included in the report.

The specified FROM/TO dates and times are printed on the report. If FROM/TO is not specified in REPORT or GLOBAL, NOT SPECIFIED is printed on the report. 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.

Note that GLOBAL FROM and TO filters individual DB2® Statistics records whereas REPORT FROM and TO filters interval records. For example, with a REPORT FROM time of 14:15, an interval record starting at 14:00 and ending at 14:30 would appear on thereport (based on the end interval record time). However, a GLOBAL FROM time of 14:15 would filter the DB2 Statistics records at 14:00 and the interval record (14:00 to 14:30) might not be created (subject to the BOUNDARY specification).

You can specify a time adjustment for a DB2 location using the TIMEZONE option of the GLOBAL command. The time adjustment is applied to the record timestamp before FROM/TO processing.

If you are reducing data, the FROM/TO times specified in REDUCE can affect the data available for reporting.

Refer to GLOBAL command for more information.

For details on how to use the FROM/TO option, see FROM/TO subcommand options.

LAYOUT
Specifies the name of a report layout. You can specify one of the supplied layouts or one that you have previously tailored:
SHORT
This is the default.
LONG
This option provides detailed thread-related data. You can also use other functions such as Record Trace and SQL Activity to find detailed DB2 trace data.
Historical Reporter migration layouts
Use the Historical Reporter migration layouts to help you identify OMEGAMON® for DB2 PE data that was previously shown in the reports of the OMEGAMON Historical Reporter. The migration layouts include:
User-defined layouts
You can customize your own report layouts by specifying which blocks of data and which fields within the blocks are included, and their relative order. To adapt the reports according to your requirements, you use user-tailored reporting (UTR). With UTR, you can control the volume, contents, and layout of Statistics traces and reports.

For information about tailoring report layouts, see the Reporting User's Guide.

SCOPE
Specifies the scope of the report in a data sharing environment.
MEMBER
Member-scope reporting presents DB2 statistics on a per-member basis without aggregating data-sharing-related counters for the entire data-sharing group.
GROUP
Group-scope reporting presents data-sharing-related counters for an entire data-sharing group.
EXCEPTION
NOEXCEPTION
Specify EXCEPTION if you want to report only those interval records on Statistics reports with at least one field in exception status. Otherwise, a standard report is produced.

If you use this subcommand option, your JCL must contain a valid DD definition for the ddname EXCPTDD. For more information about required ddnames, see Figure 1.

DDNAME
Specifies the data set where the report is written. You can specify any valid ddname including the default, provided that your JCL contains a DD statement for it. If a DD statement is omitted, it will be dynamically allocated to the SYSOUT message class of the job. The default ddname for report is STRPTDD.
ORDER(INTERVAL)
Specifies that your report contains statistics data for each interval record that satisfies input filters.

For details, see ORDER subcommand option and OMEGAMON for Db2 PE identifiers.

If you want to report the statistics data for the entire period covered by the interval records, do not specify this option.

INCLUDE/EXCLUDE
Includes or excludes data associated with specific OMEGAMON for DB2 PE identifiers.

For details, see INCLUDE and EXCLUDE subcommand options, which lists other identifiers allowed with this command and subcommand combination, and OMEGAMON for Db2 PE identifiers.

DSETSTAT
Include buffer pool data set statistics. This option is ignored if option INTERVAL(X) with X>0 has been specified. Statistics interval processing with intervals > 0 can only be applied to IFCIDs 1, 2, 225, and 369 that are externalized by DB2 every minute. IFCID 199 externalization is controlled by system parameter STATIME and can range from 1 to 60 minutes. Interval metrics for buffer pool data sets can be derived from Statistics TRACE or FILE data created with DSETSTAT.

Example using REDUCE, and REPORT with INCLUDE option

This example specifies the following:
  • One interval record is derived. It covers the entire period that the DB2 statistics data is available for.
  • The report uses the default SHORT layout.
  • Data is included that is only associated with the location in the range of LOCN01 to LOCN05
REDUCE
REPORT
   INCLUDE (LOCATION(R(LOCN01 LOCN05)))

Example using REDUCE with INTERVAL option, and REPORT with several options

This example specifies the following:
  • The input DB2 statistics data is distributed over 60-minutes intervals aligned with hour boundaries.
  • The interval records between 10:00 a.m. on 18 March 1996 and noon on 19 March 1996 are considered for reporting, subject to the exception criteria.
  • Each of the qualifying interval records is reported.
  • The report uses the LONG layout.
REDUCE
   INTERVAL(60)
REPORT
   FROM    (09/18/98,10:00:00.00)
   TO      (09/19/98,12:00:00.00)
   LAYOUT  (LONG)
   EXCEPTION
   ORDER   (INTERVAL)