Oracle export for DB2 import

Dear experts
We are looking for a mechanism to export table content from oracle and import in db2 on a mainframe.
We would prefer to produce fixed record dumps from oracle which can be imported by the mainframe db2 loader utility.
The preferred solution would be to use: expdp, it would be great to get a sample config file to achieve fixed record length export which is importable for db2
as plan B we would have to fall back to write a small java pgm, but I'd prefer option A
Many thanks for your support
mruffAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
The only thing that can read the output from expdp is impdp.  That tool is only for use between Oracle databases.  There isn't an export to CSV option.

I think some tools like Toad has a CSV option but I'm not 100% sure.  I've never used it.

There appears to be a DB2 migration tool similar to Oracle's migration tool.  Any reason you don't want to use that?

https://www.ibm.com/developerworks/data/library/techarticle/dm-0411yip/
0
Tomas Helgi JohannssonCommented:
Hi!

What you could do and is fairly easy is to export the data in CSV file, upload the data to DB2 z/OS and load the data using the LOAD utility.
You could also use IBM Data Studio and/or IBM Data Server Manager to load the CSV file to the table. Both Data Studio and Data Server Manager are free of charge.

https://www.ibm.com/developerworks/downloads/im/data/index.html
https://www.ibm.com/developerworks/downloads/im/dsm/index.html

I work both with Oracle and DB2 both on z/OS and LUW and the way we move data between DB2 and Oracle (besides and before using the CDC replication ) is using the CSV load option.
The fixed Oracle dump  won't work as input to DB2 on z/OS.

Simple Oracle script/procedure to export data as CSV file.


Regards,
    Tomas Helgi
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
importing

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.