• Bart Steegmans

  • S204 - Mythbusters: Db2 latches vs. page latches vs. IRLM locks

    Session Evaluation

    Mythbusters: Db2 latches vs. page latches vs. IRLM locks.

    There is a lot of confusion and misconception about the different serialization mechanisms used by Db2 for z/OS (locks and latches ; claims and drains) ; what they mean ; how and when they are used ; and what impact they have on applications.In this session we will set the record straight. We will explore the different serialization mechanisms used by Db2 for z/OS ; what they are used for ; how you can determine that they are impacting your performance and how to address those performance issues in case they arise.

  • S211 - Measuring is knowing - Db2 for z/OS instrumentation enhancements you may have missed

    Session Evaluation

     Measuring is knowing - Db2 for z/OS instrumentation enhancements you may have missed.

    To analyze performance, Db2 has a wealth of metrics to look at.
    Each version, function level or even just with regular maintenance, these instrumentation metrics are being enhanced.
    This session will go over the V12 and V13 instrumentation enhancements to bring you up to date with all the latest and greatest IFCIDs and counters. We will also look at when and how to best exploit this information.