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

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

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