0 Replies Latest reply: Mar 12, 2011 7:31 PM by user12011214 RSS

    DB2 UDB 9.1 on z/OS to Oracle 11.2 on AIX

      Dear All,

      Need a road map for migration of DB2 UDB 9.1 on z/OS to Oracle 11.2 on AIX. It isn't a data migration, It is all about the application migration which would include DB2 UDB's - Table(Just the master data alone and will not include application data), Views, Procedures (Cobol 390 - code) , Batch jobs to Oracle 11.2.

      Current i dint find any tool which supports DB2 UDB 9.1 on z/OS to Oracle 11.2. The db2 code is huge(More than 100 Procedures and some 25 Procedure are atleast of 25000 lines of code each). It's a huge application.

      Tools which i have analyzed

      SQL Developer / Oracle Work Bench - Doesn't support DB2 UDB 9.1 on z/OS.

      If i have nothing left, i will be forced to re-write the entire application in plsql. If that is the case will the Cobol 390 (Batch Jobs) would be converted into Proc C* or Shell Scripting in AIX ?

      Let me know if any tool is avaliable to convert DB2 UDB/Cobol-390 into plsql. Please let me know the best way to migrate.