Articles & Content


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

Topic: DB2 for z/OS

Subtopic: 2006

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

Click Here to Download

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