Articles & Content


A 411 on the DB2 Directory (F10)

Topic: 2010 NA

Subtopic: DB2 for z/OS

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

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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