DATABASE RESYNC Command | bcmadmin | Teradata Business Continuity Manager - DATABASE RESYNC - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide - 2.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
2.00
Published
August 2024
ft:locale
en-US
ft:lastEdition
2025-01-31
dita:mapPath
sko1694443904278.ditamap
dita:ditavalPath
ft:empty
dita:id
otc1639627713801
Product Category
Analytical Ecosystem

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>