Definition - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities

Always estimate the final size of the Teradata MultiLoad target tables and make sure that the destination database has enough space to complete the Teradata MultiLoad job.

If the database that owns the Teradata MultiLoad tables runs out of space, the database returns an error message and Teradata MultiLoad stops the job. When this happens, allocate more space to the database before restarting the Teradata MultiLoad job.

Target tables might need extra space and each Teradata MultiLoad job needs permanent space for:
  • Work tables
  • Error tables
  • The restart log table
Spool space for Teradata MultiLoad work tables, error tables, or the restart log table cannot be used. Spool space is freed at each restart. Using permanent space for the Teradata MultiLoad tables preserves the data for restart operations after a system failure.

Note that work tables, especially, require a large amount of extra permanent space.