Utility System Limits - Analytics Database - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide - 17.20
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
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.