Register Login

Asynchronous Table Replication (ATR) Set Up

Updated May 18, 2018

How to set up table replicas?

This tutorial explains to users how to set up various types of Asynchronous Table Replication (ATR) in SAP HANA. It explains with details each and every command needed to replicate various types of tables. 

Asynchronous Table Replication (ATR)

Below are the commands which are used implement table replicas:

 

 

 

Replication type Command Details
ATR, OSTR CREATE ... TABLE ... [A]SYNCHRONOUS REPLICA AT '<host>:<port>' Creation of a table with an (a)synchronous replica on node <host> and port <port>
ATR, OSTR ALTER TABLE ... ADD [A]SYNCHRONOUS REPLICA AT '<host>:<port>' Adding an (a)synchronous replica to an existing table on node <host> and port <port>
ATR, OSTR ALTER TABLE ... ENABLE [A]SYNCHRONOUS REPLICA Activation of (a)synchronous table replication for a specific table
ATR, OSTR ALTER TABLE ... DISABLE [A]SYNCHRONOUS REPLICA Deactivation of (a)synchronous table replication for a specific table
ATR, OSTR ALTER SYSTEM DISABLE ALL [A]SYNCHRONOUS TABLE REPLICAS  Global deactivation of (a)synchronous table replication
ATR, OSTR ALTER TABLE ... DROP REPLICA AT ALL LOCATIONS Drop of all replicas for a specific table
ATR, OSTR ALTER TABLE ... DROP REPLICA AT '<host>:<port>' Drop replica at node <host> and port <port> for a specific table
ATR, OSTR
ALTER SYSTEM ENABLE ALL [A]SYNCHRONOUS TABLE REPLICAS

Global activation of (a)synchronous table replication

ATR:

  • Deactivated per default
  • Can require significant time and resources in case of large tables with replicaS

OSTR:

Activated per default

 


×