OBJECT SET REPLICATION Command | bcmadmin | Teradata Business Continuity Manager - OBJECT SET REPLICATION - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide

Product
Teradata Business Continuity Manager
Release Number
1.0
Published
January 2022
Language
English (United States)
Last Update
2022-01-27
dita:mapPath
otc1639627713801.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Defines if a table is replicated automatically using Business Continuity Manager self-healing feature and DATABASE SYNC command.

Syntax

OBJECT SET REPLICATION {<objectname>} [DEFAULT | NEVER | IMMEDIATE];

Parameters

objectname
Fully qualified name of the target object.
DEFAULT | NEVER | IMMEDIATE
With NEVER, the table is not replicated.
With IMMEDIATE, the table is not immediately replicated from a source system to a target system.
With DEFAULT, the table is replicated based on the value of the configuration setting DefaultObjectResyncOption:
  • 1 - Never replicate the table.
  • 2 - Resync the table immediately.

Examples

The replication option for [4143] db1.table1 has been set to IMMEDIATE.
bcmadmin>  OBJECT SET REPLICATION db1.table1 IMMEDIATE;
The replication option for [4143] db1.table1 has been set to NEVER.
bcmadmin>  OBJECT SET REPLICATION db1.table2 NEVER;