Articles & Content

Archives

The Diagnosis Manual - Secrets and Intrigue (B14)

Topic: 2008 EU

Subtopic: DB2 for z/OS



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

OBJECTIVES:

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.



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.