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?
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)
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.