• Apr 3, 2018 from 10:00am to 2:00pm
  • Location: Pacific Life - Fashion Island
  • Latest Activity: Sep 2, 2021

No Cost - RSVP to reserve a seat and lunch to: Mark.Depledge@ca.com 
Tuesday, April 3, 2018, 10:00am - 2:00pm 
Pacific Life 
700 Newport Center Drive 
Newport Beach, CA 92660 

Parking – Free parking is also available at Newport Beach Fashion Island 


10:00am - 11:30am: z/OS - “Db2 12 for z/OS Optimizer Update” -
Terry Purcell, IBM

 
11:30am – 12:30pm: Free Lunch hosted by CA technologies 


12:30pm - 2:00pm: z/OS - “Runstats Challenges for Optimal Query Performance” - Terry Purcell, IBM 


Speaker:Terry Purcell, IBM 
Terry Purcell is the lead designer for the Db2 for z/OS Optimizer at IBM’s Silicon Valley Lab, and is recognized worldwide for his expertise in query optimization and performance with Db2 for z/OS.

Db2 12 for z/OS Optimizer Update:
Db2 12 for z/OS had already delivered outstanding performance and scalability improvements from UNION ALL and outer join performance improvements, sort optimizations, improved predicate indexability and tighter integration of the Optimizer and RUNSTATS. This presentation will help you understand these and other updated enhancements - where they apply, and how to maximize the performance of your Db2 12 implementation.

Runstats Challenges for Optimal Query Performance
In Db2 development, we see many customers that are NOT following RUNSTATS collection “Best Practices”. But what are those best practices? The largest contributor to poor query performance is insufficient or misleading RUNSTATS. Improving the availability of pertinent and accurate statistics is a huge opportunity for customers to improve Db2 performance and reduce instability of access paths. What are the most common RUNSTATS collection mistakes and how to avoid them? How do I identify the right default statistics? In this session, we’ll answer these questions and more as we discuss various runstats challenges and misconceptions.

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

You need to be a member of WorldofDb2 to add comments!

Join WorldofDb2