Job Execution Scenarios | Teradata Data Mover - Job Execution Scenarios - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.20
Published
November 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
wph1512683331242.ditamap
dita:ditavalPath
4101_UG_dm_1620.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
The following scenarios describe the execution of jobs when enabling or disabling the journal attribute associated with source tables or databases. These scenarios assume the default value is <journaling>true</journaling> for the source table or database.
Journaling Value Scenario Result
xml file specifies <journaling>true</journaling> for the table Table (or tables) does not exist on the target Creates a target table with the same journal attribute as the source table.
Table (or tables) exists on the target Maintains the journal attribute that exists on the target table.
xml file specifies <journaling>true</journaling> for the database Table (or tables) in database does not exist on the target Creates a target table with the same journal attribute as the source table for the database.
Table (or tables) in database exist on the target Maintains the journal attribute that exists on all target table for the database.
xml file specifies <journaling>false</journaling> for the table Table (or tables) does not exist on the target Creates the target table with no journaling.
Table (or tables) exists on the target Overwrites the target table with no journaling.
xml file specifies <journaling>false</journaling> for the database Table (or tables) in source database does not exist on the target Creates all tables in the target database with no journaling.
Table (or tables) in source database exists on the target Overwrites all tables in the target database with no journaling.
xml file specifies <journaling>false</journaling> for the table Source table does not use the journal attribute Ignores <journaling>false</journaling> for the table.
xml file specifies <journaling>false</journaling> for the database Job does not copy the entire database to the target Ignores <journaling>false</journaling> for the database in the xml.
job copies a permanent journal PJ that exists on the source Job does not copy at least one source table that uses the permanent journal PJ and does not have journaling disabled (<journaling>false</journaling>) Returns a create time error.
xml file specifies <journaling>false</journaling> for a table or an entire database Job uses Teradata JDBC or Teradata PT API Ignores <journaling>false</journaling> and returns a warning message at job creation time.