IDUG EMEA 2026: Full Schedule

arrow_back View All Dates

10:20am BST

Wednesday September 30, 2026 10:20am - 11:20am BST

Hear from the lab leadership on the latest shipped + announced Db2 content, and our perspective and vision for the future. We'll cover key enhancements in the latest modpacks (12.1.4 / 12.1.5) and give you a sneak peak at what's coming in 12.1.6 and beyond.

Speakers

David Kalmuk

Distinguished Engineer, Databases, IBM

David is a distinguished engineer at IBM, working on IBM's analytic database products.

Wednesday September 30, 2026 10:20am - 11:20am BST
Porto

Track C, Technical Session

Topic Latest and Features LUW
Audience All
Platform LUW

10:20am BST

C10 Experiences with the AI Query Optimiser

Wednesday September 30, 2026 10:20am - 11:20am BST

Porto

Switching on the AI Query Optimiser in Db2 v12 is straightforward, but what do you do after you have switched it on? How do you confirm that it is doing what you want? How do you limit its execution to focus on just the tables you need and want? How do you confirm that it is having a positive effect? How do you manage the resources that it uses?
This presentation recounts some of the tricks, pitfalls and gotchas encountered in actual customer implementations of the AI Query Optimiser.

Speakers

Mark Gillis

Principal Consultant, Triton Consulting

I am a Principal Consultant with Triton Consulting, based in the UK. I have been working in IT for over 40 years, and as a DB2 DBA for 35. I have worked on DB2 installations ranging from single user local Windows based systems to 100+ TB DB2 Warehouses.

I have also been involved in Business Intelligence solutions; designing and implementing systems using various RDMS data sources. I have worked for a large range of customers, mostly Blue-Chip household names, in roles including design, development, implementation and support. I... Read More →

Wednesday September 30, 2026 10:20am - 11:20am BST
Porto

Track C, Technical Session

Topic Data Movement and Analytics, Latest and Features LUW, Performance and Monitoring, User Stories, Working with SQL
Audience All
Platform LUW

10:20am BST

D10 Make you data comparable by VECTORizing

Wednesday September 30, 2026 10:20am - 11:20am BST

Maria

Based on the VECTOR data type, that came with Db2 12.1, your data can easily be put in definnable context by using similarities. This can help identifying correlations where exact values would make it too complicated. As a relational model typically is based on direct comparability of values only, vector usage can provide some extra level of data linking. With an example shown in a live demo, this session will show step by step, how to implement vector usage in your data to provide additional analytical features.

Speakers

Martin Heitkämper

Data Scientist, Arvato Systems GmbH

I'm with Db2 ever since it started in the market, doing administration, design and development around Db2 (and other databases). Frequently I present at IDUG or other events, often but not exclusively on Db2 for SAP.

Wednesday September 30, 2026 10:20am - 11:20am BST
Maria

Track D, Technical Session

Topic AI GenAI and Machine Learning, Data Movement and Analytics, Latest and Features LUW, Performance and Monitoring
Audience All
Platform LUW

11:30am BST

C11 DB2 Backup and Recovery - back to the basics

Wednesday September 30, 2026 11:30am - 12:30pm BST

Porto

In this presentation we will examine in detail the backup and recovery options available to DBAs for their Db2 environments. How to tune these utilities will be discussed and results will be reviewed from numerous tests. We will see what is the “art of the possible” from using local files, COS, Storage based copies, etc. … We will take a close look at the new version enhancements and how they can improve your backup and recovery experience.

Speakers

Dale McInnis

STSM, Db2 Client Adoption Engineering, IBM

Dale McInnis is an STSM in Db2 development from the IBM Toronto Canada Lab. He has a B.Sc.(CS) from the University of New Brunswick and a Masters ofEngineering(M.Eng) from the University of Toronto and is currently pursuing his PhD in computer science. Dale joined IBM in 1988 and... Read More →

Wednesday September 30, 2026 11:30am - 12:30pm BST
Porto

Track C, Technical Session

Topic Back to Basics, Best Practices, Utilities
Audience All
Platform LUW

11:30am BST

D11 Data Lake Architecture for Scale: Patterns, Pitfalls, and Best Practices based on BaFin's first data lake

Wednesday September 30, 2026 11:30am - 12:30pm BST

Maria

Data lakes have become a foundational component of modern data platforms, enabling organizations to store and process large volumes of structured, semi-structured, and unstructured data with high scalability and flexibility.
For data architects and database administrators, the challenge lies not only in designing a robust data lake architecture but also in ensuring consistent performance, governance, and operational reliability across diverse workloads.
A well-designed data lake architecture typically follows a layered approach, incorporating ingestion, storage, processing, metadata management, and access layers.
Data is ingested through batch processing and streaming pipelines into cost-effective, distributed storage systems, based on object storage.
Processing frameworks support transformation and enrichment, while metadata and catalog services provide schema management, lineage, and discoverability. Increasingly, modern architectures adopt lakehouse patterns to bridge the gap betwe

Speakers

Olaf Stephan

IT Database Architect, Bundesanstalt für Finanzdienstleistungsaufsicht | Federal Financial Supervisory Authority BaFin

