Copying a Table 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 <table> element. In the following example, the source table DBName.Accounts with an associated journal is created on the target with no journal attribute.
    <database selection="unselected">
    	<name>DBName</name>
    	 <table selection="included">
    		 <name>Accounts</name>
       <journaling>false</journaling>
     	</table>
    </database>
    These DDL statements highlight the differences between the definitions of tables when you specify journal and no journal. The following example shows the DDL for DBName.Accounts on the source.
    CREATE SET TABLE Accounts ,FALLBACK ,
          DUAL BEFORE JOURNAL, DUAL AFTER JOURNAL, WITH JOURNAL TABLE = DBName.Journal1  ,
         CHECKSUM = DEFAULT
         (
          Col1 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
          Col2 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
          col3 TIMESTAMP(0))
    PRIMARY INDEX ( Col1 )
    INDEX ( Col2 );
    
    The following example shows the DDL for DBName.Accounts after it is created on the target without journaling.
    CREATE SET TABLE Accounts ,FALLBACK ,
          NO BEFORE JOURNAL, NO AFTER JOURNAL, 
         CHECKSUM = DEFAULT
         (
          Col1 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
          Col2 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
          col3 TIMESTAMP(0))
    PRIMARY INDEX ( Col1 )
    INDEX ( Col2 );