A Practical Guide to DB2 UDB Data Replication V8

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

Published 27 December 2002, updated 22 July 2003

cover image

ISBN-10: 0738427616
ISBN-13: 9780738427614
IBM Form #: SG24-6828-00
(570 pages)

View online

Other Language Versions

Note: Other language versions may not be as current as the English edition.

More options

Rate and comment

Authors: Lijun (June) Gu, LIoyd Budd, Aysegul Cayci, Colin Hendricks, Micks Purnell, 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.

Table of contents

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

Follow IBM Redbooks

Follow IBM Redbooks