TDWMThrottleStatistics 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
RequestType
Request type:
  • A = Return all throttle statistics.
  • Q = Return statistics for throttled database system queries.
  • S = Return statistics for throttled database system sessions.
  • W = Return statistics for throttled workloads.
ObjectType
Type of object for this statistic:
  • User
  • Account
  • Account String
  • Profile
  • Client
  • Network Address
  • Application
  • Database
  • Table
  • Macro
  • Stored Procedure
  • Workload
  • Utility
  • Collection
  • View
  • Queryband
  • Function
  • Method
  • Virtual partition
  • RESAWT (AWT Resource Limit)
  • Arrival Rate Meter
  • RESMEM (memory resource limit)
RuleId
When this field is a workload, the workload ID.
RuleName
When this field is a workload, the workload name.
ObjectName
For table, macro, stored procedure, view, function, and method object types, this is the name of the qualifying database.
For all other types, this is the name of the object.
See the ObjectType column.
SubName
Name of the table, macro, stored procedure, view, function, or method.
Active
Number of requests active for this object. This is, the number of active queries or sessions depending on the information requested in the input record.
If ObjectType is Arrival Rate Meter, this value is used with TimeUnit to describe the current rate. The current rate is Active/TimeUnit, such as 8 (requests)/minute.
If ObjectType is RESMEM, this value is the current total memory usage, in megabytes, of active requests that qualify for a specific memory resource limit rule.
ThrottleLimit
Current Teradata dynamic workload management software limit on the object.
This is the limit on the number of queries or sessions depending on the information requested in the input record.
A value of -1 indicates that no system query or session throttle limit is defined.
Active and delayed sessions are not valid when the ThrottleLimit value is -1.
If ObjectType is Arrival Rate Meter, this is the arrival rate limit.
If ObjectType is RESMEM, this is the memory limit, in megabytes, for requests that qualify for a specific memory resource limit rule.
Delayed
Number of requests on the delay queue at this time for this object.
If ObjectType is Arrival Rate Meter, this is the number of requests being deferred by the arrival rate meter.
ThrottleType
Type of throttle statistic. Possible values include:
  • Q = Throttled database system query
  • S = Throttled database system session
  • W = Throttled workload
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
TimeUnit
Time unit of the arrival rate meter:
  • H = hour
  • M = minute
  • S = second
CurQualifyTime
Number of seconds in which the current arrival rate has continuously remained at the limit.
ReqQualifyTime
Number of seconds in which the current arrival rate must continuously remain at the limit before new requests are held in the Defer queue.