DB2 for z/OS

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

May 14, 2010 03:00 PM

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

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

Related Entries and Links

No Related Resource entered.