TDWMAbortDelayedRequest Function | Application Programming Reference | Vantage - TDWMAbortDelayedRequest - Advanced SQL Engine - Teradata Database

Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
cpn1571792172880.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Aborts a request or utility session on the Teradata dynamic workload management software delay queue.

Definition

REPLACE FUNCTION TDWM.TDWMAbortDelayedRequest
  (HostId      SMALLINT,
   SessionNo   INTEGER,
   RequestNo   INTEGER,
   WDId        INTEGER
   )
RETURNS INTEGER
          .
          .
          .
;

Input Parameters

Input Parameter Description
HostId Host ID for the session.
SessionNo Number of the session.
RequestNo Request number of the task.

If the value is zero, the utility session is aborted.

WDId WD ID for the request in the delay queue being examined.

Usage Notes

The TDWMAbortDelayedRequest function provides similar functionality to a TDWM DELAY REQUEST CHANGE request. For more information, see TDWM DELAY REQUEST CHANGE.

Return Value

This function returns a zero if it is successful.

Example: Using TDWMAbortDelayedRequest

This example shows how to abort 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

Assuming the request on SessionNo 1011 was delayed, it is aborted 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