ACCOUNTING command with REDUCE subcommand

This section describes the ACCOUNTING command with the REDUCE subcommand.

Usage

Use the REDUCE subcommand to reduce the volume of data that is input to the REPORT and SAVE subcommands.

Usage notes

  • REDUCE consolidates records with certain common characteristics into one record.
  • REDUCE can be used once in an ACCOUNTING command.
  • REDUCE is invoked automatically when you use REPORT or SAVE. You must specify REDUCE, however, if you want to:
    • Specify an interval that can be used to order data on Accounting reports.
    • Produce several reports with different time spans.
    • Define the interval and input filters for SAVE. SAVE does not have its own FROM and TO, and INCLUDE or EXCLUDE filters. Instead, it uses REDUCE FROM and TO, and INCLUDE or EXCLUDE filters.
  • In most cases, the reduced records contain totals of the values from the individual records. In some cases, the reduced records contain maximum values.

Syntax of the REDUCE subcommand

Read syntax diagramSkip visual syntax diagram REDUCE FROM/TO blockINTERVAL(0minutes)BOUNDARY(60minutes0)CALCULATEINCLUDE/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 interval of time that accounting data is summarized for. 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.
CALCULATE
Indicates that a calculation of consumed or required ACWORK has to be done during the reduction of data for an Accounting REPORT or SAVE function.

For details, see the Reporting User's Guide.

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.

Some care is needed when using PLANNAME as a filter in a DDF environment, see Special considerations for DDF trace data.

Example using REDUCE

This example requests the following:
  • Reduce the input data on daily intervals.
  • Report the Accounting data by intervals.
  • Write the report to the data set defined by the default ddname ACRPTDD.
⋮
ACCOUNTING
  REDUCE
    INTERVAL(1440)
  REPORT
    ORDER (INTERVAL)
⋮