INTERVAL
Use the INTERVAL parameter in CQMPARMS to control the interval recording behavior of your Query Monitor subsystem.
- Description
- The length of time in minutes (n) that Db2 Query Monitor holds SQL performance data in memory before writing it to performance history files.
- Syntax
- INTERVAL(n)
- Default
- 720
- Range
- Integers in the range 1 - 99999
- Example
- INTERVAL(20)