How to migrate db from mysql to db2

I want to migrate Database from mysql to Db2.

I need to do it using开发者_C百科 CLP and also without any tool. Can anyone help.

Thanks in advance.

You can use the IBM Data Movement Tool.

Follow the directions in this article.

If you really want to do it without the tool (I don't recommend this) then at a minimum you'll need to:

• create storage in db2 (databases, tablespaces, etc.) that match your mysql database
• look at your tables and translate any column types from their mysql types to DB2 types
• make sure you recreate any indexes, key contraints, triggers
• translate any other stored procedures and other database objects

This article has some information on data mapping to mysql.