Re: Migration Toolkit using JDBC from DB2(UDB) to MySQL (SOLVED)

[Ed Magos]

Hello all,

I've found a solution. I realized the the Windows DB2 client installed a DB2 JDBC driver. I'm not sure where it will be installed but you can do a search for db2jcc.jar and db2jcc_license_cu.jar. Once you find these you need to add them to your classpath.

Here is some info on how to do that:
set CLASSPATH=%CLASSPATH%;c:\db2jdbc\db2jcc.jar;c:\db2jdbc\db2jcc_license_cu.jar;

Then using the MySQL Migration Toolkit I selected "Generic JDBC" drivers.

For the class name I used: com.ibm.db2.jcc.DB2Driver

For the connection string I used:

jdbc:db2://255.255.255.255:50000/dbname:user=username;password=password;

Basically 255.255.255.255 is your server IP address or domain name.

After that I had a connection. Hope that is helpful to the next newbie.

-Ed