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.
Comments