Utility Management - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1093
lifecycle
previous
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 above qualification criteria (or a combination).

  • 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. The maximum value for the AWT Resource Limit rule is 70% of the value of the DBS Control utility field MaxAMPWorkerTasks.
  • 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.