Best way to migrate big data from Oracle to DB2 for i

5 pts.
Tags:
AS/400 DB2
AS/400 migration
Big Data
Hi. I've tried some methods (SQL, plain text files...) but, I'd like to be sure on what is the best method to implement a migration of big data files.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

In Oracle (or whatever SQL product) create a SELECT statement and save this to your local PC as a text file.  The select statement output would be “Insert into yourLib/yourFile (Field1, Field2, Field3 …) values (nnn, ‘Character(s)’, ‘Characters’ …).  What you are trying to do is read the table and output the Insert Into statement that will be used on the IBM i.

For all character fields you will have to scan and replace the ‘ with \’ field.

Using Rational Developer for I (RDi) import your save file by doing a copy/paste from the local text file.  Run on the IBM i.  You could use Operations Navigator to run the SQL statement as well.

Start with small file(s)/table(s) and progress to bigger files.

You may want to look at XML to export the data and import the data as an option if Oracle gives you this option.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: