DATABASE RESYNC Command | unityadmin | Teradata Unity - 17.00 - DATABASE RESYNC - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

Purpose

Synchronizes all the tables in the specified database from the source system to the destination system.

For each table within the database, if the replication and table sync options are set, they are used to determine if the table should be synchronized and how long that synchronization is allowed to take.

The synchronization may take a long time depending on the size of the tables or the transfer rate between the systems.

Syntax

DATABASE RESYNC {<database>[FROM <tdpid1> TO <tdpid2>][TIMEOUT '<timeout (seconds)>']]};

Parameters

database
Name of database holding tables to synchronize.
tdpid1
Unique identifier (TDPID) of a source Teradata Database system.
tdpid2
Unique identifier (TDPID) of a target Teradata Database system.
TIMEOUT seconds
Specifies the timeout value, in seconds.

Example

unityadmin> database resync db1 from sys1 to sys2;
Operation Number : 3
Operation Name   : Resyncing Object
User             : admin
User Name        : Main Administration User
Start Time       : 05/01 08:53:55
Updates:
    05/01 08:53:55 [-] Info: Resyncing table db1.table1 from [1] sys1 to [2] sys2 using timeout 150
…
    05/01 08:53:55 [-] Info: 2461 tables in the database were checked to see if they could be synced.
    05/01 08:53:55 [-] Info: 99 tables were skipped, because they are set to NOT sync.
    05/01 08:53:55 [-] Info: Syncing was attempted on 2362 tables.
    05/01 08:53:55 [-] Info: 2361 tables were successfully synced.
    05/01 08:53:55 [-] Info: Operation finished
Status      : Finished (1)
Finish Time : 05/01 08:53:55
unityadmin>