- Edit the job definition.
- 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.The journaling option at the database level is ignored if the entire database is not copied to the target.<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>