Hi All,

Can you suggest any resources/references for migrating the DB2 database (schema and data) from a mainframe box to a Unix box?

What are the various tools/techniques required to achieve this?

Thanks for your help.

Krishna

This has been answered several time before in detail. I have done this and I am absolutely convinced that the best way is set up a connection from AIX to the mainframe database using DB2 Connect (if you have version 8.x ESE it comes with a free license) and and then exporting the data in IXF format from the AIX command line (you can also do this on Windows and move the IXF files to AIX later). Then use replace_create on the import/load. You may have to add some of the DDL manually such as foreign keys and some indexes, triggers, SP's, etc.