Create a System Temporary Tablespace with 8K and 16K Pages

create system temporary tablespace itsotemp8k pagesize 8 K managed by system

  using ( /home/itso/database/temp8K )

  extentsize 32 prefetchsize 16 bufferpool itsodb8K

create system temporary tablespace itsotemp16k pagesize 16 K managed by system

  using ( /home/itso/database/temp16K )

  extentsize 32 prefetchsize 16 bufferpool itsodb16K

disconnect itsodb

To create database, invoke the above SQL script from DB2 UDB Command Line 

Window or bash shell by using.

db2>@create database.sql

bash>db2  f create database.sql

We then pick up database object creation statements from the output of 

mysqldump, 

mysqlobjects.ddl

 file and create

 db2objects.ddl

 script. Change the 

DDL statements and data types following section 5.1 and 5.2 of this chapter

. 

You 

can create any additional statement required.

Now we execute the above created DDL scirpts from DB2 Command Line 

Window or bash shell as shown in Example 5 14 and Example 5 15 below.

Example 5 14   create database objects from DB2 command line window

db2>connect to itsodb

db2>@db2objects.ddl

db2>disconnect itsodb

Example 5 15   create database objects from bash shell

bash>db2 connect to itsodb

bash>db2  tf db2objects.ddl

bash>db2 disconnect itsodb

5.4.3  Metadata transport

In this section we discuss about using the database modelling tool for the 

migration of a database structure from MySQL to DB2 UDB. There are number of 

modelling tools existing in market which supports capturing of database model 

from MySQL database. In most of the tools a logical model defines the database 

design and physical model maps to the target database.

IBM Rational  Rose  Professional Data Modeler Edition

116 

MySQL to DB2 UDB Conversion Guide