My Mother Thinks I'm a DBA! Cross-Platform, Multi-Vendor, Distributed Relational Data Replication with IBM DB2 DataPropagator and IBM DataJoiner Made Easy!

An IBM Redbooks publication


DB2 DataPropagator (DProp) is IBM's strategic data replication solution. As a tightly integrated component of IBM's DB2 Universal Database (UDB) products, IBM DProp enables cross-platform data replication among all members of the DB2 UDB family. DProp is a separately orderable feature for DB2 for OS/390, DB2 for AS/400, DB2 for VM or VSE.
In combination with other IBM products, such as IBM DataPropagator NonRelational (DPropNR), DataRefresher, or IBM DataJoiner, IBM DProp easily integrates non-relational data as well as data stored in non-IBM relational database systems into an enterprise-wide distributed multi-platform replication scenario.
In this IBM Redbooks publication we focus on how IBM's data replication solution is extended to non-IBM relational database systems. IBM DataPropagator and IBM DataJoiner will be used to integrate non-IBM relational databases, such as Informix, Oracle, Sybase Open Server or Microsoft SQL Server, into IBM's enterprise-wide replication solution. Additionally, we will demonstrate how mobile clients using Microsoft Access or other Microsoft Jet databases as a data store can be supplied with data maintained on central DB2 database servers.
To make the book most useful to support both the design and the implementation phase of a heterogeneous replication project, the book covers general guidelines and specific case studies separately.
First, we discuss general implementation options that are available to exploit the flexibility of IBM's data replication solution. We present guidelines to help you specify your business driven requirements as well as to adjust available replication options and advanced techniques to those business requirements. General setup and maintenance tasks that basically apply to all kinds of heterogeneous data replication projects are covered.
Next, we introduce practical case studies, showing how the previously discussed options closely relate to exemplary business requirements. The case studies are meant to be a reference for technically oriented project members whose duty it is to set up distributed, cross-platform, multi-vendor relational database systems. Implementation checklists are provided as well as recommendations for using some of the advanced replication options IBM DProp offers. To show the great variety of available options, each case study deals with a different business problem. Furthermore, in each case study we focus on a different non-IBM database system, either used as source for data replication or as replication target.
In the case studies, the DB2 databases are either DB2 for OS/390 databases or DB2 UDB for Windows NT databases, but the provided guidelines are also applicable as well for any other member of the DB2 family. These include: DB2 for AS/400, DB2 for UDB on UNIX platforms, DB2 UDB for OS/2, and DB2 for VM/VSE.
Replication between relational databases and non-relational databases (Lotus Notes databases, IMS hierarchical databases, VSAM files) is not a topic of this book. But solutions exist:
Lotus Notes Pump (used in conjunction with DProp), for Lotus Notes databases
DPropNR (used in conjunction with DProp), for IMS hierarchical databases
DataRefresher, possibly in conjunction with Data Difference Utility (DDU) for IMS databases and VSAM files

Table of contents

Part 1. Heterogeneous Data Replication-General Discussion
Chapter 2. Planning
Chapter 3. System and Replication Design-Architecture
Chapter 4. General Implementation Guidelines
Chapter 5. Replication Operation, Monitoring and Tuning
Part 2. Heterogeneous Data Replication-Case Studies
Chapter 6. Case Study 1-Point of Sale Data Consolidation, Retail
Chapter 7. Case Study 2-Product Data Distribution, Retail
Chapter 8. Case Study 3-Feeding a Data Warehouse
Chapter 9. Case Study 4-Sales Force Automation, Insurance
Appendix A. Index to Data Replication Tips, Tricks, Techniques
Appendix B. Non-IBM Database Stuff
Appendix C. General Implementation Checklist
Appendix D. DJRA Generated SQL for Case Study 2
Appendix E. DJRA Generated SQL for Case Study 3
Appendix F. DJRA Generated SQL for Case Study 4


Publish Date
06 July 1999

(based on 2 reviews)




IBM Form Number

Number of pages