16.10 - Utility Management - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

To manage load utilities (such as, FastLoad, MultiLoad, and FastExport) and the Teradata ARC utility, 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)

You can use the following utility-related Teradata Active System Management (TASM) rules to define how Teradata Database 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 ARC, 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 (except the Archive and Recovery utility), 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, DSA, and the Teradata ARC utility by using Teradata Viewpoint.