INTERVAL_UNITS
Use the INTERVAL_UNITS parameter in CQM@WDB2 to control the offload of data to the Performance History Database.
- Description
- The method by which intervals are selected for offloading. The INTERVAL_UNITS parameter works with the STARTING_INTERVAL and ENDING_INTERVAL parameters to define the method and range of intervals to be offloaded. If you specify INTERVAL_UNIT(DAYS), Db2 Query Monitor only considers the interval start date/time (not the interval end date/time) when determining whether or not the interval is to be included in the offload. Thus, every interval that starts between the computed offload start date and offload end date is offloaded, regardless of when the intervals end.
- Syntax
- INTERVAL_UNITS(INTERVALS|DAYS)
- Default
- INTERVALS
- Valid values
-
- INTERVALS
- (Default) Offload all intervals within the specified range of intervals (defined by the STARTING_INTERVAL and ENDING_INTERVAL parameters).
- DAYS
- Offload all intervals that started within the specified range of days (defined by the STARTING_INTERVAL and ENDING_INTERVAL parameters).
- Example
- If INTERVAL_UNITS(DAYS) is specified with STARTING_INTERVAL(-1) and ENDING_INTERVAL(-1), this causes all intervals that have started between midnight of the previous day and midnight of the day before to be offloaded.