Figure 5 7   MTK Message window

On completion of above task, you will see the successful migration window 

and output as shown in Example 5 16.

Example 5 16   MTK output console

mysql2db2:> Grabbing MySQLdump output... Done.

mysql2db2:> Parsing Dump Files...

mysql2db2:> *  > Parsed CREATE statement for Table: catalog

mysql2db2:> *  > Parsed CREATE statement for Table: oenummer

mysql2db2:> *  > Parsed CREATE statement for Table: users

mysql2db2:> *  > Parsed CREATE statement for Table: shopping_cart

mysql2db2:> *  > Parsed CREATE statement for Index: manufacturer

mysql2db2:> *  > Parsed CREATE statement for Index: sku

mysql2db2:> *  > Parsed CREATE statement for Index: name

mysql2db2:> *  > Parsed CREATE statement for Index: sc_id

mysql2db2:> Database Test Migration Successful.

In Test mode option, MTK will generate a number of files:

  .

mysql.create

.

output.mysql.create

.

  data file corresponding to each table

This allows you to examine the DDL generated by MTK. The DDL can be run 

in later time to create DB2 database and object.

If you want MTK to create DB2 objects and move the data for you, select 

Quiet Mode   turn off output trace

 after lunch to MTK (see Figure 5 6). MTK 

will automatically create the DB2 database and load data into it. The final 

window as shown in Figure 5 8 will mark the completion.

Figure 5 8   MTK success message

 Chapter 5. Database porting 

119