TDWM.RuleInfoV Syntax - Teradata VantageCloud Lake

REPLACE VIEW TDWM.RuleInfoV 
  (RulesetName,
   RuleId,
   RuleName, 
   RuleType,
   RuleStatus,
   RuleAttributes,
   RuleDescription

   )  AS
SELECT 
  ...

Syntax Elements

RulesetName

Ruleset name.

RuleId

Rule ID.

RuleName

Rule 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

RuleStatus

Indicates if a rule is enabled or disabled. Possible values:

• 'E': Enabled
• 'D': Disabled

RuleAttributes

Multiple attributes can be returned. Possible values:

• If RuleType is 'Meter', then
  • 'C': Collective
  • 'D': Disable manual release or abort
  • 'L': Log only (warning mode)
• If RuleType is 'Filter', then
  • 'L': Log only (warning mode)
  • Blank: Reject if qualified
• If RuleType is 'System Throttle', then
  • 'C': Collective
  • 'I': Individual
  • 'M': Member
  • 'D': Disable manual release or abort

  'C', 'I', and 'M' are mutually exclusive.

• If RuleType is another value, then
  • 'C': Collective

RuleDescription

Description of a rule.