Page 1 of 1

how to unload data from production to dev

PostPosted: 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

PostPosted: Mon Aug 22, 2011 7:49 pm
by Akatsukami
  1. Unload production, masking NPI as needed.
  2. Load to development.
  3. Check out.

Re: how to unload data from production to dev

PostPosted: 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

PostPosted: 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.