Link to home
Start Free TrialLog in
Avatar of Enyinnaya
EnyinnayaFlag for United States of America

asked on

What are my options using DB2 COPY in production to RECOVER data to Test/Development?

Hi Gurus,

I need to find a solution on how to take a production backup image file and restore it to my test environment. The backups are made with the COPY utility.

Can all you gurus chip in and provide answers how you will go about performing this restore.data refresh. I know I can use DSN1COPY but that involves OBIDXLAT translation and with many many tablespaces to manage, I will gladly avoid having to do that. I am alsoaware that I could do Unload from PROD and LOAD to test but I am simply interested in using the backups that is made with the COPY utility. Can I UNLOAD and LOAD from an image dataset made with COPY utility?


Thanks in anticipation of very simple and creative answers.
ASKER CERTIFIED SOLUTION
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial