bash>db2icrt itso

Database partition group/node group

As the name implies it represents a container for set of partitions where the table 

space resides. This can be used if you want to spread your DB2 UDB database 

across multiple servers in a cluster or multiple nodes. There are no database 

partition group design considerations if you are using a non partitioned 

database. The nodegroup can be created within a database using:

db2>create nodegroup itsospecial on all nodes 

Database

A database represents your data as a collection of data in structured fashion. It 

includes a set of system catalog tables that describe the logical and the physical 

structure of the data, a configuration file containing environment parameter 

values used by the database, and a recovery log with ongoing and archivable 

transactions. 

Creating a database

The database in DB2 UDB can be created simply by using:

db2>create database itsodb

This command initializes a new database with a default path, and table spaces. It 

creates three initial table spaces and the system tables, and allocates the 

recovery log.

You can use the create database statement with options to personalize the 

database as shown in Example 5 1.

Example 5 1   Create database 

db2>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 )

Dropping a database

In MySQL you can drop the database using:

mysql>drop database [if exists] itsodb

 Chapter 5. Database porting 

97