Articles & Content
Topic: 2010 EMEA
Subtopic: DB2 for z/OS
DATE: 2010-11-10 (08:30 - 09:00)
SPEAKERS: Marcel Levy (Natixis)
This is a follow-up of "No Magic to Improve DB2 for z/OS Application Performance" presented three years ago.An outsourced application had regular performance regression issues after DB2 Version 8 Migration. Access paths were not stable even with 3R rules applied. It was not easy to explain the behavior of DB2 for z/OS to Application Developers and Upper Management. Short term solution was to stabilize the best DB2 access paths, then to understand why DB2 didn't find the best access paths as usual. Now, we know why DB2 was not doing the job correctly. But please, don't blame DB2 first.
EXP. LEVEL: Intermediate
Unstable Access Paths after Version 8 Migration
Choice between several Access Paths
Collecting DB2 Statistics
Workarounds for ever?
Solving the problem
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.