I work as the Chief IT Database Architect for the Bundesanstalt für Finanzdienstleistungsaufsicht, BaFin (Federal Financial Supervisory Authority) in Frankfurt a.M. Germany. My area of expertise is database design, enterprise architecture, performance, and information integration... Read More →

Wednesday September 30, 2026 11:30am - 12:30pm BST
Maria

Track D, Technical Session

Topic Best Practices, Data Movement and Analytics, Db2 Cloud and Warehouse, Latest and Features LUW, Modernization in Operations, Security and Compliance
Audience Intermediate
Platform LUW

2:00pm BST

C12 Advanced Performance Diagnostics for SQL

Wednesday September 30, 2026 2:00pm - 3:00pm BST

Porto

The Db2 family of products including Db2, Db2 Warehouse, and Db2 PureScale provide a number of important features for diagnosing and solving your SQL problems. Through a series of practical examples, this session will bring you up speed on the latest capabilities available for SQL diagnostics and show you how you can leverage them to solve query problems in your own environment. You will learn how to identify your most expensive SQL statements using the package cache table functions, and how to use Db2's "time spent" metrics to analyze where your problem queries are spending their time. You will also learn some new tips for monitoring sort memory metrics and query memory consumption in order to tune your analytic workloads. Finally you will learn how to use the runtime explain capabilities in conjunction with the activity event monitor to capture actual query plan cardinalities as well the per object metrics.

Speakers

David Kalmuk

Distinguished Engineer, Databases, IBM

David is a distinguished engineer at IBM, working on IBM's analytic database products.

Wednesday September 30, 2026 2:00pm - 3:00pm BST
Porto

Track C, Technical Session

Topic Best Practices, Performance and Monitoring, Working with SQL
Audience Intermediate
Platform LUW

2:00pm BST

D12 Meta-Programming the Migration: Automating Zero-Disk Loads from Oracle RDS to Db2 OpenShift via Federation and Python

Wednesday September 30, 2026 2:00pm - 3:00pm BST

Maria

Enterprise database migrations are often slowed to a crawl by their reliance on flat files. Large volumes of data must be written to disk, moved across networks, and reloaded using traditional utilities—a process that is time‑consuming, storage‑intensive, and error-prone. In migrating a legacy Oracle environment on AWS RDS to a modern, containerized Db2 platform running on OpenShift, it became clear that a fundamentally different approach was needed—one that removes the disk from the equation altogether.
This session presents a high‑performance, zero‑disk migration approach that streams data directly from the Oracle source into Db2. It walks through how to set up Db2 Federation and automate nickname creation to establish a direct data pipeline. Rather than relying on conventional SQL processing, the approach feeds a federated cursor straight into the Db2 LOAD mechanism, allowing data to be written directly into target tables with maximum efficiency.
To make this solution practical at

Speakers

Robert Proffitt

DBA, DBA Topgun

Robert Proffitt is a senior technology leader with 35+ years of enterprise database expertise, having architected mission-critical DB2 solutions for Fortune 100 companies, including JP Morgan Chase, Wells Fargo, FedEx, and 3M. An IBM Gold Consultant, he created DataSentinel—a neuro-symbolic... Read More →

Wednesday September 30, 2026 2:00pm - 3:00pm BST
Maria

Track D, Technical Session

Topic AppDev, Automation, Data Movement and Analytics, Data Movement and Integration, Working with SQL
Audience Intermediate
Platform LUW

4:30pm BST

B13 Introduction to SQL-PL

Wednesday September 30, 2026 4:30pm - 5:30pm BST

Arrabida

In this session, we'll go back to basics and look at SQL-PL, Db2's built in server-side application logic. We'll take a look at the code constructs and how to leverage in stored procedures, user defined functions and triggers. We'll also look at more complex scenarios like code for a Data Partitioning Feature (DPF) environment. The majority of this session will be looking at and executing source code.

Speakers

Les King

DBA, Db2 technical lead, Les King Learning, Seneca College

Les King is a part-time professor at multiple Ontario Colleges, offering courses in Mathematics, Programming and Data Management. Les has also been an instructor at the University of Toronto in the Mathematics department. Les effectively draws a connection between what the marketplace... Read More →

Wednesday September 30, 2026 4:30pm - 5:30pm BST
Arrabida

Track B, Technical Session

Topic AppDev, Modernization in Development, Working with SQL
Audience Beginner
Platform LUW

4:30pm BST

C13 A brief history of a query: from the PreparedStatement to the ResultSet - how queries gets executed in Db2 database?

Wednesday September 30, 2026 4:30pm - 5:30pm BST

Porto

To the average application, a database is often treated as a "black box": SQL goes in, and data comes out. But for those tasked with maintaining high-performance systems, "it just works" isn't enough. When a query hangs or a system spikes in CPU, understanding the mechanics "under the hood" is the difference between a quick fix and hours of guesswork.

