Posted on 3/4/2026
The DB2Night Show Episode #281: Db2 LUW Performance Tuning: The Power of REORG Speaker: Wei Cao Registration URL: https://attendee.gotowebinar.com/register/5725938152877681751 As Db2 LUW databases grow and evolve, table fragmentation can gradually impact storage efficiency, access paths, and overall query performance. Understanding how Db2 organizes table data — and when to reorganize it — is essential for maintaining a high-performing environment. In this upcoming episode of The Db2Night Show, we will take a deep dive into Db2 table organization and the REORG TABLE utility, one of the most powerful tools available to DBAs for maintaining optimal database performance. This session will cover: 🔹 How Db2 LUW physically stores table data
🔹 How table fragmentation develops over time
🔹 Key indicators that signal when REORG TABLE is required
🔹 Differences between inline vs classic REORG
🔹 Online vs offline reorganization strategies
🔹 Operational trade-offs and best practices
🔹 Practical guidance for planning and executing REORG operations in production environments Whether you are a Db2 DBA, performance engineer, or database architect, this session will help you better understand how to maintain healthy tables, optimize access paths, and sustain long-term database performance.
Speaker
Wei Cao – Senior Technical Manager, IBM Canada Lab Wei leads core Db2 LUW engine development at the IBM Canada Lab. With over 15 years of experience in Db2 kernel development, she has contributed to major advancements in table and index structures, buffer pools, tablespace management, pureScale, BLU acceleration, and concurrency improvements. Her recent work focuses on LOB handling, data movement utilities, and advancing the Db2 kernel toward an AI-powered database engine, helping shape the future of modern data management.
|