My understanding is that there is currently no automated migration utility for moving from a DB2 to Oracle runtime database, and that a manual migration is not supported by IBM.

However, has anyone had any success in doing a migration "on your own"?

We have a runtime database that has tens of thousands of processes on any given day and would like to move it to Oracle for maintenance reasons (we are an Oracle shop). Starting from a clean database is not a desirable proposition for us.

We attempted a manual migration by creating the Oracle table structure, and exporting/importing the data. However, we could not bring up the servers.

Thanks in advance for your comments.

Brian,

we recently had a customer who made this approach.
However they eventually gave up and did a 'manual' migration of their
data.
The risk to produce invalid data was too high.

There is no 1:1 mapping of DB2 to Oracle content because of the internal
differences
between the products of the two database vendors.

My recommendation is, to write a tool for a 'manual' migration of your
data to Oracle.

Volker Hoss
IBM WebSphere Process Server Development

Thank you Volker.

By writing a tool to do a manual migration, do I understand you to mean use the API to re-create, route, and assign the existing processes?

Brian,

yes, that is exactly what I meant.

Volker Hoss
IBM WebSphere Process Server Development