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.
Last edited by Marcus_A; 09-15-09 at 05:10.
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390