Configuring Replication Server for IBM DB2 Universal Database replication

This section describes the configuration tasks for configuring Replication Server for UDB.

Prepare the Replication Server RSSD for replication to an IBM DB2 Universal Database. To apply HDS support scripts to RSSD:

1. Set the environment variables by sourcing SYBASE.csh file.

2. Change to the $SYBASE/REP-15_0/scripts directory:

3. Load these scripts into the RSSD:

   isql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps –SSAMPLE_RS_ERSSD
   –ihds_clt_ase_to_udb.sql -DSAMPLE_RS_ERSSDisql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps –SSAMPLE_RS_ERSSD
   –ihds_udb_udds.sql -DSAMPLE_RS_ERSSDisql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps –SSAMPLE_RS_ERSSD
   –ihds_udb_funcstrings.sql -DSAMPLE_RS_ERSSD
   

4. Shut down Replication Server:

   isql –Usa –P –SSAMPLE_RS
   shutdown
   go
   

5. Navigate to the $SYBASE/REP-15_0/samp_repserver directory:

6. Run the RUN_SAMPLE_RS script, to start the SAMPLE_RS Replication Server.