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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved