System Structure

>Catalog database (DSNDB06)

                SYSIBM.SYSCOPY ,

SYSIBM.SSYSDATABASE,

SYSIBM.SYSTABLESPACE….. etc

>Workfile database(DSNDB07)

>Default database(DSNDB04)

>Directory database(DSNDB01)

                SCT02

                SPT01

                SYSLGNRX

                SYSUTILX

                DBD01



BSDS
ACTIVE LOGS and ARCHIVE LOGS

Bufferpools  >> It defines page size

4k -> BP0-BP49                                  = 50

8k -> BP8K0 – BP8K9                       =10

168k -> BP16K0 – BP16K9              =10

32k -> BP32K0 – BP32K9                =10

 

> What is DB2 catalog?

The catalog comprises several DB2 tables and can be accessed via SQL. The catalog contains details about DB2 objects obtained from the DDL (Data Definition Language) when an object is created or altered or from DCL (Data Control Language) when an authorization is granted on an object or a group of objects.

> What is DB2 Directory?

The DB2 directory is used to store information about the operation and housekeeping of the DB2 environment. This directory, unlike the DB2 catalog, cannot be accessed by using SQL. The DB2 directory contains information required to start DB2; activities and utilities in the DB2 environment do the updating and deleting of table entries in the DB2 directory.