STARTING_INTERVAL

Use the STARTING_INTERVAL parameter in CQM@WDB2 to control the offload of data to the Performance History Database.

Description
The start point (relative to the current interval, current day, or an absolute interval number) for the data that are to be loaded into Db2 tables.
Syntax
STARTING_INTERVAL(n)
n
Indicates the interval at which you want to start loading data into Db2® tables.
  • The STARTING_INTERVAL and ENDING_INERVAL must both either be positive or negative.

  • Negative numbers are relative to the current interval.

  • The value you specify for ENDING_INTERVAL must be less than or equal to the value you specify for STARTING_INTERVAL.

Default
-1
Range
Non-zero integers in the range -99999 to 99999
Example 1
INTERVAL_UNITS(DAYS),
STARTING_INTERVAL(-2),
ENDING_INTERVAL(-5)
Example 2
INTERVAL_UNITS(INTERVALS),
STARTING_INTERVAL(100),
ENDING_INTERVAL(10)