IDUG NA 2026

Not all indexes are created equal. We explore the architectural differences between Partitioned, Non-Partitioned (NPSI), and Data-Partitioned (DPSI) indexes and when to deploy each for performance. Crucially, we explore each type's optimal recovery strategy so you can stop guessing between Rebuild and Recover.

The future of Db2 for z/OS is Universal Table Spaces (UTS) with IBM signaling that the next version of Db2 will no longer support legacy structures.
At the same time, Db2 itself is evolving toward UTS, with catalog and directory objects already being prepared for conversion through future Db2 13 function levels—reinforcing that UTS is the long-term foundation of the platform.
Despite this, many environments continue to delay conversion. The result is growing data volumes, increased complexity, and higher risk when the transition eventually becomes unavoidable.
This session focuses on why UTS conversion is essential. Beyond the “why,” we will dive into the “how”—sharing real-world examples of conversion failures and lessons learned from the field.

Db2 can be accessed from a wide variety of client platforms and languages. But information on the best way to achieve this access is often hard to find. This presentation will examine what Db2 clients are available and then look at the best way to configure connections from these clients. As well as the basic Db2 clients it will look at language and framework specific adapters as well.

Distributed client applications (from a server) are the most important and common of new workload using Db2 Z.
There are many concepts and terms thrown around which we often too often gloss over without a complete understanding.
This presentation will re-explain basic terms from my user perspective plus share some experiences learned (the hard way?) over recent years.
This presentation covers THREADS and DBATS and CONNECTION. What they mean and how they work and what our Db2 can tell us about their usage and importance.