Freeze Job Steps | Teradata Data Mover - 17.11 - Making Job Steps Static - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)

Each time a job is started, a verification step is performed to capture any changes in the source and target environments between the time the job was first created and the time it is run. This can negatively impact performance for jobs that run frequently.

For jobs with source and target environments that do not change after creation, use the freeze_job_steps parameter to prevent the job steps from being recreated each time the job is run.

If the freeze_job_steps parameter is true and the job target object status changes from non-exists to exists or from empty to non-empty, Data Mover recreates the job steps for only table and view objects. No rebuild is performed when using DSA.

If any changes occur in the source or target environments for the job, run the update_job_steps command to refresh the job steps.

  1. Open the parameters.xml file containing the job definition information for the job.
  2. Add the freeze_job_steps parameter in the appropriate place.
  3. Set the value of freeze_job_steps to true.
    If unspecified, the default value is false. If freeze_job_steps is true and the source or target environments change after job creation, an error may result when the job is run. In this case, run the update_job_steps command to refresh the job steps.