15.10 - TDWMSetLimits - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

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

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

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
  • Note: 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.

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