TDWMGetDelayedQueries Syntax - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248
REPLACE FUNCTION TDWM.TDWMGetDelayedQueries (
  RequestType VARCHAR(1) CHARACTER SET LATIN
) RETURNS TABLE (
    Username          VARCHAR(128) CHARACTER SET UNICODE,
    HostId            SMALLINT,
    SessionNo         INTEGER,
    RequestNo         INTEGER,
    RuleName          VARCHAR(128) CHARACTER SET UNICODE,
    RuleId            INTEGER,
    TotalTimeHeld     INTEGER,
    OverRidable       CHAR CHARACTER SET LATIN,
    BlockingCnt       INTEGER,
    PEId              INTEGER,
    WDDelayed         INTEGER,
    ObjDelayed        INTEGER,
    UtilDelayed       INTEGER,
    RuleType          INTEGER,
    GroupDelayed      INTEGER,
    FlexEligible      SMALLINT,
    MeterDeferred     INTEGER
  )
  ...
;