Articles & Content
Topic: 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
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.