Is there a way to set queuetimeout at query or session level?
I am trying to limit how long a query runs. So I set SESSION RUNTIMECAP. This works when there is no queue. But if my query enters the queue - it seems like the time it spends in the queue is not considered part of the RUNTIMECAP calculation. Is there a way on a session or query level to limit how long a query is allowed to be in the queue? Or is the only way to do this by defining a separate resource pool with a low (or 0) setting for QUEUETIMEOUT?