TDWMCreateSystemThrottle | Application Programming Reference | Vantage - 17.10 - TDWMCreateSystemThrottle - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Creates a system throttle without any qualification criteria in one or all existing rulesets.

Syntax

REPLACE PROCEDURE TDWM.TDWMCreateSystemThrottle (
  IN RulesetName TD_ANYTYPE,
  IN ThrottleName TD_ANYTYPE,
  IN Description TD_ANYTYPE,
  IN Attributes VARCHAR(20) CHARACTER SET LATIN,
  IN ReplaceOption CHAR(1) CHARACTER SET LATIN
)
  ...
;

Syntax Elements

RulesetName
Name of the ruleset in which the throttle will be created. Use ‘ALLRULESETS’ to create the throttle in all existing rulesets. Cannot be null and its length must be between 1 and 30.
ThrottleName
Name of the throttle to be created. The specified name must be unique among all existing TASM rules: throttles, arrival rate meters, workloads, filters, and so on. Length must be between 1 and 30.
Description
Description of the throttle. This can be null. Maximum length is 80.
Attributes
See Teradata Vantage™ - Workload Management User Guide for detailed descriptions of these attributes. Attributes can be combined.
  • Throttle type. 'C', 'I', and 'M' are mutually exclusive.
    • 'C' = collective
    • 'I' = individual
    • 'M' = member
  • Disabling override:
    • 'D' = disable manual release or abort
ReplaceOption
  • 'Y' = Delete the specified throttle and recreate it. If the specified throttle does not exist, an error is returned.
  • 'N' = Create a new throttle. If the specified throttle exists, an error is returned.