Articles & Content

Archives

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

Topic: 2010 NA

Subtopic: DB2 for z/OS



DATE: 2010-5-14 (11:00 AM - 12:00 PM)
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 and disadvantages

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



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.