Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 - NEED SOME INFO REGARDING DB2 DATABASE COPY UTILITY

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vinit_infy
Warnings : 1

New User


Joined: 07 Apr 2005
Posts: 56

PostPosted: Wed Nov 28, 2007 10:12 pm    Post subject: DB2 - NEED SOME INFO REGARDING DB2 DATABASE COPY UTILITY
Reply with quote

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
View user's profile Send private message

lina chiramal
Currently Banned

New User


Joined: 25 Nov 2007
Posts: 1
Location: Bangalore

PostPosted: Sun Dec 02, 2007 3:37 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Sun Dec 02, 2007 8:19 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sarabjeetchaddha

New User


Joined: 12 Jan 2006
Posts: 2
Location: mumbai

PostPosted: Fri Dec 07, 2007 10:29 am    Post subject: Reply to: DB2 - NEED SOME INFO REGARDING DB2 DATABASE COPY U
Reply with quote

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
View user's profile Send private message
Krishnadeva Reddy

New User


Joined: 14 Nov 2007
Posts: 36
Location: Chennai

PostPosted: Sat Dec 08, 2007 12:28 am    Post subject:
Reply with quote

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
View user's profile Send private message
sarabjeetchaddha

New User


Joined: 12 Jan 2006
Posts: 2
Location: mumbai

PostPosted: Mon Dec 10, 2007 4:07 pm    Post subject: Re: Reply to: DB2 - NEED SOME INFO REGARDING DB2 DATABASE CO
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need info on EIBCPOSN value in IBM FA... subratarec CICS 11 Wed Jul 12, 2017 3:45 pm
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts copy SEQ to PDS and create stats steve-myers JCL & VSAM 7 Thu Apr 27, 2017 1:15 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us