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