Articles & Content


full data refresh of DB2- (and IMS-)databases at a simultaneous point in time in SYSPLEX (B03)

Topic: 2006 EU

Subtopic: DB2 for z/OS

DATE: 2006-10-2 (16:15 - 17:15)
SPEAKERS: Leo Van Looy (Fortis Bank NV)

Several times a year we copy our DB2- and IMS production data (>3.6 Tb) to a quality assurance environment (=refresh). One of the business requirements is that this full data refresh is done at an exact point in time, valid for the business. At Fortis Bank we developed a process to achieve this goal using both home-made development and third party tools. This process equally takes into account design changes -already active in QA and not yet installed in production- and we make person related data inrecognizable in QA at the same time (=data scrambling).

EXP. LEVEL: Intermediate


Guide to FULL DATA REFRESH from PROD to QA at a specific point in time in a sysplex environment

simultaneous use of point-in-time for both DB2 and IMS-databases

Use of recovery-tools in data refresh

applying design changes and/or data scrambling after data refresh

applying DB2-ID changes when switching catalog's

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.