Porting database from iSeries to Windows/Linux...

[b***@swbanktx.com]

I need to port a database from the iSeries to run on DB 2 for Windows / Linux... does anyone know of any tools/utils that assist with moving the tables/indexes/views/stored procs/UDFs/etc from iSeries to DB2 on Windows and/or Linux?

Thanks

[Willy Unger]

I've used Embarcadero's ER Studio, which will help you PART of the way, for example you should create tablepaces for each large table or groups of "similar"tables.

The iSeries-supplied graphical client will also generate DDL for most iSeries DB2-related objects.

You may have to add delimiter overrides other that ';' for stored procs, UDB needs different delimters for statements inside the proc, otherwise it gets confused.


Best Regards,

Willy Unger

DB2 Certified Specialist
***@yahoo.com