What are my options using DB2 COPY in production to RECOVER data to Test/Development?
Posted on 2013-01-11
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.