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. Configure the DirectConnect access services 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-ASE data server.
In the case of DB2 UDB on IBM z/OS, Replication
Server can use the Mainframe Connect DirectConnect for z/OS
Option to connect directly to the mainframe in a gatewayless system,
eliminating the need for a database gateway. Replication through
a gatewayless connection requires a TCP/IP connection to
the mainframe. See Chapter 8, “DB2 UDB for z/OS Replicate Data Server Issues,” 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 the appropriate chapter for your database.
