Articles & Content
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.