EMPTY_INTERVALS
Use the EMPTY_INTERVALS parameter in CQMPARMS to control the interval retention behavior of your Query Monitor Subsystem.
- Description
- Indicates whether Db2 Query Monitor keeps or removes empty interval Performance History Files and their corresponding interval records from CQMINTER data set.
- Syntax
- EMPTY_INTERVALS(KEEP|REMOVE)
- Valid values
-
- KEEP
- (Default) Keeps empty interval performance history files and their corresponding interval records.
- REMOVE
- Removes the empty interval performance history files and their corresponding interval records
from the CQMINTER data set. Note: When EMPTY_INTERVALS(REMOVE) and the RETAIN parameter are specified together, Db2 Query Monitor retains n intervals as instructed to by the RETAIN parameter. If any of the retained intervals are empty, they are then deleted.
- Example
- EMPTY_INTERVALS(REMOVE)