Example: Defining TimesTen Replication in an Active-Active Configuration

This procedure defines the TimesTen replication.

1. Define the replicated data stores.

   On both nodes, add the following lines to the /timesten/TimesTen/info/sys.odbc.ini file.

   [active]
   DataStore=/timesten/data/active
   PermSize=64
   DatabaseCharacterSet=WE8MSWIN1252

2. Define the datastore content, including a user with administrative permissions.

   zone1$ ttIsql active
   Command> create table 
   t1 (col1 integer not null, col2 varchar(30), primary key (col1));
   Command> CREATE REPLICATION repscheme1
          > ELEMENT complete DATASTORE
          > MASTER active on "zone2"
          > subscriber active on "zone1";
   Command> CREATE REPLICATION repscheme2
          > ELEMENT complete DATASTORE
          > MASTER active on "zone1"
          > subscriber active on "zone2";
   Command> CALL ttRepStart;
   Command> create user repl identified by 'repl';
   Command> grant admin to repl;

3. Duplicate the data store active to the remote node and start the replication agent.

   zone2$ ttRepAdmin -duplicate -from active \
   > -host zone1 -uid repl -pwd repl "dsn=active"
   zone2$ ttIsql -e "call ttrepstart;exit;" active

4. Define the replication policy on all hosts.

   zone1$ ttAdmin -repPolicy always active
   zone2$ ttAdmin -repPolicy always active