Articles & Content


When Replication Is the Integration Solution (I11)

Topic: 2008 NA

Subtopic: DB2 for z/OS

DATE: 2008-05-21 (02:45 PM - 03:45 PM)
SPEAKERS: Shery Hepp (SRP)

A copy of an operational database was created to meet the client’s requirement of having a reporting environment that didn't impact the performance of the operational database. The solution used for replication was a hardware solution. This solution affected the availability of the data in the reporting environment. Another problem was the restriction that the physical objects be identical between the two environments. A new solution was sought to give the clients higher availability, real time data and ease of maintenance. A software solution was chosen to replicate the updates in the operational database using the db2 logs. The updates are then applied using SQL into the reporting environment. This solution provides the clients with near real time operational data with no outages. This presentation will discuss the process of converting from a hardware solution to a software solution and the problems encountered. In addition the pros and cons of both solutions will be discussed.

EXP. LEVEL: Beginner,Intermediate,Advanced


Attendees will learn the strengths and weaknesses of using a hardware solution for data replication. If a hardware solution is used they will learn what components are needed in order to be successful with that solution for replication

Attendees will learn the strengths and weaknesses of using BMC logmaster as a software solution for data replication. And what components are needed in order to be successful with using Logmaster for data replication

Attendees will learn what things to consider when changing from one replication solution to another and how to mitigate risk during the implementation. In other words maybe they can learn from my mistakes

Attendees will learn that not one solution for replication fits all. Knowing your data and application requirements are necessary components in order to find the best overall long term solution for your environment

Attendees will learn to consider if possible what potential future requirements or restrictions may arise for the replicated data and try to pick the best solution that positions them to meet future requirements/negate the risk of the restrictions

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.