Mappings for Console Utilities | Teradata Vantage - Mappings for Console Utilities - Analytics Database - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
Teradata Vantage
Console utilities, such as ScanDisk and CheckTable, do not log on or behave like SQL requests. For example, CheckTable does not log on, so there is no user associated with a CheckTable job. Because of these differences, TASM does not assign console utilities to workloads automatically. The Console Utilities tab on the Workloads view of Viewpoint Workload Designer allows you to assign console utilities to the appropriate workload.
Console Utility to Workload Mapping
Lists each console utility, and you can specify a workload to apply it to. By default, the console utility runs in that workload.
Performance Group to Workload Mapping
Lists each legacy performance group (H, L, M, and R), and you can choose the workload name to apply it to. The console utility runs in this workload when the user sets the utility to run in the performance group using the priority statement. For example Priority = H.
These settings have the following order of precedence with respect to console utilities:
  • If a priority is specified, the utility runs under the workload specified for that priority in Performance Group to Workload Mapping.
  • If no priority is specified, the utility runs under the workload specified in Console Utility to Workload Mapping.
  • If no workload is specified, the utility runs under the WD-Default workload.

Under most circumstances, console utilities are considered Timeshare Low or Timeshare Medium work. The Query Session console utility, however, is given medium or high priority because it is interactive. The increased priority may be beneficial because DBAs often use Query Session to look at active sessions when a system is resource-constrained.