Usage Notes - 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

The following table describes the things to consider when using the PAUSE ACQUISITION command.

Pause Acquisition Usage Notes 
Topic Usage Notes
Command Frequency and Placement The Teradata MultiLoad job can use more than one PAUSE ACQUISITION command, as long as each one is associated with a different import task. Only one PAUSE ACQUISITION command can be used in each import task.
In a Teradata MultiLoad job script, PAUSE ACQUISITION commands must appear:
  • After the BEGIN MLOAD command
  • Before the END MLOAD command

If a PAUSE ACQUISITION command appears before the first IMPORT command, then Teradata MultiLoad pauses the job before starting the acquisition phase.

If a PAUSE ACQUISITION command appears after the last IMPORT command, then Teradata MultiLoad pauses the job before starting the application phase.

If a PAUSE ACQUISITION command appears between two IMPORT commands, then Teradata MultiLoad begins the acquisition phase, processes the first IMPORT command, and pauses the job before processing the second IMPORT command.

Operational Requirements PAUSE ACQUISITION commands can be used to separate a Teradata MultiLoad job into two or more distinct operations provided that it has either:
  • One or more acquisition phase operations that load import data into the Teradata MultiLoad work tables.

    or

  • An application phase operation that inserts the work table data into the target tables or views on the database.
Pause Conditions When a Teradata MultiLoad job pauses, the utility:
  • Displays a message indicating that the job was paused by user request.
  • Terminates the job with a return code of 4.
Restarting the Job To restart a paused Teradata MultiLoad job, remove the associated PAUSE ACQUISITION statement from the Teradata MultiLoad job script and resubmit the job. Teradata MultiLoad then resumes processing acquisition phase IMPORT commands, and either:
  • Continues into the application phase

    or

  • Pauses again in response to another PAUSE ACQUISITION command