Creating the Connection to the Primary and Replicate Databases

Create the primary and replicate database connections.

1. Create the connection to the primary Oracle database. See the Heterogeneous Replication Guide and the Replication Server Options product documentation.
2. Create the connection to the replicate Sybase IQ database.
   Note: You cannot use rs_init to create the connection from Oracle to Sybase IQ.

   This example uses the iqdb database in the IQSRVR data server, and the default dbmaint Sybase IQ maintenance user.

   create connection to IQSRVR.iqdb
   using profile rs_oracle_to_iq;standard
   set username to dbmaint
   set password to dbmaint
   go

   If the command is successful, you see:

   Connection to ‘IQSRVR.iqdb’ is created.

   See "create connection with using profile clause," in Chapter 3, "Replication Server Commands" in the Replication Server Reference Manual.

3. Verify that the connection is running:

   admin who
   go

   If the connection is running, you see:

   Spid   Name       State              Info
   ----   --------   ----------------   -----------------
    63    DSI EXEC   Awaiting Command   103(1)IQSRVR.iqdb
    62    DSI        Awaiting Message   103 IQSRVR.iqdb
    35    SQM        Awaiting Message   103:0 IQSRVR.iqdb