Reducing data

Use the REDUCE subcommand to consolidate records with certain common characteristics into a single record.

You can limit the range of records by date and time. You can specify multiple ranges of time. This can be useful for monitoring peek-time performance, for example.

Within a specified time range, you can specify the interval at which records are consolidated.

The start time of the first interval that is processed by REDUCE is influenced by BOUNDARY, INTERVAL, and FROM.

OMEGAMON for Db2 Performance Expert attempts to reduce all data that falls between FROM and TO dates and times. The first interval starts at a time aligned with BOUNDARY, at or before the FROM time. If an interval cannot be aligned with the FROM time, the first properly aligned interval starting before the FROM time is used.

Although there is no restriction on the INTERVAL and BOUNDARY combination, your specification should comply with the following rules:

• For intervals of less than 60 (excluding 0), there should be a whole number of intervals in an hour. Choose one of the following values:
  • 1, 2, 3, 4, 5, 6, 10, 12, 15, 20, or 30
• For intervals of 60 or greater, there should be a whole number of intervals in a day. Choose one of the following values:
  • 60, 120, 180, 240, 360, 480, 720, or 1440
• For intervals of one day (1440) or greater, INTERVAL should be a multiple of 1440.
• Select your interval and boundary so that the first interval starts at the FROM time.