TDWMApply Function | Application Programming Reference | Teradata Vantage - TDWMApply - Advanced SQL Engine - Teradata Database

Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
cpn1571792172880.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantageā„¢

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