Name: E14 Detect, analyze and reduce IX Splits using RTS History.
Start: 2026-09-30T17:40:00+0100
End: 2026-09-30T18:40:00+0100

E14 Detect, analyze and reduce IX Splits using RTS History.

Wednesday September 30, 2026 5:40pm - 6:40pm BST

Luis

Index pages splitting is a normal DB2 process when inserting or updating rows into table. However, this process can consume CPU resources and generate latch contention especially in a Data Sharing environment. Index page splits in also the main cause of index disorganization. In this presentation we will see how to identify costly index page splits and reduce their frequency with the help of RTS history tables.

Speakers

Laurent Kuperberg

Db2 technical consultant, SQLK

Laurent has 30 years of experience in the DB2 world as a consultant. He has acquired expertise ranging from database design to system administration and data sharing.
He has developed his own REXX tools, which he makes available to everyone.
He also provides DB2 training... Read More →

Wednesday September 30, 2026 5:40pm - 6:40pm BST
Luis

Track E, Technical Session

Topic Best Practices, Performance and Monitoring, User Stories
Audience Intermediate
Platform z/OS

IDUG EMEA 2026

Laurent Kuperberg

Get help with the event

IDUG EMEA 2026

Laurent Kuperberg

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Get help with the event