This presentation takes you on a chronological journey of a query’s lifecycle. We will trace the path of a single PreparedStatement from the moment it leaves a remote application, through the DRDA protocol, and deep into the Db2 engine layers. We will explore:
- The Handshake: How client-server interactions and the SQLDA manage data exchange.
- The Brain: Inside the Query Compiler and Optimizer—how your SQL is transformed into an executable "Plan."
- The Engine Room: How the Runtime components interact with the Buffer Pools, Prefetchers, and Logger to retrieve your data.
- The Return: The mechanics of the ResultSet and how data is effic

Speakers

Kamil Kuduk

Solution Consultant, IBM Poland

Working for IBM Db2 in support role for over 10 years. Last few years in the Advanced Problem Determination team, specializing in performance problems and operating system troubleshooting.

Wednesday September 30, 2026 4:30pm - 5:30pm BST
Porto

Track C, Technical Session

Topic Back to Basics, Best Practices, Database Resiliency, Data Movement and Analytics, Performance and Monitoring
Audience Intermediate
Platform LUW

4:30pm BST

D13 Db2 LUW Table Partition Management

Wednesday September 30, 2026 4:30pm - 5:30pm BST

Maria

Db2 LUW provides the capability to create partitioned tables which have a number of useful benefits. However, a current downside to the implementation on LUW is that there is no automatic built-in functionality to add partitions when needed or manage the process of adding, detaching and deleting partitions. In particular, for Production environments that require stability and availability without interruption, robust and auditable management of partitions is a critical and invaluable requirement.
In this session I will provide an overview of the design and implementation of a bespoke Unix based solution used in a high volume 24/7 transactional and warehouse database application. The presentation will include an explanation of the requirements to manage table partitions in a Production environment and will include high level diagrams of the process flow to manage the partitions; the logic to identify required partitions/timestamps to manipulate, the required commands to make changes,

Speakers

David Lynch

Lead Product Owner, Mastercard

I have worked with Db2 LUW for nearly thirty years in both development and production environments. I worked for IBM for nearly ten years on customer and internal projects either specifically with Db2 or Siebel running on Db2. I spent some years as an independent contractor and then... Read More →

Wednesday September 30, 2026 4:30pm - 5:30pm BST
Maria

Track D, Technical Session

Topic Automation, Utilities
Audience All
Platform LUW

4:30pm BST

E13 Efficient Scans on Columnar Tables

Wednesday September 30, 2026 4:30pm - 5:30pm BST

Luis

It often makes sense for analytical applications to store the data in column organized tables instead of row organized tables to get better performance. Especially scans on column organized tables are different from scans on row organized tables. This presentation investigates these differences. One major difference is the usage of Synopsis tables to speed up scans. Therefore, we will look in depth at how Synopsis tables work, how one can check Synopsis tables e.g., with SQL statements, and how one can ensure to get "good" Synopis tables, i.e., Synopsis tables which allow the elimination of unneccesary page accesses during the scans of important queries.

Speakers

Andreas Weininger

Principal Information Architecture Technical Specialist, IBM

Andreas Weininger is part of the Information Architecture team of IBM in Munich. He has more than 20 year of experience with scalable solutions for data intensive solutions focussing especially on the performance aspects. He is a regular speaker at database and data warehousing events... Read More →

Wednesday September 30, 2026 4:30pm - 5:30pm BST
Luis

Track E, Technical Session

Topic Best Practices, Data Movement and Analytics, Performance and Monitoring
Audience All
Platform LUW

4:30pm BST

F13 Do you think you know pureScale? Come test your knowledge

Wednesday September 30, 2026 4:30pm - 5:30pm BST

Miragaia

Db2 pureScale environments are designed for high availability and scalability, but their behavior under load, failure, and recovery is often more nuanced than expected.
In this interactive session, we’ll challenge your understanding of pureScale through a series of real-world scenarios covering cluster services behavior and failure handling, locking, caching, and recovery. You’ll be asked to predict outcomes, diagnose issues, and uncover what really happens under the covers.
Whether you’re an experienced practitioner or relatively new to pureScale, this session will expose common misconceptions, highlight subtle behaviors, and deepen your intuition about how the system operates in production.
Come ready to participate, question what you think you know—and leave with insights you can apply immediately.

Speakers

Christian Garcia-Arellano

STSM, Db2 Senior Architect and Master Inventor, IBM

Christian Garcia-Arellano is STSM and Db2 OLTP Architect at the IBM Toronto Lab, and has a MSc in Computer Science from the University of Toronto. Christian has been working in various DB2 Kernel development areas since 2001. Initially Christian worked on the development of the self... Read More →

Wednesday September 30, 2026 4:30pm - 5:30pm BST
Miragaia

Track F, Technical Session

Topic Back to Basics, Database Resiliency
Audience All
Platform LUW

5:40pm BST

C14 Db2 for LUW Expert Panel

Wednesday September 30, 2026 5:40pm - 6:40pm BST

Porto

Wednesday September 30, 2026 5:40pm - 6:40pm BST
Porto

Expert Panel, Expert Panel

Topic Expert
Audience All
Platform LUW

10:20am BST

10:20am BST

10:20am BST

11:30am BST

11:30am BST

2:00pm BST

2:00pm BST

4:30pm BST

4:30pm BST

4:30pm BST

4:30pm BST

4:30pm BST

5:40pm BST

Get help with the event