Database
Database 
Database 
Database
Partition
Partition
Database
Partion Group 2
Partion Group 1
Database 
Partition
Database 
Partition
Database
Partion Group 3
Database 
Partition
Figure 1 6   Database partition groups in a database
System catalog tables
Each database includes a set of system catalog tables, which describe the 
logical and physical structure of the data. DB2 UDB creates and maintains an 
extensive set of system catalog tables for each database. These tables 
contain information about the definitions of database objects such as user 
tables, views, and indexes, as well as security information about the privilege 
that users have on these objects. Catalog tables are created when the 
database is created, and are updated during the course of normal operation. 
You cannot explicitly create or drop them, but you can query and view their 
contents using the catalog views.
Table spaces
A database is organized into subdivided table spaces. A table space is a 
place to store data. When creating a table, you can decide to have certain 
objects such as indexes and large object (LOB) data kept separately from the 
rest of the table data. A table space can also be spread over one or more 
physical storage devices. 
 Chapter 1. Introduction 
13






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