Setting Classification for Workloads

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
Workloads group queries so that a set of workload management controls can be applied to the group. Classification determines which queries are associated with a workload. Teradata Database detects classification criteria before executing queries.

You cannot add additional classification options to any of the default workloads.

Enabling the Dictionary data collector in the Monitored Systems portlet makes sure the lists of usernames in the Classification tab is current. If the collector is not enabled, you can enter usernames manually by entering a match string and clicking Include.

  1. Edit or create a ruleset.
  2. From the ruleset toolbar, click Workloads.
  3. Select or create a workload.
  4. Click the Classification tab.
  5. In the Add Classification Criteria list, select one of the following:
    Classification Type Description
    Request Source Where the query comes from
    Target What the query is acting on
    Query Characteristics What the query is composed of
    Query Band What metadata is attached to the query
    Utility Which utility submitted the query
  6. Click Add.
  7. Specify options based on the classification options you selected.
  8. For Request Source or Target, do at least one of the following:
    • Enter a match string and use the Include and Exclude buttons to add the match string. A match string can contain ? to match exactly one character or * to match zero or more characters.
    • Select items from the list and use the Include and Exclude buttons to create your classification criteria. If there are more than 500 items, use the filter box to locate the items you want to select.
  9. Click OK.
  10. [Optional] To add additional classification criteria:
    1. Select the criteria from the Add Classification Criteria list.
    2. Click Add.
    3. Specify the items you want to include or exclude.
    4. Click OK.
    For Teradata Database version 15.10 and later, if you set both Username and Profile as a request source combination, you can choose AND or OR logic. If you set any other classification criteria or request source type combination, the additional criteria are evaluated using AND logic.
  11. Click Save.