There are many reserved words in MySQL and DB2 UDB which cannot 

be a valid name for the column and database element. Please refer 

MySQL and DB2 UDB Reference guide for more detail about reserved 

words and change the conflicting names in the DDL statements.

Create database and database objects

Now that you have DDL statements modified, you are ready to create the DB2 

UDB database and database objects. This can be done from command line 

processor (CLP).

It is a common practice to place the database and table space creation 

statements in one file and tables, views etc. creation statements in a separate 

file. The database and table spaces will be created first. Once the database and 

table spaces are in place, the tables, views etc., other objects will be created. 

The database creation scripts should be based on the logical and physical 

database design. In our example, we created database using the 

create database.sql 

script as shown in Example 5 13.

Example 5 13   create database.sql script

   Create the Initial Database

create database itsodb

  catalog tablespace managed by system

  using ( /home/itsodb/database/catalog ) extentsize 16 prefetchsize 16

  user tablespace managed by system

  using ( /home/itsodb/database/user4K ) extentsize 16 prefetchsize 16

  temporary tablespace managed by system

  using ( /home/itsodb/database/temp )

connect to itsodb

   Create a Bufferpool with 8K and 16K Pages

create bufferpool itsodb8k size 2000 pagesize 8192

create bufferpool itsodb16k size 1000 pagesize 16384

   Make the Bufferpool Change Take Effect

disconnect itsodb

connect to itsodb

   Create a Tablespace with 8K and 16K Pages

create regular tablespace itsodb8k pagesize 8192 managed by system

  using ( /home/itso/database/user8K )

  extentsize 8 prefetchsize 8 bufferpool itsodb8k

create regular tablespace itsodb8k pagesize 16384 managed by system

  using ( /home/itso/database/user16K )

  extentsize 8 prefetchsize 8 bufferpool itsodb16k

 Chapter 5. Database porting 

115