16.20 - TDWMGetDelayedUtilities - Teradata Vantage NewSQL Engine

Teradata Vantage™ Application Programming Reference

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1090-162K

Purpose

Returns the utility delay queue.

Definition

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
   )
              .
              .
              .
;

Result Rows

Column Name Description
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;
 *** 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