In this case you will get an additional line in the command window stating:

mql2db2:> Database Migration Completed. Please look into the log file for 

details.

Log file name:itsodb2.db2.log.2004.02.03.09.41

Now you need to go and check the 

itsodb2.db2.log.2004.02.03.09.41

 file 

for correctness of data and a table.

Modify generated DDL

In this section we concentrate on 

mysql.create

 and 

output.mysql.create

 files 

generated by MTK under Test Mode. The first file consists of create statements 

for MySQL, and the second file contains those statements converted to DB2 

UDB.

Now, we have database create statements, the default table create, and index 

create statements, we will have a closer look at these create statements and 

change them according to our requirement. In our case we got MySQL 

statements in 

itsodb.mysql.create.2004.01.06.01.38,

 which is shown in 

Example 5 17.

Example 5 17   input database

   Table structure for table  catalog 

CREATE TABLE catalog (

  manufacturer char(14) default  0 ,

  model char(25) default NULL,

  type char(25) default NULL,

  year_from char(7) default NULL,

  year_to char(7) default NULL,

  kw char(3) default NULL,

  hp char(3) default NULL,

  ccm char(4) default NULL,

  cyl_capacity char(2) default NULL,

  motor_code char(60) default NULL,

  prodgroup char(2) default NULL,

  sku char(8) default NULL,

  dimension char(12) default NULL,

  ac char(3) default NULL,

  transmission char(3) default NULL,

  hint char(60) default NULL,

  stock int(10) unsigned default NULL,

  id int(12) unsigned NOT NULL auto_increment,

  PRIMARY KEY  (id),

  KEY manufacturer (manufacturer,model)

) TYPE=MyISAM;

120 

MySQL to DB2 UDB Conversion Guide