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