how to unload data from production to dev



IBM's flagship relational database management system

how to unload data from production to dev

Postby suresh48 » Mon Aug 22, 2011 3:36 pm

Hi,
Can anybody explain
How to unload data from PRODUCTION environment to DEV environment. what is the process?
suresh48
 
Posts: 5
Joined: Fri Jan 07, 2011 4:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: how to unload data from production to dev

Postby Akatsukami » Mon Aug 22, 2011 7:49 pm

  1. Unload production, masking NPI as needed.
  2. Load to development.
  3. Check out.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: how to unload data from production to dev

Postby gauthamnagpur18 » Wed Aug 31, 2011 9:17 am

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
gauthamnagpur18
 
Posts: 93
Joined: Sat Oct 23, 2010 1:28 pm
Location: Chennai, India
Has thanked: 3 times
Been thanked: 3 times

Re: how to unload data from production to dev

Postby dick scherrer » Wed Aug 31, 2011 10:04 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post