STARTING_INTERVAL
Use the STARTING_INTERVAL parameter in CQM@WDB2 to specify the start point for the data that is to be loaded into the performance history database.
- Description
- The start point (relative to the current interval, current day, or an absolute interval number) for the data that is to be loaded into Db2® tables.
If you specify an absolute interval number for STARTING_INTERVAL, STARTING_INTERVAL_TIMESTAMP must also be specified.
- Syntax
- STARTING_INTERVAL(n)
- n
- 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.
-
For negative values, 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)
STARTING_INTERVAL_TIMESTAMP(07/03/2025-12:00:00.004731)
ENDING_INTERVAL(10)
ENDING_INTERVAL_TIMESTAMP(06/28/2025-00:00:00.002887)