My Cart
Bookstore Sign In

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

IBM Redbooks

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

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 redbook 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 redbook 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 redbook. 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
Price: $62.00 $49.00
Pages: 432
Date Published: July 6, 1999
ISBN: 0738413577
Author: IBM Redbooks
Product Number: SG24-5463-00
Ships in 3-5 days
Why Vervante?

© 2024 Vervante Corporation. All rights reserved.