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 to create the throttle. 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.