Replication Guide and Reference

Support of Replication Environments

By supporting sources and targets that include the DB2 family, IMS, VSAM, Oracle, Sybase, Microsoft, Lotus Notes, and others, IBM's solution ensures that you have timely, reliable, and consistent data across your enterprise. IBM supports heterogeneity in replication environments as follows:

• IBM's architecture is built on standard SQL to leverage the database engine capabilities for data enhancement, network connectivity, and data security. IBM database support for DRDA enables replication to other DRDA application servers.

• An architected data staging area supports interoperability among multivendor databases, between heterogeneous data models, and among products from independent software vendors. IBM's DataPropagator NonRelational and DataRefresher products bring IMS, VSAM, and flat file data into the staging area, making it available for replication to client/server targets. Additionally, independent vendors offer products that read the data staging tables relying on the IBM Capture program as the source for DB2 data.

• IBM replication products directly support multivendor sources and targets through IBM's multidatabase server product, DataJoiner. DataJoiner provides transparent access to Oracle**, Sybase**, Microsoft SQLServer**, Informix, and other databases enabling replication to run across multivendor environments.

• Lotus NotesPump** extends replication to Lotus Notes and Open Database Connectivity (ODBC) accessible data, for example, data that can be accessed using Lotus Approach or Microsoft Access.

[ DB2 List of Books | Search the DB2 Books ]