TDWMGetDelayedUtilities Syntax Elements - 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
- 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.