Articles & Content


A 411 on the DB2 Directory (F10)

Topic: DB2 for z/OS

Subtopic: 2010

DATE: 2010-5-13 (09:45 AM - 10:45 AM)
SPEAKERS: William Arledge (BMC Software)

Metadata stored in the DB2 Catalog is very well known and easy to interrogate using SQL. However, at run time, DB2 makes extensive use of the other primary DB2 system database, the Directory or DSNDB01. This presentation describes the contents of the Directory, explains how to look at its contents, and discusses how you can improve your overall system performance and recovery times by paying a little more attention to this often forgotten resource.

EXP. LEVEL: Beginner


DB2 Catalog and Directory Introductory Information will include an overview of the Catalog and Directory and provide comparisons between the two system databases

Directory Detailed Structure and Contents will go through each of the directory tablespaces/tables in some detail with information on what is actually stored there

Utility considerations for Directory Tablespaces will discuss the standard utilities like COPY, REORG, and RECOVER as well as service aids used to report on directory information

DB2 Commands for Directory Structures will discuss the commands that affect the different directory structures

Performance Considerations for Directory Spaces discussed performance monitoring and tuning considerations for directory structures in the DBM1 address space

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.