The following replicate database issues must be addressed in a successful heterogeneous replication system:
The requirements of the ECDA database gateway for the particular database server. The DirectConnect access services must be configured to work with the replicate database server and Replication Server.
The access and permissions required in the data server for the replication system to apply transactions to the replicate database. Both the replicate Replication Server and the ECDA gateway for a database must have user IDs and passwords defined in the database, with appropriate permissions to access replicate database objects.
The connectivity required to support communication between the replicate data server and other replication system components. ECDA gateways use either the native communication protocol of a data server, or standard ODBC or JDBC protocols to communicate with a replicate database. Replication Server generally requires a database gateway to communicate with a non-Sybase data server.
In the case of DB2 Universal Database on IBM z/OS,
Replication Server can use Mainframe Connect DirectConnect for z/OS
Option to connect directly to the mainframe in a “gatewayless” system.
This eliminates the need for a database gateway. Replication through
a gatewayless connection requires a TCP/IP connection to
the mainframe. For more information about DB2 for IBM z/OS
gatewayless connections, see “IBM DB2 Universal Database replicate data servers”, and the Mainframe Connect Server Option
for IBM IMS and MVS Installation and Administration Guide.
The limitations on replication into the particular data server. For example, Replication Server imposes limitations on some native datatypes in some databases.
The intrusion and impact of the database objects required to support Replication Server operations. Replication Server requires two tables and may require some stored procedures to manage a replicate database.
The replication system management issues specific to the particular data server. For example, different data servers allow different system management options.
For more information about specific replicate database issues for specific databases, see “Replicate data servers”.
