DB2 Directory and Catalog

Directory

The DB2 directory contains information that DB2 uses during normal operation. You cannot access the directory by using SQL, although much of the same information is contained in the DB2 catalog, for which you can submit queries. The structures in the directory are not described in the DB2 catalog.

DB2 directory里存放的是DB2常规操作所需的一些信息。用户不能通过SQL访问这些内容，但是大部分这些信息在catalog里也有，可以通过query查询出来。但structures只存在与directory里，并没有在catalog进行描述。
The directory consists of a set of DB2 tables that are stored in five table spaces in system database DSNDB01. Each of the table spaces that are listed in the following table is contained in a VSAM linear data set.

Directory包括一组DB2系统表，存在于系统数据库DSNDB01的五个表空间中。每个表空间都是一个VSAM的LDS数据集，如表1所示：

The directory contains table spaces that hold DBDs(DBD01), Plans(SCT02), Packages(SPT01), information about utilities(SYSUTILX) and system log range records(SYSLGRNX). This data cannot be queried through SQL, only through DB2 commands.

Directory包括以下五个表空间：DBD01(存放DBD)，SCT02(存放Plan)，SPT01(存放package)，SYSUTILX(存放关于utility的信息)和SYSLGRNX(存放系统日志记录)。这些数据不能通过SQL查询，只能通过DB2命令。

Table 1. Directory Table Spaces

Catalog

DB2 maintains a set of tables that contain information about the data that DB2
controls. These tables are collectively known as the catalog. The catalog tables
contain information about DB2 objects such as tables, views, and indexes. When
you create, alter, or drop an object, DB2 inserts, updates, or deletes rows of the
catalog that describe the object.

DB2维护了一组表，这些表记录了DB2所管理的数据的信息。这些表统称为catalog。Catalog表记录了DB2对象的信息，包括表、视图和索引等。当用户创建、更改或者删除出一个对象，DB2就会插入、更新或者删除catalog中描述这个对象的若干行。

The DB2 catalog consists of tables of data about everything defined to the DB2
system, including table spaces, indexes, tables, copies of table spaces and indexes,
and storage groups. The system database DSNDB06 contains the DB2 catalog.

DB2 catalog表记录了DB2系统中定义的所有信息，包括表空间、索引、表、表空间和所以的副本、storage group。DB2 catalog存在于系统数据库DSNDB06中。

Table 2. Catalog Table Spaces

“DB2 catalog table“(DB2 SQL Reference)

There are just so many relationships that exist in the catalog and directory, both Referential Integrity (RI) and other. Databases, along with all the tablespaces, tables, indexes, etc. that are created in them, become Database Descriptors (DBDs). The DBD is in DSNDB01.DBD01 while most of the other definitions are in DSNDB06.SYSDBASE. Plan and package detail can be found in DSNDB06. SYSPLAN and DSNDB06.SYSPKAGE while the actual plans and packages reside in DSNDB01.SCT01 and DSNDB01.SPT01.

Catalog和Directory之间存在着很多联系，包括参照完整性(RI)等。数据库，还有表空间、表、索引等，所以创建在系统中的，都会变成DBD。DBD存在于DSNDB01.DBD01里，但是大部分其他定义存在于 DSNDB06.SYSDBASE中。Plan和Package的信息可以在 DSNDB06. SYSPLAN和 DSNDB06.SYSPKAGE中查到，但是实际的plan和package存在于 DSNDB01.SCT01和DSNDB01.SPT01内。