Utility Management
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.