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 ) . . . ;
|RuleSetId||Rule set in which the rule is found.|
|RuleName||Name of the rule specified.|
|TDWMLock||Type of request performed on 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);