Use the following link to get an initial idea how to use our SQL-Developer tool to migrate data from DB2.
What is mainframe DB2 details?
is it Z/OS or DB2 i. Could you please share those details as well.
Also do you have stored procedures to be converted to Oracle as well?
1 person found this helpful
The SQL*Developer doesn't currently support the migration of DB2 from zOS or iSeries.
If you have access to My Oracle Support then the following notes have some alternative suggestions -
How To Migrate Non-Oracle Databases For Which a SQL*Developer or Migration Workbench Option Is Not Available (Doc ID 393760.1)
Migration from DB2 on IBM z/OS (OS/390) to Oracle (Doc ID 200288.1)
Mainframe DB2 - 175MIPS v10
There are BLOB data types, stored procedures and packages
Thanks for additional MIPS info. Sql-Developer has limited support on DB2 mainframe. We have other preferred vendors and third party tools available to help you folks to move out of MF to Oracle stack.
Feel free to reach me at firstname.lastname@example.org. PMG group will be glad to help you further. Our service is no cost to you.
I will be glad to help you further. Yes our technology can support loading Blobs and converting SPs and packages.
For the Mainframe part GG can be a good option, though the cost is huge. The other options I guess for a huge database of 1Tb will be too much time consuming.
Does DB2 on Mainframe has any proprietary tools to extract data into flat files from where Oracle sql*loader can take over?