15.10 - TDWMApply - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Applies changes to one or more of the Teradata dynamic workload management software categories.

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 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
  • Notice:

    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.

    CALL TDWM.TDWMApply (200, 'Y', 'N', 'N', 'N');