Purpose
Applies changes to one or more of the Teradata dynamic workload management software categories.
Definition
REPLACE PROCEDURE TDWM.TDWMApply (IN RuleSetId INTEGER, IN FilterCat VARCHAR(1) CHARACTER SET LATIN, IN ThrottleCat VARCHAR(1) CHARACTER SET LATIN, IN WorkloadCat VARCHAR(1) CHARACTER SET LATIN, IN EventCat VARCHAR(1) CHARACTER SET LATIN ) . . . ;
Input Parameters
Input Parameter | Description |
---|---|
RuleSetID | ID of the rule set to apply. This must be the current rule set. |
FilterCat | Request for the Filters rule category:
|
ThrottleCat | Request for the system query or system session limits rule category:
|
WorkloadCat | Request for the workloads rule category:
|
EventCat | Request for the Event category:
|
Usage Notes
Do not issue TDWMApply while holding locks on any TDWM database tables. This causes a self-deadlock condition because Teradata Database must read the TDWM database tables to perform this apply.
Using the TDWMApply procedure, you can only apply changes to the active rule set.
This procedure activates all rules in the database for the category being applied.
Example: Using TDWMApply
CALL TDWM.TDWMApply (200, 'Y', 'N', 'N', 'N');