I have been receiving many requests for information on migrating IBM z/OS DB2 databases to Oracle so I thought this would be a great topic.
Third Party Tool Solutions
- I have worked with there tool before and it is solid. They offer services as well.
Third Party SI Providers (with their own tools)
1.Prac Trans - Prac Trans
- I have worked a lot with this company. They have both internal tools to migrate db2 z/OS and very skilled mainframe DB2 resources.
A. Oracle ART Tuxedo Workbench - Oracle ART Workbench
Note: This costs minimum of $80K for two developer licenses.
Solution is disk to disk based.
B. Oracle Warehouse Builder - Free Oracle database ETL tool. You would use JDBC as listed here:
OWB supports importing of COBOL copybooks where DB2 tables are often defined. NOTE: JDBC connection to mainframe DB2 can be slow.
Solution can be disk to Oracle DB or DB2 to Oracle (stream based).
C. Oracle DRDA Gateway - Connect to DB2 on mainframe from Oracle and use Select statements to migrate (nothing to install on mainframe) Oracle DRDA Gateway
Solutions is stream based/disk less.
D. Oracle Data Integrator - No DB2 Knowledge built for DB2 mainframe but one could be developed.