Applies changes to one or more of the Teradata dynamic workload management software categories.
Syntax
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 ) ... ;
Syntax Elements
- RuleSetID
- ID of the rule set to apply. This must be the current rule set.
- FilterCat
- Request for the Filters rule category:
- Y = Apply changes to the rule category
- N = Skip this rule category
- ThrottleCat
- Request for the system query or system session limits rule category:
- Y = Apply changes to the rule category
- N = Skip this rule category
- WorkloadCat
- Request for the workloads rule category:
- Y = Apply changes to the rule category
- N = Skip this rule category
- EventCat
- Request for the Event category:
- Y = Apply changes to the category
- N = Skip this category
Usage Notes
Do not issue TDWMApply while holding locks on any TDWM database tables. This causes a self-deadlock condition because the 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');