Webcast: Improve Db2 for z/OS performance by exploiting analytics and statistics
Paul_McWilliams 110000JT36 Visits (2922)
Date and time: February 5, 2019 from 11am - 12pm EST
Join a webcast by Db2 optimizer Guru and expert Terry Purcell to learn how you can exploit Db2 statistics to improve productivity.
The Db2 optimizer relies on statistics about tables and indexes. In most cases, if the optimizer could exploit more complete and accurate statistics, queries would perform better. While, Db2 users often only gather standard or default statistics. It’s a challenge for users to identify what detailed statistics should be gathered for the specific queries. This is a main reason for sub-optimal (unsatisfactory) query performance. Regi
About the presenters
Terry Purcell is the lead designer for the Db2 for z/OS Optimizer at IBM Silicon Valley Lab, and is recognized worldwide for his expertise in query optimization and performance with Db2 for z/OS.
Michal Bialecki - Db2 z/OS level2 support and development at IBM Silicon Valley Lab.