Meters limit the number of user queries that can run at the given time interval, by rejecting them or putting them in a deferred queue. Classification determines which queries are associated with a Meter. Teradata Database detects classification criteria before executing queries.
Enabling the Dictionary data collector in the Monitored Systems portlet makes sure the lists of usernames in the Classification tab are current. If the collector is not enabled, enter usernames manually by entering a match string and selecting Include.
- Edit or Create a ruleset.
- From the ruleset toolbar, select Meters
- Select a meter or create one.
- Select the Classification tab.
- In the Add Classification Criteria list, select one of the following:
Classification Type Description Request Source Where the query comes from Target Where the query is actioned on Query Characteristics What the query is composed of Query Band What metadata is attached to the query Utility Which utility submitted the query - Select Add.
- Specify options based on the classification options selected.
- 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 a ? to match exactly one character or an * 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 and select Ok.
- [Optional] To add additional classification criteria:
- Select the criteria from the Add Classification Criteria list.
- Select Add
- Specify the items to include or exclude, and select Ok.
For Teradata Database version 15.10 or later, if both Username and Profile is set as a request source combination, 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.