Capture the database schema information from MySQL.

Modify schema information for DB2 UDB.

Create the database in DB2 UDB with structure.

5.4.1  Automatic conversion using porting tools

Using porting tool is the most common and easiest of all the approaches. The 

IBM DB2 Migration Toolkit (MTK) simplify your migration to DB2 UDB. There are 

a number of third party migration tools available in market which can be used but 

IBM does not guarantee the correct functionality of these tools.

MTK for MySQL

IBM DB2 Migration Toolkit (MTK) for MySQL is a simple migration tool that takes 

the MySQL database to be migrated and the new DB2 UDB database to be 

created as input parameters. With MTK, you can automatically convert data 

types, tables, columns, views and indexes into equivalent DB2 UDB database 

elements. MTK provides database administrators (DBAs) and application 

programmers the functionality needed to automate the migration task. You can 

reduce the downtime, eliminate human error, and cut back on person hours and 

other resources associated with the database migration by using the following 

features found in the MTK:

Extract database metadata from source DDL statements using direct source 

database access or imported SQL scripts.

Automate the conversion of database object definitions.

Generate and run data movement scripts

Track the status of object conversions and data movement, including error 

messages, error location, and DDL change reports, using the migration log.

Download, installation and usage instructions for MTK are available in Chapter 4, 

Section 4.3,  MTK installation and usage  on page 87.

The database structure migeration process using MTK is as follow:

The MTK will first connect to MySQL database using the specified user and 

password (the current user if none is specified) and dump all the DDL and 

data using the 

mysqldump

 utility. It will store this DDL output in a file in the 

current directory with the name 

.mysql.create.

. It stores MySQL 

load files for all the data in the tables in the current directory with the names 

.txt.

 mysql:daemon needs full write permission to the directory 

stores these files During migration, you can use 

chmod 777 

command to give the write access and then change it back later. 

112 

MySQL to DB2 UDB Conversion Guide