TDWMGetDelayedUtilities Function | Application Programming Reference | Teradata Vantage - TDWMGetDelayedUtilities - Teradata Vantage - Analytics Database

Application Programming Reference
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
qld1628112131956.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ajo1472244909562
lifecycle
latest
Product Category
Teradata Vantage™

Returns the utility delay queue.

Syntax

REPLACE FUNCTION TDWM.TDWMGetDelayedUtilities (
) RETURNS TABLE (
    Username       VARCHAR(128)CHARACTER SET UNICODE,
    HostId         SMALLINT,
    SessionNo      INTEGER,
    TotalTimeHeld  INTEGER,
    OverRidable    CHAR CHARACTER SET LATIN,
    PEId           INTEGER,
    RequestNum     INTEGER,
    WDDelayed      INTEGER,
    ObjDelayed     INTEGER,
    UtilDelayed    INTEGER,
    RuleType       INTEGER
    RuleName       VARCHAR(128) CHARACTER SET UNICODE
  )
  ...
;

Syntax Elements

Username
User name of the session.
HostId
Host ID of the session number for the delayed utility.
SessionNo
Session number for the held utility.
TotalTimeHeld
Total number of wall clock seconds that this request has been held.
OverRidable
Request or session allowed to be aborted or released by the administrator. A session cannot be released if it exceeds the internal AMP worker task limit. A delayed session can always be aborted.
If the value is Y, this request or session is overridable.
If the value is N, this request or session is not overridable.
The queue table requests are controlled internally by the database and cannot be altered by the administrator.
If Request Flag is 6, this field indicates if the delayed session can be released. A session cannot be released if it exceeds the internal AMP worker task limit or an internal utility limit.
A delayed session can always be aborted.
RuleId
ID of the rule that caused this query to be delayed.
RequestNum
Request number for the held utility.
WDDelayed
Indicator that the request is delayed for a workload rule.
A value of zero indicates the request is not delayed because of a workload throttle.
ObjDelayed
Indicator that the request is delayed for a system query or system session throttle rule.
A value of zero indicates the request is not delayed because of a system throttle.
UtilDelayed
Indicator that the request is delayed for a Utility rule.
A value of zero indicates the request is not delayed because of a utility throttle.
RuleType
Rule type for the request:
  • 0 = Workload
  • 1 = System
  • 2 = Utility
  • 3 = Workload group
  • 4 = Virtual Partition
RuleName
Rule name identified in the Rule ID field.

Example: Using TDWMGetDelayedUtilities

SELECT * FROM TABLE (TDWM.TDWMGetDelayedUtilities()) AS t1;

Result:

 *** Query completed. 4 rows found. 6 columns returned.
 *** Total elapsed time was 1 second.
Username HostId SessionNo  Total TimeHeld  OverRidable  RuleId
-------- ------ ---------  --------------  -----------  ------
USER1         1      2709              16            0       1
USER1         1      2710              12            0       2
USER1         1      2711               9            0       3
DBC           1      2712               5            0       4