Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Database replication from Prod Subsystem to Dev Subsystem

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

New User


Joined: 09 Jun 2006
Posts: 1

PostPosted: Tue Aug 08, 2006 12:10 am    Post subject: Database replication from Prod Subsystem to Dev Subsystem
Reply with quote

Hi All,

I am a newbie in the world of Mainframes. We have 2 DB2 subsystems on Mainframes, one for Production and other Development.

I have been given the task of replicating databases and TableSpaces that are present in Production to Development Subsystem. In some cases the Databases are already present in Dev so I only need to move data, in other cases there is nothing and I need to create the DB, TS and Tables and then populate the tables as well.

At the end of whole exercise the Prod and Dev should be the same.

We take daily backups of all TableSpaces in the Production Subsystem and I have access to all backups.

Can you please let me know what is the most fastest way of completing this exercise. What approach should I take.

We are on Db2 v7 for Z/OS

Regards,
Divakar



[/b]
Back to top
View user's profile Send private message

renjith
Warnings : 1

New User


Joined: 07 Aug 2006
Posts: 11

PostPosted: Tue Aug 08, 2006 11:33 am    Post subject: Re: Database replication from Prod Subsystem to Dev Subsyste
Reply with quote

I guess once u r sync with all objects u can go for
1)DSN1copy or
2)CROSS LOAD


in terms of fastness DSN1COPy is better,but in terms of work u have to do,cross load is better

thanks
renjith
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 Moving UDB database to Db2 on z/OS Keith Hooley DB2 4 Wed Sep 27, 2017 12:38 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts New PROC not reflecting in prod even ... Musab Ahmed CA Products 9 Tue Mar 15, 2016 12:45 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us