Articles & Content
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.