TDWMCreateArrivalRateMeter | Application Programming Reference | Vantage - TDWMCreateArrivalRateMeter - Advanced SQL Engine - Teradata Database

Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
hvk1593628831140.ditamap
dita:ditavalPath
hvk1593628831140.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantage™

Creates an arrival rate meter without any qualification criteria in one or all existing rulesets.

Syntax

REPLACE PROCEDURE TDWM.TDWMCreateArrivalRateMeter (
  IN RulesetName TD_ANYTYPE,
  IN ArrivalRateName 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 arrival rate meter will be created. Use ‘ALLRULESETS’ to create the meter in all existing rulesets. Cannot be null and its length must be between 1 and 30.
ArrivalRateName
Name of the arrival rate meter to be created. The specified name must be unique among all existing TASM rules: throttles, arrival rate meters, workloads, filters, and so on. The name cannot be null and its length must be between 1 and 30 characters.
Description
Description of the arrival rate meter.
Attributes
See Teradata Vantage™ - Workload Management User Guide for detailed descriptions of these attributes. Attributes can be combined.
  • Throttle type:
    • 'C' = collective
  • Disabling override:
    • 'D' = disable manual release or abort
  • Logging Only (warning):
    • 'L' = Only log a warning instead of delay or reject
ReplaceOption
  • 'Y' = Delete the specified arrival rate meter and recreate it. If the specified arrival rate meter does not exist, an error is returned.
  • 'N' = Create a new arrival rate meter. If the specified arrival rate meter exists, an error is returned.