2009 EU

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

Oct 08, 2009 03:00 PM

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

Attachment(s)
pdf file
EU09E17.pdf   530 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.