MySQL Forums
Forum List  »  IBM DB2

Migration Tool using wrong JDBC driver?
Posted by: andrew miller
Date: April 30, 2008 04:46AM

I am trying to migrate a DB2 database over to MySQL

Source:
Solaris 8, DB2 SUN64 8.1.6

Destination:
WinXP Pro hosting: Migration Toolkit 1.1.12, MySQL 5.1.23-rc-community, DB2 Client v9.1.401.44

Using the WinXP DB2 client (Control Center) I can connet up to my DB just fine.
Using MS Access and ODBC I can connect up to my DB just fine.

When I try to use the Migration Toolkit I get this error:

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Generic Jdbc
Opening connection ...
Connection jdbc:db2://10.0.0.208:60000/MYDB:user=MYUSER;password=MYPASS1;
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :[ibm][db2][jcc][t4][2043][11550] Exception java.net.ConnectException: Error opening socket to server /10.0.0.208 on port 60,000 with message: Connection refused: connect.
Details:
com.ibm.db2.jcc.b.xb.a(xb.java:375)
com.ibm.db2.jcc.b.xb.<init>(xb.java:76)
com.ibm.db2.jcc.b.a.w(a.java:264)
com.ibm.db2.jcc.b.b.a(b.java:1726)
com.ibm.db2.jcc.c.bb.a(bb.java:375)
com.ibm.db2.jcc.c.bb.<init>(bb.java:340)


In the Migration Toolkit I have Generic JDBC:
Class Name: com.ibm.db2.jcc.DB2Driver,
Connection String: jdbc:db2://10.0.0.208:60000/MYDB:user=MYUSER;password=MYPASS1;

Any thoughts what is going wrong here?

Options: ReplyQuote


Subject
Views
Written By
Posted
Migration Tool using wrong JDBC driver?
13021
April 30, 2008 04:46AM


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.