Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise ReplicationThe HCL OneDB™ Enterprise Replication Guide describes the concepts of data replication using HCL® OneDB® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Setting up and managing Enterprise ReplicationAfter you design your replication system, you define it and start replication.
Defining Replication Servers, Replicates, Participants, and Replicate SetsThese topics describe the steps defining and starting Enterprise Replication.
Set up replication through templatesEnterprise Replication provides templates to allow easy setup and deployment of replication for clients with large numbers of tables to replicate. A template uses schema information about a database, a group of tables, columns, and replication keys to define a group of master replicates and a replicate set.
Realizing Templates
Template ExampleThis example illustrates a scenario in which one template is created and realized on two servers, then realized on a third server.

Template Example

This example illustrates a scenario in which one template is created and realized on two servers, then realized on a third server.

About this task

The template Replicateset1 is defined on three tables in the college database: staff, students, and schedule. The template is first realized on the servers g_cdr_ol_1 and g_cdr_ol_2.

This procedure is performed as follows:

Procedure

Define the template Replicateset1 on the staff, students, and schedule tables of the college database:
```
cdr define template -c g_cdr_ol_1 Replicateset1 -M g_cdr_ol_1\ 
 -C "timestamp" -A -R -d college testadm.staff testadm.students\
 testadm.schedule
```
This command also creates the replicate set Replicateset1.

Realize the template on the server g_cdr_ol_1:

cdr realize template -c g_cdr_ol_1 Replicateset1 "college@g_cdr_ol_1"

Realize the template on server g_cdr_ol_2 and synchronize the data with server g_cdr_ol_1:

cdr realize template -c g_cdr_ol_2 -u -S g_cdr_ol_1 \
Replicateset1 "college@g_cdr_ol_2"

Realize the Replicateset1 template on a new server g_cdr_ol_3 and synchronize the data with server g_cdr_ol_1. The g_cdr_ol_3 server participant is automatically added to all replicates within the Replicateset1 template:
```
cdr realize template -c g_cdr_ol_1 -u -S g_cdr_ol_1\ 
  Replicateset1 "g_cdr_ol_3"
```

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.