17.00 - Utility System Limits - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K
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 Archive/Recovery and 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.