• Dec 11, 2012 from 4:00pm to 5:00pm
  • Location: Live webcast
  • Latest Activity: Sep 2, 2021

Join  Terry Purcell, Senior Technical Staff Member, DB2 for z/OS Optimizer Development

Register Now - Limited Places

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

Votes: 0
E-mail me when people leave their comments –

You need to be a member of Mainframe User Community to add comments!

Join Mainframe User Community