Synchronize Database Content to New System | unityadmin | Teradata Unity - Synchronizing Database Content to a New System - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.51
Published
May 2020
Language
English (United States)
Last Update
2020-06-01
dita:mapPath
oic1588030762460.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem
These commands may take a long time to complete depending on the number and size of the tables within the database. While an individual system is being synchronized, a table-level read lock is placed on the table of the source system. This prevents any writes to the table while the table is being copied.
  1. At unityadmin, run the following command to activate a new system without activating its tables:
    unityadmin> system activate system2 NO TABLES;
  2. Run the following command to mark all the tables in the specified database as being available on the second system:
    unityadmin> database manage dbtest on system1, system2;
    Those tables start in the unrecoverable state on the new system.
  3. Run the following command to synchronize and activate all the tables in the specified database:
    unityadmin> database sync dbtest from system1 to system2;