Some advice on working with MySQL Migration Toolkit for migrating IBM DB2 on AS400/iSeries to MySQL:
1. Download JTOpen, the open Source version of the IBM Toolbox for Java from
http://jt400.sourceforge.net/. At time of writing this is jtopen_4_9.zip
2. Unzip the toolkit and copy the *.jar files to Your Java class path for the Migration Toolkit, i.e. C:\Programme\MySQL\MySQL Migration Toolkit 1.0\java\lib on Windows, if You have choosen standard installation options
3. Start the Migration toolkit and configure source database:
Database System: Generic Jdbc
Class name: com.ibm.as400.access.AS400JDBCDriver
Connection String: jdbc:as400://iSeries_hostname/;
4. Configure target database
5. Connection progress; You will be prompted for the user/password to connect to the iSeries/AS400.
6. Choose the database You want to migrate
7. etc.
That's all!!!Categories: Laravel IBMI Toolkit