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