Hello Esteemed Listers,
Have also cross posted this to the Mainframe DB2 community.
We have been asked to look into the feasibility and the method of
migrating a SYBASE application to DB2. It is also being debated
whether the application
should be converted to UDB for LUW or DB2 for OS/390. We are looking
at IBM's MTK (Migration toolkit) for conversion. Had some specific
questions regarding
this:
1. Does this toolkit support migration to DB2 for OS/390 (V7.1) or
does it only support migration to UDB for LUW. If IBM MTK does not
support migration to DB2 for OS/390, is there any alternate tool
available which can do the same.
2. Is there anyone who has actually performed SYBASE to DB2 for OS/390
conversion and would they be so kind to share their experiences;
especially vis a vis the amount of manual effort required for
converting the database objects (the SYBASE database being converted
has triggers and stored procedures coded in Transact-SQL, I believe,
which could be a problem
area). Any ballpark estimates on the actual effort required. In SYBASE
database here, there are around 150 Stored procedures and around 120
triggers.
3. Is it 'easier' (in terms of effort required) to migrate to DB2 for
OS/390 or to UDB for LUW. In either cases, what are the pros of one
over the other.
Any other experience which could be useful to us in this regard.
Thank you so much.
Raquel.