Utility Management - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
You can classify load utilities such as FastLoad, MultiLoad, and FastExport into a workload definition based on a combination of the following criteria:
  • Utility Type
  • "Who" criteria (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:

Rule Type Description
Utility Throttle Enforces system-wide limits on each type of the Teradata utilities (FastLoad, MultiLoad, FastExport, Teradata Parallel Transporter Load operator, JDBC FastLoad, and so on).
Utility Workload Throttle Enforces 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).
AWT Resource Limit 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 Specifies number of utility sessions that can be used for specific kinds 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 kinds of utilities).