Copying All Tables of a Database With No Journaling - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
  1. Run the query command and edit the resulting <objlist>.xml file.
  2. Run the list_job_definition command and edit the resulting <job_name>.xml.
  3. In the xml file, add the string <journaling>false</journaling> as a child of the <database> element to copy all the tables of the database from source to target without using the journal associated with the source. In the following example, all tables with an associated journal in the source database DBName are copied to the target database DBName_2 with no journaling.
    <database selection="included"> 
    	<name>DBName</name>
     <target_database>
      <name>DBName_2</name>
     </target_database>
     <journaling>false</journaling>
    </database>

    By default, Data Mover copies the journal attribute when copying one or more source tables to the target. You can optionally specify <journaling>true</journaling> in the xml.

    If the xml specifies the <journaling> element at the database level, you can override this element for tables within the database by specifying the <journaling> element at the table level. In the following example, all tables in database DBName are created on the target with no journal attribute but tables DBName.Accounts and DBName.Orders are created within database DBName with the journal attribute.
    <database selection="included"> 
    	<name>DBName</name>
     <journaling>false</journaling>
     <table selection="included">
    		 <name>Accounts</name>
       <journaling>true</journaling>
     </table>
     <table selection="included">
    		 <name>Orders</name>
       <journaling>true</journaling>
     </table>
    </database>
    The <journaling> option at the database level is ignored if the entire database is not copied to the target.