Porting 

preparation

and 

installation

Database

structure

porting

Data

porting

Application

porting

Basic

administration

Testing

and

tuning

Figure 2 2   Steps of the migration process

2.4.1  Porting preparation and installation

After deciding which target system you want to use, you can set up the following: 

Install the hardware, the operating system with users and access rights, the 

network connections, any used software, and finally the DB2 UDB version of 

your choice.

2.4.2  Database structure porting

Once the DB2 UDB is installed in the target, you can port the database structure 

from the source MySQL database to DB2 UDB.

The database structure is usually described by 

Database Definition Language 

(DDL) 

statements. DDL scripts include the creation of tables, keys, and indexes. 

Since the DDL syntax for MySQL and DB2 UDB is different, a converting process 

is required. Using a tool to port database structure can save time and effort. 

Figure 2 3 shows the database structure porting the basic steps.

 Chapter 2. Planning the migration from MySQL to DB2 UDB 

55