TDWMCreateArrivalRateMeter | Application Programming Reference | Vantage - 17.10 - TDWMCreateArrivalRateMeter - 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 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.