Join Terry Purcell, Senior Technical Staff Member, DB2 for z/OS Optimizer Development
On December 11, 2012 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. GMT / UTC
The DB2 for z/OS optimizer is continually evolving with each release, and for static SQL, REBIND is recommended to take advantage of new optimizations. But how do customers minimize their exposure to access path regression for static SQL?
What about dynamic SQL? And then there is the RUNSTATS enhancements that came in DB2 9 and then in DB2 10.
Can I model the potential impact before I get to production?
What about data sharing co-existence?
The questions are endless, and this webcast will outline how best to navigate and exploit the RUNSTATS enhancements, to make the most of Plan Management, and do proactive access path analysis - whether you are migrating from V8->9, V8->10 or 9->10.
Complimentary Whitepaper written by Terry Purcell to available for all attendees