This example shows how to stop a delayed request on SessionNo 1011.
SELECT TDWM.TDWMAbortDelayedRequest(HostId, SessionNo, RequestNo, 0) FROM TABLE (TDWMGetDelayedQueries('O')) AS t1 WHERE SessionNo=1011; *** Query completed. One row found. One column returned. *** Total elapsed time was 3 seconds. TDWMAbortDelayedRequest(HostId,SessionNo,RequestNo,0) ----------------------------------------------------- 0
The request on SessionNo 1011, if delayed, is stopped as follows:
SELECT DatabaseName FROM dbc.databasesv; *** Starting at Tue Apr 26 15:22:42 2005 *** Failure 3151 TWM Workload violation: Delay Request Change Abort Statement# 1, Info =0