Replication Example Environment

Home | Previous Page | Next Page Appendix E. Replication Examples >

Replication Example Environment

To run the replication examples in this chapter, you need three Informix database servers. Each database server must be in a database server group.

This example uses the following environment:

Three computers (s1, s2, and s3) are hosts for the database servers usa, italy, and japan, respectively. 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, respectively.

For information about database server groups, see Setting up Database Server Groups.

UNIX Only

The UNIX sqlhosts file for each database server contains 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_italy
g_japan	group	-	-	i=6
japan	ontlitcp	s3	techpub6	g=g_usa

End of UNIX Only

Windows Only

See Appendix F. SQLHOSTS Registry Key (Windows) for information on how to prepare the SQLHOSTS connectivity information using the information shown in the above UNIX sqlhosts file.

End of Windows Only

The ONCONFIG file contains the following CDR_QDATA_SBSPACE entry:

CDR_QDATA_SBSPACE sbspace #CDR queue smart blob space

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 in this chapter are identical 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
s2> dbaccessdemo -log stores
```

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