How can I migrate datastage 9.1 from DB2 to Oracle

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
mvrkreddy
Participant
Posts: 12
Joined: Sun Apr 13, 2014 11:46 pm

How can I migrate datastage 9.1 from DB2 to Oracle

Post by mvrkreddy »

How can I migrate datastage 9.1 from DB2 to Oracle database?.
Currently we are using datastage with Db2 on linux machine.
How can we migrate to oracle db.
Could you please help on this.
RAJESH
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Welcome aboard.

I can't imagine that would be a simple process nor something we could discuss in a post or two. I'm sure people will be along to offer advice or experience if they've done something of that sort but in the meantime I would emphatically suggest that you reach out to your Official Support Provider and get them involved in this. If you haven't already.

There may very well be some specific documentation or process available for that... officially available, that is.
-craig

"You can never have too many knives" -- Logan Nine Fingers
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

This really is a very complex task. The former IBM Concierge Services provided a migration tool that could migrate XMETA database contents, but that offering is now closed. You'd have to contact customer service to see if they can assist you.

I would also say this could be high risk. Unless absolutely necessary, it might be better to wait until your next "re-host" and swap out the database then.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
Post Reply