Articles & Content
Topic: 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
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.