Catalog and Directory

The DB2 catalog and directory act as central repositories for all information about objects, authorizations, and communications regarding the support and operations of DB2.

The catalog is composed of 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 group of objects. The DB2 catalog will also contain information about communications with other DB2 and non-DB2 databases through the use of the Communications Database (CDB), which contains information about VTAM and TCP/IP addresses.

Table 2.4 shows a list of the ...

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.