Virtual Db2 User Group | From Root to Leaf—Managing Index Splits in Db2
June 19 @ 11:00 am - 1:00 pm EDT
Presenter: Saurabh Pandey, Lead Product Manager, BMC
Indexes are the heart of efficient SQL and access path in Db2 for z/OS. But when they become bloated due to page splits, they can quietly eat away at your performance, escalate CPU usage, and increase locking contention. If your insert-heavy application is facing throughput drops, it’s time to ask: Are index splits your silent killer?
In this presentation, we’ll break down
- How Db2’s B-tree index splitting works (leaf, non-leaf, and root)
- Why splits can drastically affect performance
- How to monitor, control, and prevent them in modern Db2 (12/13)
- Best practices for DBAs and architects
- Configuration tricks and tuning tips