IBM TechXchange UKI Db2 for z/OS User Group

IBM TechXchange UKI Db2 for z/OS User Group

 View Only
Back to discussions
Expand all | Collapse all

Webcast Invitation: Improve Db2 for z/OS Performance by exploiting Statistics

  • 1.  Webcast Invitation: Improve Db2 for z/OS Performance by exploiting Statistics

    Posted Thu January 17, 2019 12:28 PM

    Title: Improve Db2 Performance by understanding Statistics

    Date: Tuesday, February 05, 2019

    Time: 11:00 AM Eastern Standard Time

    Duration: 1 hour

    Join Db2 Optimizer Guru and expert Terry Purcell  and learn how you can exploit Db2 statistics and 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.
    Starting from Db2 11, the Db2 optimizer provides recommendations for missing/conflicting statistics via a new catalog table.
    Db2 users can easily gather accurate and complete statistics for the optimizer to improve query performance.
    Yet, this practical new enhancement has not been widely utilized by Db2 users. In this session, we will explain how to utilize and benefit from the feature.

    Presenters: Terry Purcell STSM, IBM Master Inventor  & Michal Bialecki 

    Primary Presenter: Terry Purcell

    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.

    Secondry Presenter: Michal Bialecki

    Michal Bialecki - Db2 z/OS level2 support & development (2004-present) at IBM Silicon Valley Lab (SVL). Prior to joining lab Michal worked as system / application DBA for Social Security government customer in Poland, for 4 years, and also was and still is helping other customers for Db2 z/OS.
    He is former speaker at IDUG EMEA conference - Berlin 2012/ Barcelona 2013 / Dublin 2015 / Insight 2015 and Lisbona 2017 ,
    and also few DB2 user run events (csDUG, GSEfr). Michał is also IBM SVL representative and frequent speaker at Poland Db2 User Group.

    Registration: http://ibm.biz/Db2zWebcast5thFeb




    ------------------------------
    Karen Wilkins
    Client Technical Professional
    IBM UK Ltd
    Bristol
    ------------------------------


Related Content