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)