IDUG EMEA 2026

Customers are constantly striving to perform essential DBA related tasks being driven by application improvements and evolutions. Non-Disruptive schema changes have been a major objective for the Db2 for z/OS ecosystem. Db2 will discontinue to support several legacy table space types and deprecated functions. Organizations must migrate to Universal Table Spaces (UTS) and remove unsupported functions prior to the deadline to ensure long‑term database viability. In addition to user‑defined objects, the work file database and many Db2 catalog tables that reside in deprecated table spaces must also be considered in the migration plan. This session highlights the invaluable online schema enhancement features in Db2 that can be exploited to achieve the highest level of availability.

Stuck on a tough audit level? Tired of seeing the "Game Over" screen when a report asks: "Who had access three months ago?" Many Db2 sites rely on clunky log tools for this security quest. Get ready to discover the secret power-ups! We'll expose the relatively new, native Db2 security information stored right in the catalog—the hidden cheat code you need. Join us to unlock these features, score a Pixel Perfect audit, and conquer your compliance quest by augmenting your current processes. No extra quarters needed!

Many Db2 environments still depend on inherited, legacy home-grown housekeeping processes, increasing cost, risk and instability. This session shares a customer journey that modernized REORG strategy using data-driven principles and operational criteria. We discuss organizational challenges, architectural decisions, and unexpected outcomes, offering guidance for a more sustainable and scalable Db2 housekeeping model.

As Db2 environments grow in complexity, traditional shell scripting often reaches its limits in maintainability and modern DevOps integration. This session serves as a high-level roadmap for Db2 administrators and developers to leverage Python and Ansible for modernizing their daily workflows. We will explore foundational database connectivity using the ibm_db driver and demonstrate how to transition from static text logs to interactive analysis using Pandas for efficient data wrangling and visualization. By utilizing modern tools like Jupyter Notebooks for exploration and Visual Studio Code for development, we will discuss the benefits of Object-Oriented Programming (OOP) in creating modular, reusable connector classes. Finally, the presentation dives into the DevOps world, showing how to extend Ansiblethrough custom filter, action, and lookup plugins to build flexible, database-driven automation frameworks.
Key Presentation Highlights:
Connectivity Essentials: A practical guide to se