A Practical Guide to DB2 UDB Data Replication V8
An IBM Redbooks publication
Note: This is publication is now archived. For reference only.
Published on 27 December 2002, updated 22 July 2003
IBM Form #: SG24-6828-00
Authors: Lijun (June) Gu, LIoyd Budd, Aysegul Cayci, Colin Hendricks, Micks Purnell and Carol Rigdon
IBM DB2 Replication (called DataPropagator on some platforms) is a powerful, flexible facility for copying DB2 and/or Informix data from one place to another. The IBM replication solution includes transformation, joining, and the filtering of data. You can move data between different platforms. You can distribute data to many different places or consolidate data in one place from many different places. You can exchange data between systems.
The objective of this IBM Redbooks publication is to provide you with detailed information that you can use to install, configure, and implement replication among the IBM database family - DB2 and Informix. The Appendix C provides information about configuring federated access to Informix, which can be used as a model for federated access to other non-DB2 database, such as Oracle, MS SQL Server, Sybase, and more, using DB2 Information Integrator V8. The book is organized so that each chapter builds upon information from the previous chapter.
Chapter 1. Introduction to DB2 Replication V8
Chapter 2. Getting started with Replication Center
Chapter 3. Replication control tables
Chapter 4. Replication sources
Chapter 5. Subscription set
Chapter 6. Operating Capture and Apply
Chapter 7. Monitoring and troubleshooting
Chapter 8. Maintaining your replication environment
Chapter 9. Advanced replication topics
Chapter 10. Performance
Appendix A. DB2 Admin Client and DB2 Connect PE install
Appendix B. Configuring connections for Replication Center
Appendix C. Configuring federated access to Informix