TDWM.RuleStateLimitV Syntax - 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
REPLACE VIEW TDWM.RuleStateLimitV 
  (RulesetName,
   RuleId,
   RuleName, 
   RuleType,
   RuleStateId,
   RuleStateName,
   RuleStateLimit,
   RuleStateAction,
   RuleStateLimitDesc
   )  AS
SELECT 
  ...

Syntax Elements

RulesetName
Ruleset name.
RuleId
Rule ID or workload ID.
RuleName
Rule name or workload name.
RuleType
Rule type. Possible values:
  • 'Filter'
  • 'Meter': Arrival rate meter
  • 'System Throttle'
  • 'Utility Limit'
  • 'Utility Session'
  • 'Workload'
  • 'Session Throttle'
  • 'Workload Group'
  • 'VPartition Throttle': Virtual partition throttle
  • 'Res Limit - AWT': AWT resource limit
RuleStateId
ID of rule state.
RuleStateName
Name of rule state.
RuleStateLimit
Limit of a specific rule state. Possible values depend on RuleType. Possible values:
  • 'Filter': NULL
  • 'Meter': Maximum query admission rate
  • 'System Throttle': Maximum concurrent queries
  • 'Utility Limit': Maximum concurrent utility jobs
  • 'Utility Session': Number of utility sessions
  • 'Workload': Maximum concurrent queries in a workload
  • 'Session Throttle': Maximum concurrent sessions
  • 'Workload Group': Maximum concurrent queries in a workload group
  • 'VPartition Throttle': Maximum concurrent queries in a virtual partition
  • 'Res Limit - AWT': Maximum percentage of total AWTs
RuleStateAction
Action of a specific rule state. Possible values depend on RuleType.
  • 'Filter'
    • 'E': Enabled
    • 'N': Disabled
  • Other rule types:
    • 'D': Delay
    • 'R': Reject