Close

Back-To-Basics: Real Time Statistics: What are they and how are they used?

(FC)

Stream: Db2
Time: 15:00 - 15:45


Presentation

Join us as we explore how to determine when to reorganize a Db2 object and the benefits of doing so. We'll also review the most critical Db2 catalog tables to show that the RTS entries can identify when an object shows signs of needing reorganization. Leave with a basic understanding of : 1) how updated catalog table entries completed during a REORG will confirm that the utility was successfully executed and a backup copy is available for use, 2) an overview of the internal changes made within the object will be outlined, and 3) the impact that the REORG process has on the access path and performance improvements.
 

Attachments

FC Attachments

Speakers


  • Elitsa Popova at BMC Mainframe Services
  • BMC Software Inc. (2021 – Present) Associate Consultant (Mainframe z/OS Db2 DBA)

    Junior full stack web developer (2020 – 2021)

    Intern Product Developer (2018)

    GSE UK Conference, Whittelbury Hall (2017) IBM Panel member, The Future.Ready()Mainframe. Client success stories of finding fabulous, young new Z talent.

    IBM Master the Mainframe, now IBM Z Xplore (2017) Part 3 finisher, Wall of Fame. IBM MtM Advocate digital badge.

    University of Bedfordshire (2016 – 2020) B.Sc. (Hons), Computer Science and Software Engineering with Professional Practice year. Grade 1st. Activities and societies: Chair of Bedfordshire Enterprise and Mainframe Society.

    St. Cyril and St. Methodius University of Veliko Tarnovo, Bulgaria. (1996 – 2000) Master of Arts, Drawing and Painting. Grade 1st. Certified teacher - drawing and painting.


    Email: elitsa_popova@bmc.com

    Feedback

    Click here to give some Feedback so we can make it even better next year!