Utility Management - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™
To manage load utilities such as FastLoad, MultiLoad, and FastExport, you can classify them into a workload definition based on a combination of the following criteria:
  • Utility Type
  • “Who” criteria (such as, account name, user name, query band, and so on)
  • Database and table or view name (except for archive and restore jobs)
Use the following utility-related Teradata Active System Management (TASM) rules to define how Vantage manages its workloads:
  • Utility Throttle (also called Utility Limit in the Teradata Viewpoint Workload Designer portlet) – This rule enforces system wide limits on each type of the Teradata utilities, such as FastLoad, MultiLoad, FastExport, Teradata Parallel Transporter Load operator, JDBC FastLoad, and so on.
  • Utility Workload Throttle – This rule enforces the limits based on the following criteria:
    • Utility Type
    • “Who” criteria (such as account name, user name, query band, and so on)
    • Database and table or view name (not available for archive or restore jobs)

      To define a Utility Workload Throttle, create a workload definition with a throttle limit and the qualification criteria (or a combination) listed here for this rule.

  • AWT Resource Limit – This rule specifies an AMP Worker Task (AWT) limit for utilities. The rule enforces the limit based on the utility type, request source (for example, username and account), and query band.
  • Utility Session – This rule specifies how many utility sessions can be used for the various kinds of utilities. The supported qualification criteria are:
    • Utility Type
    • Account name, user name, query band, and so on

      When the Teradata dynamic workload management software is enabled and there is no applicable user-defined Utility Session rule, the Teradata dynamic workload management software automatically uses the default session rules to select the number of sessions based on the utility type, system configuration, and optional data size.

      You cannot delete default session rules. However, you can modify the utility session information (that is, the default numbers assigned to various utility kinds).

You can manage your load utilities and DSA by using Teradata Viewpoint.