Articles & Content

Archives

Real-world strategies for managing undesirable access paths (E17)

Topic: DB2 for z/OS

Subtopic: 2009



DATE: 2009-10-8 (11:00 - 12:00)
SPEAKERS: Suresh Sane (DST Systems Inc)

In a DB2 production environment, almost all software changes are Typically tightly controlled, but the impact of production binds and rebinds is not. This can result in unpredictable performance since it must be dealt with in a reactive mode. In this session, we focus on strategies to minimize the surprises and to fallback gracefully if hit with an undesirable change. This includes a discussion of the Access Path Stability feature available in DB2 9. We will mention some tools but the focus is on the design choices and The strategic planning.The focus here is not on having the right tools but on the strategic planning.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

VERSION(AUTO) - Infrastructure, Migration, Fallback

Trial collection - Infrastructure, Migration, Fallback

Hints/stats/tricks - Hints, Stats, Tricks, Advantages anddisadvantages

Package stability - Infrastructure,Description, Advantages and disadvantages

Some useful tools - IBM Bind Manager, IBM Path Checker, BMC SQL Explorer for DB2, Neon Bind Impact Expert. Best practices - Comparison, Summary, Recommendations



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.