Creating a Query Session - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
A query session limits the number of sessions that can be logged on at one time. After the query session is created, additional controls in the Query Sessions tab allow you to clone, delete, enable, or disable the query session. View all created query sessions on the Query Sessions by State tab.
  1. Edit or create a ruleset.
  2. From the ruleset toolbar, click Sessions.
  3. Click the Query Sessions tab.
  4. Next to Query Sessions, click .
  5. Enter a name.
  6. [Optional] Enter a description.
  7. Select a Rule Type from the list:
    • Select Collective if you want all users that meet the classification criteria treated as a group, with the group allowed a maximum number of queries.
    • Select Individual if you want to apply limits to each user individually.
    • Select Member if you want accounts or profiles that represent user groups used as the classification criteria for the rule. Limits are placed on individuals in the group and no limit is placed on the account or group.
  8. Click Save.
  9. Click the Classification tab.
  10. Add classification criteria.
  11. Click OK.
  12. Click Save.
  13. Click the State Specific Settings tab.
  14. Click a state to set a session limit.
  15. Click OK.
  16. Click Save.