17.10 - Examples: Utility Throttles - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)
A DBA can create several utility throttles to limit different combinations of utilities, such as in these examples:
  • Allow 10 load utilities of any kind with delay
  • Allow 5 FastLoad utilities with delay.
  • Allow 2 Teradata Parallel Transporter Updates with reject.
  • Allow 15 DSAs with delay.
  • Allow 40 MLOADX jobs with delay.
  • Allow 5 DSA Backup jobs with delay.
  • Allow 3 DSA Restore jobs with delay.
The following figure shows the system-level utility throttles.