Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.