IBM Mainframe Forum

Hi,
Can anybody explain
How to unload data from PRODUCTION environment to DEV environment. what is the process?

1. Unload production, masking NPI as needed.
2. Load to development.
3. Check out.

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

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.