Please make sure that the number of rows read equals the number of rows 

committed. This should also equal to the number of records in the MySQL source 

table. Example 6 18 shows the MySQL command for the record count.

Example 6 18   Retrieving the number of records from MySQL

mysql> select count(*) from catalog;

+          +

| count(*) |

+          +

|       21 |

+          +

1 row in set (0.00 sec)

mysql> select count(*) from oenumber;

+          +

| count(*) |

+          +

|     8771 |

+          +

1 row in set (0.00 sec)

mysql> select count(*) from users;

+          +

| count(*) |

+          +

|        8 |

+          +

1 row in set (0.00 sec)

mysql> select count(*) from shopping_cart;

+          +

| count(*) |

+          +

|        3 |

+          +

1 row in set (0.04 sec)

After you have checked that all the records were loaded into DB2 UDB, you 

should check sample data in each migrated table if the values are correct, 

especially if you have any time values or decimal values. Example 6 19 shows 

the table content checking.

152 

MySQL to DB2 UDB Conversion Guide