IOACTIVITY command with REDUCE subcommand

This section describes the IOACTIVITY command with the REDUCE subcommand.

Usage

Use the REDUCE subcommand to reduce the volume of data that is input to subsequent subcommands. REDUCE consolidates records with certain common characteristics into one record.

Usage notes

  • You can specify REDUCE only once in an IOACTIVITY command.

Syntax of the REDUCE subcommand

Read syntax diagramSkip visual syntax diagramREDUCEFROM/TO blockINTERVAL(0minutes)BOUNDARY(60minutes0)INCLUDE/EXCLUDE block

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 records included in the reduction process by date and time.

For details, see FROM/TO subcommand options.

INTERVAL
Defines the time interval for consolidating and averaging records. Note the remarks about performance impact in INTERVAL subcommand option .
BOUNDARY
Controls the alignment of the intervals used to summarize records in the reduction process.
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.

Example using REDUCE with REPORT

This example specifies the following:
  • Reduce only input data with a timestamp within the time range of 10:00 to 11:00 on 14 May 2002.
  • Create a summary report (the default) with the default order of PLANNAME within PRIMAUTH
  • Write the report to the data set defined by the default ddname IORPTDD. 
IOACTIVITY
  REDUCE
    FROM (05/14/02,10:00:00.00)
    TO   (,11:00:00.00)
  REPORT