Replication Example Environment

To run the replication examples in this publication, you must set up HCL® OneDB® database servers. Each database server must be in a database server group.

The replication environment for the examples consists of:

Three computers (s1, s2, and s3) that host the database servers usa, italy, and japan. Each computer has active network connections to the other two computers.
The database servers usa, italy, and japan are members of the database server groups g_usa, g_italy, and g_japan.

Windows: For information about how to prepare the SQLHOSTS connectivity information on Windows™ systems, see SQLHOSTS Registry Key (Windows). The following example uses the sqlhosts file on UNIX™ operating systems.

The sqlhosts file for each database server must contain the following connectivity information.

g_usa    group     -      -          i=1
usa      ontlitcp  s1     techpubs1  g=g_usa
g_italy  group     -      -          i=8
italy    ontlitcp  s2     techpubs2  g=g_ital
g_japan  group     -      -          i=6
japan    ontlitcp  s3     techpubs6  g=g_japan

You must create an sbspace for the row data and set the CDR_QDATA_SBSPACE parameter to the location of that sbspace. For more information, see Setting Up Send and Receive Queue Spool Areas and CDR_QDATA_SBSPACE Configuration Parameter.

All commands in this example, except for creation of the sample databases on italy and japan, are issued from the computer s1.

The databases for the examples are identical to stores_demo databases with logging, as follows:

Create a database named stores on the usa database server:
```
s1> dbaccessdemo -log stores
```
Create a database named stores on the italy database server:
```
s1> rlogin s2
s2> dbaccessdemo -log stores
```
Create a database named stores on the japan database server:
```
s1> rlogin s3
s3> dbaccessdemo -log stores
```

For information about preparing data for replication, see Data Preparation Example.