Once a Data Mover job fails or is stopped with the stop command, the job might leave unwanted items on the source and target systems; including staging tables, error tables, and HUT locks. These remaining items can be removed with the cleanup command.
If the job used Teradata ARC, cleanup causes Data Mover to do the following:
- Kill any remaining Teradata ARC instances that were performing tasks for the job and are still running on the agent machine.
- Release HUT locks from the source and target systems.
If the job used Teradata PT API or Teradata JDBC, cleanup causes Data Mover to drop error, work, log, and staging tables from the target system.
Use start to rerun the job from the beginning. The job cannot be restarted with restart after using the cleanup command.
- Data Mover drops the target table during cleanup only if the table was created as a result of a failed or stopped Data Mover TPTAPI job. The drop occurs because the TPTAPI job won't complete successfully the next time it is executed unless the target table has already been dropped.
- With partial copies, Data Mover does not delete any rows that might have been inserted or updated in the target table.
- If the Teradata PT API Stream operator was used, macros that the Stream operator created are not automatically cleaned up. Instead, clean up the macros manually.
- Type cleanup -job_name PayableJob1 on the command line. Where PayableJob1 is the job name displayed when the job was created.