INTERVAL_MIDNIGHT

Use the INTERVAL_MIDNIGHT parameter in CQMPARMS to control the interval processing behavior of your Query Monitor subsystem.

Description

Aligns interval start times to midnight. If an interval of eight hours is specified and Db2® Query Monitor is started at 2 a.m., the first interval will end at 8 a.m. then the next interval will end at 4 p.m. and the final interval of the day will end at approximately midnight (the calculated time may differ from midnight by a few seconds, for example, 23:59:58 instead of 00:00:00). For example, if a 5 hour interval is specified the interval end times will be at approximately 5 a.m., 10 a.m. 3 p.m., 8 p.m. (the calculated times may differ from the exact hour by a few seconds, for example 4:59:58, 9:59:58, 14:59:58, 19:59:58) then the cycle continues. The interval cutting occurs relative to midnight only after the Query Monitor subsystem is restarted.

Syntax

INTERVAL_MIDNIGHT(Y|N)

Default

Y

Valid values

Y

(Default) Aligns interval start times to midnight.

N

Does not align interval start times to midnight.

Example

INTERVAL_MIDNIGHT(Y)