Virtual Db2 User Group Sponsors

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