Database 
Directory
DB2 Instance 
Name
NODE0000
The partition number of the db, 0 for a non partitioned database
SQL00001
The db id starts at 1 and increases for all subsequent databases
SQLOGDIR
The directory for default log files
SQLT00000.0
The SMS container for catalog tablespace
SQLT00000.1
The SMS container for default  temporary tablespace
SQLT00000.2
The SMS container for default User  tablespace
SQLLIB
symbolic link
DB2 installation path
adm
adsm
bin
bnd
cfg
conv
...
Figure 1 10   DB2 directory structure
DB2 catalog
In DB2 UDB, the metadata is stored in a set of base tables and views called the 
catalog
. The catalog contains information about the logical and physical structure 
of the database objects, object privileges, integrity information, etc. 
The catalog is automatically created with the database. The base tables are 
owned by the 
SYSIBM
 schema and stored in the 
SYSCATSPACE
 table space. On 
top of the base tables, the 
SYSCAT
 and 
SYSSTAT
 views are created. 
SYSCAT
views are the read only views that contain the object information and are found
in 
the 
SYSCAT
 schema. 
SYSSTAT
 views are updateable views containing statistical 
information that are found in the 
SYSTAT
 schema. The complete DB2 UDB 
18 
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