Migration from Mysql to db2 express-c

**Serge Rielau** · Mar 23 '08, 11:05 PM

Re: Migration from Mysql to db2 express-c

Christian Welzel wrote:

Hi there,
>
i currently evaluating db2 express-c and therefor i wanted to migrate my
current database from mysql5 to the express-c... i didn't get it working
with mysqldump, and finally found the ibm data migration toolkit. But
whenever i want to start the conversation i get this exception:
>
Sun Mar 23 23:07:28 CET 2008 ERROR MySQL TRANSLATOR Translator Internal Exception
java.lang.NullP ointerException
at com.ibm.mtk.tra nslation.source .common.types.U nsignedDoubleTy pe.convert(Unsi gnedDoubleType. java:75)
at com.ibm.mtk.tra nslation.source .common.ast.exp r.SrcExpression .translateToDB2 WithContextForU nknown(SrcExpre ssion.java:125)
at com.ibm.mtk.tra nslation.source .common.ast.exp r.SrcExpression .translateToDB2 (SrcExpression. java:100)
at com.ibm.mtk.tra nslation.source .common.ast.sql .SrcColumnDef.t ranslateDefault Expression(SrcC olumnDef.java:4 48)
at com.ibm.mtk.tra nslation.source .common.ast.sql .SrcColumnDef.t ranslateToDB2(S rcColumnDef.jav a:328)
at com.ibm.mtk.tra nslation.source .common.ast.sql .SrcCreateTable Stmt.translateC olumns(SrcCreat eTableStmt.java :777)
at com.ibm.mtk.tra nslation.source .mysql.ast.sql. MySQLCreateTabl eStmt.translate Columns(MySQLCr eateTableStmt.j ava:88)
at com.ibm.mtk.tra nslation.source .common.ast.sql .SrcCreateTable Stmt.TranslateT oDB2Table(SrcCr eateTableStmt.j ava:746)
at com.ibm.mtk.tra nslation.source .common.ast.sql .SrcCreateTable Stmt.translateC reateTable(SrcC reateTableStmt. java:732)
at com.ibm.mtk.tra nslation.source .common.ast.sql .SrcCreateTable Stmt.translateT oDB2(SrcCreateT ableStmt.java:4 29)
at com.ibm.mtk.tra nslation.source .mysql.grammars .MySQLASTWalker .statement_chec k(MySQLASTWalke r.java:240)
at com.ibm.mtk.tra nslation.source .mysql.grammars .MySQLASTWalker .statement_list (MySQLASTWalker .java:211)
at com.ibm.mtk.tra nslation.source .mysql.grammars .MySQLASTWalker .dofile(MySQLAS TWalker.java:19 2)
at com.ibm.mtk.tra nslation.source .mysql.grammars .MySQLASTWalker .mysql_ast(MySQ LASTWalker.java :150)
at com.ibm.mtk.tra nslation.source .mysql.MySQLTra nslator.walkTre e(MySQLTranslat or.java:180)
at com.ibm.mtk.tra nslation.source .common.Transla tor.convert(Tra nslator.java:39 8)
at com.ibm.mtk.mod el.translation. MTKTranslationE xtensionMySQL.t ranslateExecute (MTKTranslation ExtensionMySQL. java:294)
at com.ibm.mtk.mod el.translation. MTKTranslationM odelElement.tra nslate(MTKTrans lationModelElem ent.java:311)
at com.ibm.mtk.wiz ard.MTKWizardMo del.startTransl ator(MTKWizardM odel.java:716)
at com.ibm.mtk.wiz ard.MTKWizardTa skToRun.startTr anslator(MTKWiz ardTaskToRun.ja va:289)
at com.ibm.mtk.wiz ard.MTKWizardTa skToRun.access$ 300(MTKWizardTa skToRun.java:30 )
at com.ibm.mtk.wiz ard.MTKWizardTa skToRun$ActualT ask.<init>(MTKW izardTaskToRun. java:194)
at com.ibm.mtk.wiz ard.MTKWizardTa skToRun$1.const ruct(MTKWizardT askToRun.java:1 72)
at com.ibm.mtk.uti l.SwingWorker$2 .run(SwingWorke r.java:128)
at java.lang.Threa d.run(Thread.ja va:595)
>
Does anybody has an hint, how to fix this?
>

Christian,

send a note to mtk@us.ibm.com.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Migration from Mysql to db2 express-c

Migration from Mysql to db2 express-c

Comment