TDWMReleaseDelayedRequest Function | Application Programming Reference | Vantage - TDWMReleaseDelayedRequest - 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

Releases a request or utility session in the Teradata dynamic workload management software delay queue.

Definition

REPLACE FUNCTION TDWM.TDWMReleaseDelayedRequest
   (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.

A value of zero indicates the utility session is released.

WDId WD ID for the request in the delay queue being acted on.

Usage Notes

The TDWMReleaseDelayedRequest function provides similar functionality to a TDWM DELAY REQUEST CHANGE request. For more information about this interface, see TDWM DELAY REQUEST CHANGE.

When issuing this Teradata dynamic workload management software function, it must be qualified by the database name, TDWM (see examples below).

Return Value

This function returns a zero if it is successful.

Example: Using TDWMReleaseDelayedRequest to Release a Delayed Request

SELECT TDWM.TDWMReleaseDelayedRequest(HostId, SessionNo, RequestNo, 0)
 FROM TABLE (TDWMGetDelayedQueries('O')) AS t1
 WHERE SessionNo=4531;
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.
TDWMReleaseDelayedRequest(HostId,SessionNo,RequestNo,0)
-------------------------------------------------------
                                                      0

Example: Using TDWMReleaseDelayedRequest to Release Multiple Delayed Requests

SELECT TDWM.TDWMAbortDelayedRequest(HostId, SessionNo, RequestNo, 0)
 FROM TABLE (TDWMGetDelayedQueries('O')) AS t1
 WHERE t1.Username='TwmUser33';
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.
TDWMAbortDelayedRequest(HostId,SessionNo,RequestNo,0)
-----------------------------------------------------
                                                    0