Restarting a Job with Client Load and Unload Utilities - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2425
lifecycle
previous
Product Category
Teradata Tools and Utilities

The Teradata Access Module for Named Pipes supports normal checkpoint and restart/recovery operations on the reader process system, but has no such interaction with the writer process.

Routine recovery operations on the reader process system are handled automatically by the Teradata Access Module for Named Pipes. In the following cases, they require no manual intervention:
  • If the reader process terminates unexpectedly, restart the job, which causes the Teradata Access Module for Named Pipes to use the fallback data file to relocate to the last checkpoint in the data stream.
  • If the writer process terminates unexpectedly, manually abort the reader process and resynchronize the job.

The writer process generally restarts from its beginning, while the reader process falls back to the last checkpoint, allowing the Teradata Access Module for Named Pipes to synchronize the two. You might need to take the following additional steps to complete the restart operation, depending on which client load and unload utilities are used:

  1. Prepare the writer process source for a clean start.

    The FastExport utility, for example, uses a log table to determine that a task was interrupted. To start an interrupted FastExport job from its beginning, you must first drop the FastExport log table.

    The log table is specified by the LOGTABLE command in the FastExport job script.
  2. Modify the reader process job script. For example, in the FastLoad utility, do the following:
    1. Remove any statement that drops the table being loaded.
    2. Remove any statement that creates the table being loaded.
  3. Launch both the writer and the reader processes as described in Using the Teradata Access Module for Named Pipes. The Teradata Access Module for Named Pipes uses the fallback data file from the interrupted job to locate the restart position in the data stream from the writer process.
Teradata Access Module for Named Pipes does not support the restart of a Named Pipe after a database restart.