The heterogeneous datatype support (HDS) feature of Replication Server provides a number of sample SQL scripts that help you set up the HDS feature in the replicate Replication Server and the IBM DB2 Universal Database replicate database.
A script to be applied to the IBM DB2 Universal Database replicate database. This script creates the RS_INFO, RS_LASTCOMMIT, and RS_TICKET_HISTORY tables in the replicate database. The script includes GRANT statements that need to be changed before execution to reference the correct user ID name of the Maintenance User defined in the Replication Server database connection for the replicate database. The Maintenance User ID must have UPDATE authority on the tables.
Sybase recommends using the Maintenance User ID to execute
this script.
Scripts to be applied to Replication Server System Database (RSSD).
The hds_udb_udds.sql script adds the user-defined datatypes (UDDs) that define the attributes of the IBM DB2 Universal Database native datatypes to the RSSD. The UDDs are required to ensure datatypes received from primary transactions are properly formatted for application to the IBM DB2 Universal Database replicate database.
You might need to modify the hds_udb_udds.sql script
to reference the correct RSSD database name.
The hds_udb_funcstrings.sql script replaces several default Replication Server function strings with custom function strings designed to communicate with the IBM DB2 Universal Database and access the tables and procedures created by the hds_udb_setup_for_replicate.sql script. These function strings are added to the Replication Server default rs_udb_function_class.
You may need to modify the script to reference the correct
RSSD database name.
Class-level translations identify primary datatypes and the replicate datatypes the data should be translated into (for example, Microsoft SQL Server binary should be translated to IBM DB2 Universal Database CHAR FOR BIT DATA).
These translations can affect Replication Server performance.
Only the translations needed for your specific primary database
and replicate database should be applied to the RSSD.
Class-level translation scripts supplied for the IBM DB2 Universal Database replicate database are:
hds_clt_ase_to_udb.sql – translates Adaptive Server datatypes to IBM DB2 Universal Database datatypes.
hds_clt_db2_to_udb.sql – translates DB2 for z/OS datatypes to IBM DB2 Universal Database datatypes.
hds_clt_msss_to_udb.sql – translates Microsoft SQL Server datatypes to IBM DB2 Universal Database datatypes.
hds_clt_oracle_to_udb.sql – translates Oracle datatypes to IBM DB2 Universal Database datatypes.
A script to be applied to the replicate Replication Server.
The hds_udb_connection_sample.sql script provides a template for creating the Replication Server database connection for a replicate IBM DB2 Universal Database using the pre-defined IBM DB2 Universal Database function-string class provided with Replication Server.
You must modify the hds_udb_connection_sample.sql template
to include your actual server, database, and Maintenance User names
before executing the script.
