Articles & Content


The Diagnosis Manual - Secrets and Intrigue (B14)

Topic: DB2 for z/OS

Subtopic: 2008

DATE: 2008-10-16 (09:00 - 10:00)
SPEAKERS: Linda Hagedorn (Performance and Tuning Experts)

Understanding the internal mechanisms of DB2 gives DB2 Database Administrators and Systems Programmers greater problem solving abilities, the skill to communication the functioning of DB2 to others, and make reasoned decisions about the operation of the subsystem. It's long fallen upon DB2 technical staff to provide clear succinct answers to how and why DB2 performs certain ways under certain circumstance. This presentation describes the components of DB2, how they interact, physical layouts of data and how this affects throughput, and how to translate the messages and errors DB2 provides into search criteria for IBMLINK.

EXP. LEVEL: Advanced


Structure of DB2 - Address spaces, Resource manager, the Attaches, and the Subcomponents

At startup and shutdown, what is DB2 doing?

IBMLINK and diagnostic aids. Recognizing what DB2 is telling you, and how to translate it into an IBMLINK search

Understanding Data Manager. Page Set formats, Space Map pages, Dictionary pages and others.

Recognizing System-Agent Correlation Identifiers, and what they are.

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.