Utility System Limits - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
nbl1556236178169.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
Teradata Vantage
In addition to user-defined utility throttles, TASM imposes the following utility system limits.
Protocols Limits Delay/Reject Utility Names
FastLoad+MultiLoad+FastExport 60 Delay
  • FastLoad, Teradata Parallel Transporter Load operator, JDBC FastLoad, CSP Save Dump, MultiLoad, Teradata Parallel Transporter Update operator, FastExport utility, Teradata Parallel Transporter Export operator, and JDBC FastExport
  • Non-conforming FastLoad, MultiLoad, and FastExport utilities

FastLoad+MultiLoad 30 Delay
  • FastLoad, Teradata Parallel Transporter Load operator, JDBC FastLoad, CSP Save Dump, MultiLoad, and Teradata Parallel Transporter Update operator
  • Non-conforming FastLoad and MultiLoad utilities
FastLoad 30 Delay
  • FastLoad, Teradata Parallel Transporter Load operator, JDBC FastLoad, and CSP Save Dump
  • Non-conforming FastLoad utilities
MultiLoad 30 Delay
  • MultiLoad and Teradata Parallel Transporter Update operator
  • Non-conforming MultiLoad utilities
MLOADX 30/120 Delay Teradata Parallel Transporter Update operator
FastExport 60 Delay
  • FastExport utility, TPT Export operator, and JDBC FastExport
  • Non-conforming FastExport utilities
Backup/Restore 350 Delay Teradata DSA
  • When a utility system limit is reached, Delay is the default if there is no user-defined utility throttle with a reject option.
  • The default limit for MLOADX jobs is 30. You can get a higher limit of 120 if you select the option for Support increased MLOADX job limits and increased AWT resource limits. If you select that option, MultiLoad throttles do not apply to MLOADX jobs.
The following figure shows the Support increased MLOADX job limits and increased AWT resource limits option.