OBJECT SET REPLICATION Command | unityadmin | Teradata Unity - OBJECT SET REPLICATION - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
dita:id
B035-2520
Product Category
Analytical Ecosystem

Purpose

Defines if a table is replicated automatically using Unity 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.
unityadmin>  OBJECT SET REPLICATION db1.table1 IMMEDIATE;
The replication option for [4143] db1.table1 has been set to NEVER.
unityadmin>  OBJECT SET REPLICATION db1.table2 NEVER;