16.10 - Restarting a Job with Teradata Parallel Transporter - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
16.10
created_date
July 2017
category
Programming Reference
featnum
B035-2425-077K

If a transfer terminates unexpectedly, you can restart the transfer. Under Teradata PT, the pipe writer process must restart from its beginning, but the Teradata PT infrastructure falls back to its last checkpoint, allowing the access module to synchronize the two. This saves time because the Teradata PT infrastructure does not have to reinsert into the destination table those records that have already passed through the pipe.

To specify a restart, issue the tbuild command with the -r option, as in the following example:

fexp < fexp.cmds > fexp.out & tbuild -r -f tbuild.txt &

In Teradata PT, the consumer operator cannot automatically direct the access module to restart, as do the client load utilities. All restarts require operator intervention.