RETAIN
Use the RETAIN parameter in CQMPARMS to control the interval retention behavior of your Query Monitor Subsystem.
- Description
- The number of prior intervals (n) that are to be retained on DASD after
interval processing is complete.Note:
- As you specify higher values for the RETAIN parameter, the Query Monitor Subsystem requires greater amounts of storage for the additional intervals retained on DASD.
- The RETAIN parameter indicates the number of completed intervals to retain on DASD.
- You can use the Db2 offload process to keep data that has been collected beyond the retention period specified by the RETAIN parameter.
- 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.
- Syntax
- RETAIN(n)
- Default
- 6
- Range
- Integers in the range 2 - 99999
- Example
- RETAIN(12)