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 SYNC {<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 sync 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>