IDUG EMEA 2026

Learn about the latest developments in Db2 ecosystem coming out of the Labs. A refresher on whats been delivered already. A deep dive into the most recently released mod packs. And catch a sneak peak at our future plans.

Warehouse and data lakehouses are converging and Db2 is ready for this shift. Db2 Datalake tables enable access to open-format data stored on remote object storage directly from within the relational database, eliminating the need for complex ETL pipelines or data duplication. This session explores the technical architecture supporting both Hive (ODF) and Iceberg table formats, demonstrating how organizations can query PARQUET, ORC, AVRO, and TEXTFILE data alongside traditional Db2 tables in complex SQL queries while maintaining ACID properties where needed. Attendees will learn implementation strategies for converged warehouse architectures, performance optimization techniques, and real-world use cases where Datalake tables provide bidirectional data flow between relational databases and data lake / lakehouses.

For over two years, I've been managing QLIK Replicate as a Change Data Capture (CDC) tool for our Db2 LUW databases and also for the host Db2 z/OS. I've gained a lot of experience in this area, which I'd like to share. I'll describe the environment with replications between Db2 z/OS and Db2 LUW. For which use cases is the tool suitable, and for which is it less appropriate? What problems have we encountered, and what workarounds have we found?

Join us for a deep dive into the latest innovations shaping the continued evolution of Db2 Cloud Services across leading cloud platforms. This session explores recent advancements in Db2 SaaS including Db2 Serverless, AWS Amazon RDS for Db2, and Db2 as a Service on Microsoft Azure as well as Google Cloud. You’ll learn how these offerings enable flexible deployment choices while meeting demanding enterprise requirements. Whether your focus is efficient application development, optimization, regulatory compliance, cloud strategy, availability, or feature adoption, this session will demonstrate how Db2 Cloud Services are designed to adapt to your needs—providing enterprise-grade reliability, scalability, and flexibility.

Insert Time Clustering (ITC) tables are not an obscure feature in Db2 - many practitioners know them, and they do appear in logging, event, and similar append-oriented workloads. However, their practical design space is often underestimated, especially when the discussion stays at a high level and does not go into physical organization and concurrency details.
This session looks at ITC as a technical design choice rather than a theoretical table attribute. I will briefly position ITC within the Db2 table organization family and then focus on the internals that matter in practice: its MDC-derived physical layout, insert behavior, extent reuse, ordered access to rows in their natural arrival sequence, and the locking patterns taken on pages and extents during insert, scan, and processing activity. These details are not just implementation trivia - they directly determine whether ITC is a good fit for a given workload.
The talk will compare ITC with APPEND mode for FIFO-style patterns suc

This presention will give the attendee a deep understanding of real life performance problem determination.
Drawing on success and the custom tools and techiques developed tuning an OTLP database that sustains in excess of 100,000 SQL statement per second throughput, the focus will be on how to identify bottlenecks in the system before they start. Custom tools and targeted application of the right tool for the job will be the focus. Scripts for custom tools will be shared with attendees.

This session will cover the new features in Db2 12.1 security, covering 12.1.3, 12.1.4 and 12.1.5. Attend to hear about new auditing capabilities, including audit to cloud object storage, and directly to CSV files. You will also learn about new JWT authentication enhancements features online key retrieval. 12.1.5 sees the completion of the reduce file permission feature started in 12.1.2 that really locks down a Db2 instance. You will also hear about new Quantum Safe Crypto support in TLS.

This presentation will show how Volkswagen handles a Db2 database with one very large 2 column table (timestamp &BLOB) , which was growing from some GB to 400TB. It will explain what challenges we had with hardware changes, software limits and working errors and how we solved them. Also making backups is not so easy for such a large system. This system is managed with a minimum amount of hardware resources inside a single Db2 LUW instance.

SQL is a very powerful language and can get complex. There are many ways of writing semantically equivalent queries.SQL SQL may be written by database users or ncluding external tools and these may not always be the most suitable for the Db2 engine for performance as written. The Query Rewrite component in Db2 helps towards simplifying this task for the user or external toolThe Query Rewrite (one of two optimizer components, the other being the Plan Optimizer) automatically rewrites queries within Db2 towards a better performing version for the Plan Optimizer and the Db2 execution engine.
This session delves into how AI is used to help the Query Rewrite component make better decisions. We present the challenges involved, how we tackle these challenges and touch on our next steps to transform the Query Rewrite component to exploit AI to make it even more powerful than it currently is.

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