Purpose
Synchronizes the specified table from the source system to the destination system.
Syntax
OBJECT RESYNC {<tablename |id:object id>} [FROM tdpid1] [ TO tdpid2] [TIMEOUT '<timeout (seconds)>'];Parameters
- tablename
- Fully qualified name of the target object.
- object id
- Managed object id of the target object.
- tdpid1
- Unique identifier (TDPID) of a source Teradata Database system.
- tdpid2
- Unique identifier (TDPID) of a target Teradata Database system.
- timeout (seconds)
- The timeout, in seconds, to use for the operation.
Example
bcmadmin> OBJECT RESYNC db0.t1000 FROM sdt29630 TO sdt29631 TIMEOUT 60;
Operation Number : 3
Operation Name : Resyncing Object
User : admin
User Name : Main Administration User
Start Time : 07/22 10:29:24
Updates:
07/22 10:29:24 [-] Info: Resyncing table db0.t1000 from sdt29630 to sdt29631 using timeout 60
07/22 10:29:26 [-] Info: Activating table on target system ( setting to Active )
07/22 10:29:26 [-] Info: Successfully activated the table on 2 systems
07/22 10:29:26 [-] Info: Operation finished
07/22 10:29:26 [-] Info: Table resync completed
Status : Finished (1)
Finish Time : 07/22 10:29:26