Purpose
Synchronizes all the tables in the specified database from the source system to the destination system.
For each table in your database, if you set the replication and table sync options, they determine whether to synchronize your table and specify the maximum duration allowed for the synchronization process.
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)>'][REASON '<reason>'][VALIDATE]};Parameters
- database
- Name of database holding tables to synchronize.
- tdpid1
- Unique identifier (TDPID) of a source database system.
- tdpid2
- Unique identifier (TDPID) of a target database system.
- TIMEOUT seconds
- Specifies the timeout value, in seconds.
- [Optional] REASON reason
- User comments or description for performing the database resync.
- [Optional] VALIDATE
- Checks if the tables are synchronized before performing a resync. If the optional VALIDATE flag is omitted, the command proceeds to resynchronize the tables directly.
Example
bcmadmin> 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 bcmadmin>