TDWMSetLimits Function | Application Programming Reference | Teradata Vantage - TDWMSetLimits - Advanced SQL Engine - Teradata Database

Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
cpn1571792172880.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Updates the system query or system session throttle limits of a rule in the TDWM database.

Definition

REPLACE PROCEDURE TDWM.TDWMSetLimits
     (IN RuleSetId     INTEGER,
      IN RuleName      TD_ANYTYPE,
      IN TDWMLock      VARCHAR(1) CHARACTER SET LATIN,
      IN SessionLimit  INTEGER,
      IN QueryLimit    INTEGER,
      IN UtilityLimit  INTEGER
     )
               .
               .
               .
;

Input Parameters

Input Parameters Description
RuleSetId Rule set in which the rule is found.
RuleName Name of the rule specified.
TDWMLock Type of request performed on the TDWMLock table:
  • W = Wait for the TDMWLock
  • A = Abort if the TDWMLock table is locked
  • S = Perform the update without locking the TDWMLock table
The TDWM database places an exclusive lock on the TDWMLock table at startup.
SessionLimit Maximum number of concurrent sessions. NULL indicates that the field is not changed.
QueryLimit Maximum number of concurrent queries. NULL indicates that the field is not changed.
UtilityLimit Maximum number of concurrent utilities. NULL indicates that the field is not changed.

Example: Using TDWMSetLimits

CALL TDWM.TDWMSetLimits(1, 'throttle1', 'A', NULL, 10, NULL);