The only significant intrusions or impacts to the IBM DB2 Universal Database replicate database are the database objects created by the hds_udb_setup_for_replicate.sql script to support Replication Server replicate database operations.This script creates two tables in the replicate database to support Replication Server operations:
RS_INFO, which contains information about the sort order and character set used by the replicate database.
Be sure to confirm that the INSERT statements
for this table (in the hds_udb_setup_for_replicate.sql script)
specify the proper character set and sort order for your IBM DB2
Universal Database server.
When using Replication Server version 12.0 or later, the replicate database sort order and character set must be recorded in the RS_INFO table.
The Replication Server rs_get_charset and rs_get_sortorder functions retrieve the character set and sort order from the RS_INFO table in the replicate database.
RS_LASTCOMMIT, which contains information about replicated transactions applied to the replicate database.
Each row in the RS_LASTCOMMIT table identifies the most recent committed transaction that was distributed to the replicate database from a primary database. Replication Server uses this information to ensure that all transactions are distributed.
The Replication Server rs_get_lastcommit function retrieves information about the last transaction committed in the replicate database. For non-Sybase replicate databases, the rs_get_lastcommit function is replaced in the database-specific function-string class by the query required to access the RS_LASTCOMMIT table in the replicate database.
