how to unload data from production to dev
Posted:
Mon Aug 22, 2011 3:36 pm
by suresh48
Hi,
Can anybody explain
How to unload data from PRODUCTION environment to DEV environment. what is the process?
Re: how to unload data from production to dev
Posted:
Wed Aug 31, 2011 9:17 am
by gauthamnagpur18
Hi Suresh ,
There are two ways : one by using Fileaid for DB2 tool and other by using job .
In Fileaid for Db2 ,
we have to first unload the data from production and load into the development ,which can be achieved by 3.7 option .
Using job :
Through job , we have to mention query in sysin .
Let me know your thoughts .
Thanks,
Gautham
Re: how to unload data from production to dev
Posted:
Wed Aug 31, 2011 10:04 am
by dick scherrer
Hello,
There are two ways
There are more than 2 ways to do this. Also, keep in mind that many systems do not have File-Aid.
Two other rather common ways to do this is to use the UNLOAD/LOAD or retrieve the data from a Production imagecopy.