Stream: Virtual Room 7
Time: 11:15 - 12:00
This session turns the subsystem inside out, giving Db2 practitioners a clear, authoritative picture of the internal structures that Db2 relies on from the moment it starts to the moment it recovers from failure. Starting from first principles, we'll distinguish the Catalog (DSNDB06, user-queryable, DDL-driven) from the Directory (DSNDB01, internal-only, runtime-critical) and explain why conflating the two leads to real operational blind spots. We'll walk through the full logging pipeline: how Db2 assigns Log Sequence Numbers, how the dual active log system protects against media failure etc. Attendees who leave this session will understand their subsystem in a way that changes how they interpret symptoms, plan maintenance, and respond to outages.
There is currently no attachment for Db2 from the Inside Out: Directory, Catalog, Logs & BSDS Explained
Saurabh works as a Lead Product Manager at BMC Software. Saurabh is a Lead Product Manager at BMC Software. He is an IBM Champion 2025 and 2024. He has been working on IBM Z and Db2 for z/OS for past 19 years. He had been a Db2 DBA in the beginning of his career and later had worked on product development, people management, quality assurance, SQL Performance, change management, AI and Product Management, He has keen interest in face reading, astrology and body language.
Click here to give some Feedback so we can make it even better next year!