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:
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);