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
- Throttle type. 'C', 'I', and 'M' are mutually exclusive.
- 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.