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. |