Setting Classification for Resource Limits - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem
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 Throttles.
  3. Click the Resource Limits tab.
  4. Select a resource limit or create one.
  5. Click the Classification tab.
  6. In the Add Classification Criteria list, select Request Source or Query Band.
  7. Click Add.
  8. Specify options based on the classification criteria you selected.
    Option Description
    Request Source Select the source type and do 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.
    Query Band
    1. Select a predefined query band name from the list.
    2. Select a Previously Used Value or enter a New Value.
    3. Use the Include and Exclude buttons to create your classification criteria.
  9. [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.
  10. Click OK.
  11. Click Save.