The following table describes the things to consider when using the PAUSE ACQUISITION command.
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:
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:
|
Pause Conditions | When a Teradata MultiLoad job pauses, the utility:
|
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:
|