Create DB2 database structure

Once you have the DDL scripts in DB2 syntax, you should create your DB2 UDB 

database and run the DDL scripts to create the database structure.

This part is again supported by tools like MTK. Be sure to check the success of 

the creation of all database objects like tables, keys, and indexes.

2.4.3  Data porting

With the database installed on your new system and the structure of your 

database created, you should migrate the data from the source to the target 

system.

Databases usually provide mechanisms for exporting (dumping) and importing 

(loading) data. We categorized the MySQL data into:

User data: Data about users, access rights, and privileges

Application data: Data that is created and used by an application

Figure 2 4 shows the basic steps of data porting.

MySQL

database

MySQL

user

Export user data

data

(mysqldump)

DB2

script

Convert to

DB2 commands

DB2

Run DB2 script

database

Basic

data

checking

MySQL

Export application data

Import application data

application 

(mysqldump/MTK)

data

(db2load/MTK)

Figure 2 4   Data porting process

 Chapter 2. Planning the migration from MySQL to DB2 UDB 

57