application or a user connects to a specified database to read or manipulate 
data in tables.
Figure 1 5 shows the relationship between instances, databases, and tables.
Server system
User,
Application
Database Manager 
I
I
ns
n
t
st
an
a
c
n
e
ce
...
...
I
I
ns
n
t
st
an
a
c
n
e
ce
Instances
connect to
...
Databases
...
...
Tables
...
Figure 1 5   Relationship between instances, databases, and tables
Database partition groups
A database partition group is a set of one or more database partitions 
(Figure 1 6). Before creating tables for the database, you first need to create 
the database partition group where the table spaces will be stored, and then 
create the table space where the tables will be stored. If a partition group is 
not specified, there is a default group where table spaces are allocated. In 
earlier versions of DB2, database partition groups were known as 
nodegroups
. In a non partitioned environment, all the data resides in a single 
partition, therefore it is not necessary to worry about partition groups.
12 
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