Configuring and administering synchronization environment
You configure and administer the advanced replication environment using SQL statements and system stored procedures.
Typically the setup of the advanced replication environment includes the following steps:
Set up master
1 Define the database as a master database and create a catalog for synchronization.
2 Create a publication to define the data set that will be replicated to one or more replica databases.
3 Define user access rights to control who can synchronize data.
You can complete the set up steps using a combination of system procedures and SQL statements or by using SQL statements only. To modify the publication definitions later on, a set of SQL statements are available.
Set up replicas
1 Define each database as a replica database, register replicas with the master database and create a catalog for synchronization.
2 Define user access rights to control who can synchronize data.
3 Register each replica for a publication.
You can complete the set up steps using a combination of system procedures and SQL statements or by using SQL statements only. To modify the publication definitions later on, a set of SQL statements are available.
In the advanced replication environment, data changes can be synchronized bidirectionally:
Synchronize data
To synchronize (load) data from the master to replica, issue a refresh. The refresh can load all data (full refresh) or only changed data (incremental refresh).
To synchronize changes to data from replica to master:
1 Save each DML statement using a proprietary SAVE statement.
2 Compose a message that defines the saved data to be propagated to the master.
3 Send (forward) the message to the master.
The refreshes of data from the master to the replica are started by issuing a REFRESH command on the replica.
The propagation of data from the replica to the master is controlled using SQL statements and procedure-type MESSAGE statements.