Posted on 3/4/2026
| Presented by: Wei Cao serves as a Senior Technical Manager at the IBM Canada Lab, leading core Db2 LUW engine development. Her expertise spans table and index structures, buffer pools, and table space management, with recent focus on LOBs and data movement utilities. With over 15 years of experience in Db2 kernel development, she has contributed to several major features that improve performance, availability, and resilience, including enhancements for pureScale, BLU acceleration, concurrency, and storage management. She has also led development efforts to advance availability and parallelism within Db2. Her current work focuses on evolving the Db2 kernel toward an AI-powered database engine, driving innovation in modern data management.. Studio audience learnt lot about Db2 LUW Performance Tuning: The Power of REORG!. A huge thank you to Wei for an excellent deep-dive session.
"The DB2Night Show Episode #281: Db2 LUW Performance Tuning: The Power of REORG". Replays available in WMV and MP4 formats! This was a highly practical and architecture-focused session—great insights that teams can apply right away. Watch the replay... |
Show Hosts: Mohan's CommentaryWe are excited to continue our Db2 12.1 webinar series with another highly anticipated session on The Db2Night Show! As Db2 LUW databases grow and evolve, table fragmentation can significantly 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 episode of The Db2Night Show, we took a deep dive into Db2 table organization and the REORG TABLE utility, one of the most powerful tools available to DBAs for performance optimization. What you’ll learn by watching the replay: - How Db2 LUW physically stores table data
- How fragmentation develops over time
- When and why to run REORG TABLE
- Inline vs Classic REORE
- Online vs Offline reorganization strategies
- Operational trade-offs and best practices
- Real-world guidance for production environments
Are you following The DB2Night Show on Twitter?Go to twitter.com/db2nightshow and click Follow. You can also see recent tweets containing the hash tag #DB2Night by Clicking Here.Get the Download ReplaysTo download a recorded replay of Episode 279 in WMV format:"
Episode 281 20 March 2026 Db2 LUW Performance Tuning: The Power of REORG Have an iLife, iDevice, iPod, iPad, or iPhone? Download the MP4format! Wei graciously made the PDF of Episode 280 available at this link:
Handout (PDF) Follow the Db2Night Show channel on Youtube!! Did you learn something from this show?Share a great show with your friends and followers:
|