Although MySQL is becoming more and more popular with Microsoft Windows 

installations, it is mostly a part of LAMP (Linux, Apache, MySQL, 

PHP/Perl/Python), an open source enterprise software stack. 

The  LAMP  software stack and additional software we use in our migration 

scenario is as follows:

SuSE Linux 8.1 e

Apache 1.3.26 (included in SuSE Linux)

MySQL Standard 4.0.17 (MySQL AB)

PHP 4.2.2

DB2 UDB Enterprise Server Edition 8.1

IBM DB2 Migration Toolkit (MTK)

DB2 for Linux can be downloaded from the Web site 

http://ibm.com/db2/v8

. 

Further information on installing and maintaining DB2 for Linux can be found on 

the Web site:

http://ibm.com/db2/linux

IBM DB2 Migration Toolkit (MTK) is available free of charge from IBM at the 

following URL: 

http://www.ibm.com/software/data/db2/migration/mtk

 and is 

used to simplify and improve the migration from MySQL to DB2 Universal 

Database (UDB).

With MTK, the conversion of database objects such as tables and data types, 

and the migration of data can be done automatically into equivalent DB2 

database objects.

The installation and configuration of DB2 UDB and the MTK is covered in 

Chapter 4,  Installation  on page 75.

 Chapter 3. Migration scenario 

73