Figure 5 2   DB2 UDB data types

MySQL data types are grouped into three categories, and can be converted to 

DB2 UDB data types following the rules suggested below:

Numeric type

  TINYINT

This is a single byte integer, DB2 UDB does not have built in single byte 

integer but SMALLINT is used for all the similar functionality.

  SMALLINT

A small integer is a two byte integer with a precision of five digits. This can 

be replaced by DB2 UDB SMALLINT.

  BIT/BOOL/BOOLEAN

These are synonyms for TINYINT(1), In DB2 UDB we use SMALLINT with 

check constraint instead of BIT/BOOL/BOOLEAN.

 Chapter 5. Database porting 

91