Db2 12 and Continuous Delivery – What’s New from the Optimizer

Download PDF

Session title: Db2 12 and Continuous Delivery – What’s New from the Optimizer

Session abstract: Session abstract: DB2 12 for z/OS has been announced and DB2 has embarked on Continuous Delivery for ongoing features. So what’s coming from the optimizer team regarding further performance enhancements? 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 outline what was delivered and how future optimizer enhancements apply to continuous delivery.

Speaker biography: Terry Purcell is a Senior Technical Staff Member with the IBM Silicon Valley Lab, where he is lead designer for the DB2 for z/OS Optimizer. Terry has 25 years of experience with DB2 in SQL Performance and optimization as a customer, consultant and DB2 developer. Terry is an IBM Master Inventor with more than 25 U.S. patents for database search Technology.