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
 

 

Migrating data from oracle to db2

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

New User


Joined: 18 Aug 2008
Posts: 98
Location: India

PostPosted: Fri Feb 05, 2010 2:42 pm    Post subject: Migrating data from oracle to db2
Reply with quote

Hi All
We have to perform migration of data base from oracle(unix) to db2(z/OS).

Apart from the technical constraints there are some enterprise architecture constraints imposed as well (like max size of FTP transfer cant be more than 2 GB).

The DB size is 1.5 TB. There are approx 200 tables. Maximum no of rows in a table is around 70 million. The tables definitions exist on Z/os. The data from the z/os will be deleted and loaded with the data from oracle.

We plan to load the data using delimted file format. Remote connection from unix to db2 is not allowed ( enterprise architecture dictum :-( ).
There seems to be more than 200 ( 2 GB) files which need to be first FTPed and the loaded into specific tables. Referential constraints will be checked after all the files are loaded using the db2 utility. The control card and data files will be provided by the unix system. The table definitions on z/os and unix mapped 1:1.

Whole process seems too manual to me and the chances of error seems to be very high.

Please suggest is there any other optimal way of doing it. let me know if some more info is required.


regards
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2435
Location: Netherlands, Amstelveen

PostPosted: Fri Feb 05, 2010 2:49 pm    Post subject:
Reply with quote

Remote connection from unix to db2 is not allowed.

Is remote connection from z/os to unix allowed ? I guess so since you can
FTP.

Maybe direct connect is a solution?
Back to top
View user's profile Send private message
tomehta

New User


Joined: 18 Aug 2008
Posts: 98
Location: India

PostPosted: Fri Feb 05, 2010 2:56 pm    Post subject: Reply to: Migrating data from oracle to db2
Reply with quote

Hi Peter
Quote:

Remote connection from unix to db2 is not allowed.

from the sentence I meant we cannot use connect direct.
Reason being for connect direct (as i am told by infrastructure team) infrastructure is not in place.

regards
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2435
Location: Netherlands, Amstelveen

PostPosted: Fri Feb 05, 2010 3:25 pm    Post subject: Re: Reply to: Migrating data from oracle to db2
Reply with quote

tomehta wrote:
Hi Peter
from the sentence I meant we cannot use connect direct.
Reason being for connect direct (as i am told by infrastructure team) infrastructure is not in place.
regards


Well you could have been more specific about that.
Beside FTP what other tools/software for remote connections are installed?
Back to top
View user's profile Send private message
tomehta

New User


Joined: 18 Aug 2008
Posts: 98
Location: India

PostPosted: Fri Feb 05, 2010 4:15 pm    Post subject:
Reply with quote

Hi Peter
i am afraid to say that but ,FTP is the only for remote connections.

regards
Back to top
View user's profile Send private message
tomehta

New User


Joined: 18 Aug 2008
Posts: 98
Location: India

PostPosted: Fri Feb 05, 2010 5:36 pm    Post subject: Reply to: Migrating data from oracle to db2
Reply with quote

MQ connection is also available for the connection between the Unix and Zos.

Regards
Back to top
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Fri Feb 05, 2010 5:50 pm    Post subject: Re: Migrating data from oracle to db2
Reply with quote

tomehta wrote:
Whole process seems too manual to me and the chances of error seems to be very high.

Please suggest is there any other optimal way of doing it. let me know if some more info is required.


If you are nervous to loose the overview of the entire operation I would suggest that you get the activities into your job scheduler system. That way you can recieve incoming FTPs, merge data files, load tables, and run stats utilities in a predefined order and keep track on every table load.

Besides that, you probably will have the benefit of using the production technical user for the operations, and you will not have to bother getting the right user access for table administration. It will also be easier to audit what have happened, provided you have a production logging system.
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 Passing data from REXX to C programme... chong.zhou CLIST & REXX 2 Wed Jul 26, 2017 9:11 pm
No new posts Passing data from REXX to C programme... chong.zhou All Other Mainframe Topics 0 Wed Jul 26, 2017 4:55 pm
No new posts copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm


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