There were queries running longer than 9999 seconds = 02h 46m 39s, so simply increase the interval.
When you check the source for dbc.qryLogV you will notice a column named ElapsedTime which is calculated as ((firstresptime - starttime) hour(4) to second).
And then your condition will be
WHERE ElapsedTime <= INTERVAL '30' SECONDS
Thank u so much.Really helpful!!
but what if i write this
LOCKING ROW FOR ACCESS
WHERE CollectTimeStamp between '2014-06-01 00:00:00' and '2014-06-30 23:59:59'
and ((FIRSTRESPTIME - FIRSTSTEPTIME) hour(4) to second ) <= 30;
(as i want execution time)
but its not running saying select failed 5407: invalid operation date time or interval.
or i should add it in view another column ((FIRSTRESPTIME - FIRSTSTEPTIME) hour(4) to second ) (Named ExecutionTime ) ??
You can't compare an HOUR TO SECOND interval to an INTEGER. What is 30 supposed to be. hours, minutes or seconds?
((FIRSTRESPTIME - FIRSTSTEPTIME) hour(4) to second ) <= INTERVAL '30' SECOND;