Articles & Content

Archives

Migrating a 350GB Realtime Database in 7 min or Less - With No 3rd Party Tools (H09)

Topic: 2007 NA

Subtopic: DB2 for z/OS



DATE: 2007-5-9 (09:50 AM - 10:50 AM)
SPEAKERS: Kenneth Ernstein (CSC - eMedNY)

The New York State Medicaid system had 1 hour to migrate its pharmacy claim database to a new claim database without financial penalty. During this same migration window, the old system had to be operational for eligibility verification. With no budget for Third Party Tools, the Data Architecture team devised a strategy to fully migrate the data to the new system, while keeping the old system active. The data and processing conversion was accomplished with a total 7 min pause in application processing and full data availability for eligibility verification.This presentation will cover the design requirements, the actual design, the implentation planning and the design usage beyond the initial conversion to ensure continuous data availability in a 24x7x365 environment.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

An Architectural design for migrating data between tables in a continuous availability environment

How to make destructive table changes to a 24x7 table with no apparent outage

Options for destructive table changes to a 24x7 table based on usage type (RO, RW, Insert Only)

Information needed to create a detailed plan for data migration in a continuously available environment

How to migrate data real time with no expensive third party tools



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.