IDUG NA 2026: Full Schedule

arrow_back View All Dates

10:20am EDT

D10 | Optimizing Db2 BLU Performance: Defragmentation, Data Clustering, and Reduced Logging at Scale

Wednesday October 28, 2026 10:20am - 11:20am EDT

As BLU workloads scale, maintaining optimal insert performance, log efficiency, and data organization becomes increasingly important. This session addresses these challenges through defragmentation, data clustering, and reduced logging. We will examine internal storage behavior and share proven techniques to reclaim space, reduce log overhead, and sustain high-throughput workloads.

Speakers

Ron Liu

Db2 Columnar Database Engine Developer, IBM

Wednesday October 28, 2026 10:20am - 11:20am EDT
Magnificent 5

Track D, Technical Session

Audience Intermediate
Subject LUW
Area Back to Basics, Data Movement and Analytics, Performance and Monitoring

2:00pm EDT

C12 | Efficiently Finding and Fixing High Resource Consuming SQL

Wednesday October 28, 2026 2:00pm - 3:00pm EDT

Magnificent 4

This presentation will demonstrate how to find, analyze and tune the top 40 expensive queries. Special emphasis will be on finding the cursors that could benefit from multi-row fetch. In addition, discussions on designing perfect indexes, MQTs and AQTs, along with manual query rewrite, SQL exploitation and most important, proper use.

Speakers

Sheryl Larsen

President, Sheryl M Larsen LLC

Sheryl Larsen is an internationally recognized researcher, consultant and lecturer, specializing in DB2 and is known for her extensive expertise in SQL. Sheryl has over 30 years’ experience in DB2, has published many articles, several popular DB2 posters, and co-authored a book... Read More →

Wednesday October 28, 2026 2:00pm - 3:00pm EDT
Magnificent 4

Track C, Technical Session

Audience All
Subject z/OS
Area AppDev, Back to Basics, Best Practices, Latest and Features z/OS, Modernization in Development, User Stories, Working with SQL

IDUG NA 2026

10:20am EDT

Ron Liu

2:00pm EDT

Sheryl Larsen

Get help with the event