Preface

This IBM Redbook is an informative guide that describes how to migrate the 

database system from MySQL to DB2  UDB Version 8.1 on Linux, and how to 

convert applications to use DB2 UDB instead of MySQL.

This guide presents the best practices in migration strategy and planning, 

migration tools, porting steps, and practical migration examples. It is intended for 

technical staff involved in a MySQL to DB2 UDB conversion project.

This redbook is organized as follows:

Chapter 1

 gives an introduction to the DB2 UDB and MySQL database 

systems.

Chapter 2

 talks about the planning of a migration project from MySQL to DB2 

UDB and considerations, which have to be made before migrating.

Chapter 3

 introduces our sample project, which is used as an example for the 

migration steps throughout the rest of the redbook.

Chapter 4

 guides through the installation of DB2 UDB and other software 

needed for the migration project.

Chapter 5

 discusses the porting of the database structure and differences in 

data types in detail.

Chapter 6

 provides information about porting the data from MySQL to DB2 

UDB and how to set up the DB2 database security according to the MySQL 

user account management.

Chapter 7

 gives detailed information about porting applications. SQL 

differences are discussed as well as porting considerations for different 

programming languages such as Perl, PHP, Java , and C/C++.

Chapter 8

 talks about DB2 database administration.

Chapter 9

 details steps for testing and tuning of your migrated application 

and database system.

Chapter 10

 introduces advanced DB2 UDB features that can be used in order 

to enhance ported applications.

  Copyright IBM Corp. 2004. All rights reserved.

xv