Although Teradata ARC does not automatically copy the journal table in the database when copying an entire database, you can specify journal data to be copied to the target.
Although journal data for source tables is copied to the target, the entire journal is not copied. The permanent journal must exist on the target before job creation. Data Mover does not create the permanent journal on the target.
An error occurs during job creation if one or more tables that use the journal are not copied.
- Create a journals section and add the selection="included" attribute to a journal element.
- Specify the names of the journal and the journal database.
In the following example, journal data from the MyJournal table is copied from the west1000 journal database to the target.
<journals> <journal selection="included"> <journal_database>west1000</journal_database> <name>MyJournal</name> </journal> </journal>