Defining Enforcement Priorities - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
17.00
Published
September 2019
Language
English (United States)
Restricted Access
TTU-17.00-EAP
Last Update
2019-06-07
dita:mapPath
vjd1544831946946.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2514
Product Category
Teradata Tools and Utilities
  1. Select Rule Set > Workload to AG Mapping. The Set Enforcement Priority dialog box appears.
  2. In the Set Enforcement Priority dialog box, click the workload to be modified and drag it to the enforcement priority row. To hide workloads that have already been assigned enforcement priorities, click the Show Only Unassigned Workloads check box. The following table describes the available mapping options:
    Option Description
    State Displays the state of the system. State is a composite of system condition and operating environment. The default state is Base, which represents the mapping of Normal and Always.
    Category of Work With this option selected, Teradata WA recommends standard resource partition and allocation group weights. Click Reload if this option is reset.
    Subject Area Resource Division Select this option if RP weights are already defined and Teradata WA will recommend only allocation group weights. Click Reload if this option is reset.
    This option is not available if the workloads are Tactical or Priority.
    RP Name The name of the resource partition automatically applied to the workload.
    RP Weight The RP weight allocated to the workload. This cannot be changed without changing the enforcement priority.
    AG Name The name of AG applied to the workload.
    AG Weight The AG weight allocated to the workload. This cannot be changed without changing the enforcement priority.
    Relative Weight The relative weight associated with the workload. This can be changed without changing the enforcement priority.
    Enforcement Priority Displays the currently assigned enforcement priority for the selected workload. To change the assignment, click Change Enforcement Priority and modify the Set Enforcement Priority dialog box.
    Assigned Workloads Displays the names of the workload associated with the enforcement priority. Note that more than one workload can be allocated to a particular enforcement priority and allocation group.
  3. After making the appropriate changes, click OK. This causes the Workload-Allocation Group Mapping dialog box to appear, where the method of priority-setting can be selected and the resource partitions and allocation groups can be modified.
  4. View the displayed values. To display the default RP information in the dialog box, click the Show Default RP check box.
  5. Click OK.
    The enforcement priority for a workload can be modified from the Attributes dialog box under Candidate Workloads.