To install datatype definition, you must execute a SQL script in the RSSDs of both the primary Replication Server and the replicate Replication Server. The script inserts the datatype definitions for the replicate database the RSSD rs_datatype table.
Installing datatype definitions in the RSSD
Sample installation scripts are provided for each non-Sybase database supported by HDS. The following databases and installation scripts are supported by HDS in Replication Server version 15.1.
Table 8-1: Datatype definition installation scripts Database
Script
Adaptive Server Anywhere
hds_asa_udds.sql
DB2
hds_db2_udds.sql
Microsoft SQL Server
hds_msss_udds.sql
Oracle
hds_oracle_udds.sql
UDB
hds_udb_udds.sql
You must execute the appropriate script for your replicate database type.
Find the script you need for your replicate database, then edit the script by adding the following command line after the initial comments, where rssd is the name of the RSSD database:
use rssd
Log in to the RSSD data server or a machine with a network connection to the RSSD host machine using a user ID that has owner permission in the RSSD database.
In this procedure, isql is used as
the Open Client application to access the RSSD database. You can
use any Open Client application to access the RSSD database.
Use the following command at the operating system prompt to execute the datatype definition installation script:
isql -Uuser -Ppw -Sserver -Drssd -iscript_name
where:
user – is the user ID with owner permission in the RSSD.
pw – is the password for the user ID.
server – is the server name of the RSSD host machine.
rssd – is the database name of the RSSD.
script_name – is the name of the datatype definition installation script file that you edited.
You must repeat this procedure for both the primary
Replication Server RSSD and the replicate Replication Server RSSD.
You can also install datatype definitions in any other Replication
Server RSSD in your replication system with no performance penalty.
