Creating the Connection to the Primary and Replicate Databases

Create the primary and replicate database connections.

1. Create the connection to the primary database.
   • Adaptive Server – use the Replication Server rs_init utility. See Replication Server Configuration Guide > Configure Replication Server and Add Databases using rs_init.
   • Oracle – see the Heterogeneous Replication Guide and the Replication Server Options product documentation.
2. Create the connection to the Sybase IQ replicate database.

   See Replication Server Reference Manual > Replication Server Commands > create connection using profile .

   Note: You cannot use rs_init to create the connection to Sybase IQ.

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

   • Adaptive Server:

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

   • Oracle:

     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.

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