TDWMGetDelayedUtilities Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
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 stopped or released by the administrator. A session that exceeds the internal AMP worker task limit cannot be released. A delayed session can be stopped.
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 that exceeds the internal AMP worker task limit or an internal utility limit cannot be released.
A delayed session can 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.