TDWMGetDelayedQueries 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
- RequestType
- Request type:
- O = Return the system query or system session delay queue.
- W = Return the workload delay queue.
- A = Return queries on the Delay and Defer queue.
- M = Return queries on the Defer queue only.
- Username
- Logon user name of session.
- HostId
- Host ID of the session number for the delayed request.
- SessionNo
- Session number for the held request.
- RequestNo
- Request number for the delayed request.
- RuleName
- Rule name identified in the Rule ID field.
- RuleId
- Rule ID for the workload or the system query or system session throttle rule that caused the query to be delayed or the rule ID for an arrival rate meter that caused the query to be deferred.
- TotalTimeHeld
- Total number of wall clock seconds that this request or session has been held.
- BlockingCnt
- Count of the number of consecutive times that this request has been identified as blocking at least one other session.
- The value is zero if Request Flag is 6.
- 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, the request or session is overridable.
- If the value is N, the 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.
- PEId
- PE VPROC ID which initiated this request.
- WDDelayed
- Indicator that the request is delayed for a workload rule.
- A value of zero indicates the values 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 query or system session 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
- 5 = Resource Limit (AWT or Memory)
- 6 = Arrival Rate Meter
- GroupDelayed
- Whether Query is delayed for a workload group throttle: 1 (yes) or 0 (no).
- This field is only valid on monitor version software ID 10 or later.
- FlexEligible
- The delayed request that is in a workload and is tagged as eligible for the Flex Throttle feature. Flagged requests must meet all requirements for Flex Throttles before being released, such as system throttle restrictions.
- 0 = Flex eligible
- 1 = Not Flex eligible
- MeterDeferred
- Output parameter. Indicator of a request being deferred for an arrival rate meter.
- 0 = Query is not deferred
- 1 = Query is deferred