For demonstration purposes we describe a step by step process using MTK and 

then describe manual method for additional objects, which are not converted 

using MTK: 

Starting MTK

/home/itsosj/mtk/Mysql2UDB

This will launch MTK Java application window as shown in Figure 5 6.

Figure 5 6   MTK startup window

Enter Database name, User name, Password, Data path, and select the 

option 

Test mode Does not deploy to DB2

.

With the 

Test Mode Does not deploy to DB2

 option selected, MTK will 

generate DB2 DDL in a file, and will not execute the DDL to create the DB2 

database structure. This allows you to change the data type, any column 

names, or add any additional statements to add DB2 objects. Now click 

OK.

The message box as shown in Figure 5 7 is displayed.

118 

MySQL to DB2 UDB Conversion Guide