View previous topic :: View next topic
|
Author |
Message |
vinit_infy Warnings : 1 New User
Joined: 07 Apr 2005 Posts: 56
|
|
|
|
Hi All,
I have two DB2 database having same number of tables around (100 tables).
You can assume it as a Production DB2 region and TEST DB2 region.
I would like to copy whole database/Subset from Production DB2 region to Test DB2 region. Is there any utility or way you know, which i can use to do so?
One way of doing this is to Unload each table from Production region in flat file and then load that file to Test region , but it is looking very cumbersome task since, data volume is very high and there are more than 100 tables.
So, if any one can advise me any utility then that will be very great help for me.
Waiting for your expert comments.
Many Thanks,
Vinit |
|
Back to top |
|
|
lina chiramal Currently Banned New User
Joined: 25 Nov 2007 Posts: 1 Location: Bangalore
|
|
|
|
Hi ,
Even I would like to know the ans to the above qt.. I don't know why nobody has answered as yet...
Maybe you could change the title ?
Regds,
Lina |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
lina chiramal wrote: |
Hi ,
Even I would like to know the ans to the above qt.. I don't know why nobody has answered as yet...
Maybe you could change the title ?
Regds,
Lina |
The way I copy DB2 data from PROD to TEST is to unload in prod and load in test but that option has already been ruled out, that is why I didn't reply. |
|
Back to top |
|
|
sarabjeetchaddha
New User
Joined: 12 Jan 2006 Posts: 2 Location: mumbai
|
|
|
|
Hi,
You Can do it through FILEAID FOR DB2 tool.
I did it using one tool, i am not able to brush up it' s name, will surely reply you that tool name also.
But there is one option called as MIGRATION or RC-MIGRATION...
Just look for same option in fileaid for db2 , for sure that option will be
migration only...an option numbered as point 6 probably .
Please let me know...
I am a new joinee in a company, so right now i don't have any ID,else i would have searched and pasted in this portfolio.
Thanks
Sarabjeet Chaddha
09350181267 (New Delhi ) |
|
Back to top |
|
|
Krishnadeva Reddy
New User
Joined: 14 Nov 2007 Posts: 37 Location: Chennai
|
|
|
|
Hi Vinit,
If you know about PST(princeton Softech Relational) tool in DB2 or if you are using any other similar relational tool,this task will be simple to copy the whole data from prod region to test region(unless all tables are not related to each other). |
|
Back to top |
|
|
sarabjeetchaddha
New User
Joined: 12 Jan 2006 Posts: 2 Location: mumbai
|
|
|
|
Yes,
We can do it through PST,i was not getting this name only.
There is an option in PST.....probably option no.6 as RC-Migratin or Migration...then following the steps you will come to an option as...EXTRACT and then INSERT ...you can follow the steps.....
Thanks to remind me the name vineet...
sarabjeetchaddha wrote: |
Hi,
You Can do it through FILEAID FOR DB2 tool.
I did it using one tool, i am not able to brush up it' s name, will surely reply you that tool name also.
But there is one option called as MIGRATION or RC-MIGRATION...
Just look for same option in fileaid for db2 , for sure that option will be
migration only...an option numbered as point 6 probably .
Please let me know...
I am a new joinee in a company, so right now i don't have any ID,else i would have searched and pasted in this portfolio.
Thanks
Sarabjeet Chaddha
09350181267 (New Delhi ) |
|
|
Back to top |
|
|
|