MySQL Forums
Forum List  »  IBM DB2

Re: Migration Toolkit using JDBC from DB2(UDB) to MySQL (SOLVED)
Posted by: Ed Magos
Date: May 24, 2006 06:02PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Migration Toolkit using JDBC from DB2(UDB) to MySQL (SOLVED)
10599
May 24, 2006 06:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.