Replication Server requires two tables named rs_info and rs_lastcommit at the replicate database. Additionally, for Microsoft SQL Server, Replication Server requires a stored procedure named rs_update_lastcommit.
Sybase provides scripts to install and load these objects for each supported non-Sybase data server. These scripts are part of the heterogeneous datatype support (HDS) feature in Replication Server. These scripts are located in the $SYBASE/$SYBASE_RS/scripts directory and are named using the following convention: hds_xxx_setup_for_replicate.sql
For example: hds_db2_setup_for_replicate.sql
To set up a non-Sybase replicate database
Modify the script to identify the database in which the objects are created. The syntax is dependent on the data server.
Use the DirectConnect gateway server connected to the replicate database to load the script.
The user ID used to load the script must have permissions
to create the objects.
Issue the following command:
isql -Uuid -Ppassword -SDCserver < hds_db2_setup_for_replicate.sql
