IDUG EMEA 2026: Full Schedule

11:30am BST

E2 Improved availability and modernization of legacy systems through the evolution of Universal Table Space (UTS)

Monday September 28, 2026 11:30am - 12:30pm BST

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.

Speakers

Frances Villafuerte

Senior Technical Staff Member, IBM

Frances Villafuerte is a senior technical leader in IBM’s Db2 for z/OS core engine development team, where she plays a strategic role in shaping the capabilities that drive Db2’s value proposition for enterprise clients. She has led the architecture for key features that enhance... Read More →

Monday September 28, 2026 11:30am - 12:30pm BST
Luis

Track E, Technical Session

Topic Data Movement and Analytics, Latest and Features z/OS
Audience All
Platform z/OS

2:00pm BST

F3 Connect, Visualise, Predict: Visualization Db2 Data on z/OS using Python libraries and Machine learning tools.

Monday September 28, 2026 2:00pm - 3:00pm BST

Miragaia

In the modern era of data-driven decision-making, leveraging the power of mainframe data, such as Db2 on z/OS, can provide deep insights into business operations. However, visualizing this data and utilizing advanced analytics can often seem challenging. This session will explore how Python libraries, along with machine learning tools, can bridge the gap by providing intuitive and powerful solutions to visualize and analyze Db2 data on z/OS.
We will begin by discussing the fundamentals of accessing Db2 data on z/OS using Python library ibm_db. Once data is ready we will explore popular python libraries to create clear and informative visualizations.
The session will then dive into the integration of machine learning tools, to uncover hidden patterns in the data, perform predictive analytics, and gain deeper insights.

Speakers

Niraj Garudkar

Senior Db2 LUW Consultant, BMC Software

I am a Data Scientist at BMC Software, where I work on integrating agentic AI with mainframe systems. My work focuses on applying modern AI techniques to mission‑critical enterprise platforms, with a strong emphasis on DB2, IMS and intelligent automation across mainframe environments... Read More →

Monday September 28, 2026 2:00pm - 3:00pm BST
Miragaia

Track F, Technical Session

Topic AI GenAI and Machine Learning, Data Movement and Analytics, Modernization in Development, Working with SQL
Audience All
Platform z/OS

3:20pm BST

B4 Z Data Integration Update

Monday September 28, 2026 3:20pm - 4:20pm BST

Arrabida

This session is about deep dive technical details of how Z data is integrated with other platforms and solutions.
This is an architectural, use case and product level technical session. There will be latest news from the zSW Development and Product Management in the context of Data Management, focused on Db2 for z/OS.
The goal of this session is

What are data modernization Challenges – Past, Present, Future
IBM Z Data and AI Enterprise Architecture
Architectural alternatives to provide Db2 for z/OS data into other platforms for data modernization story
Core Products, Virtualization, Data Integration and AI Techniques
Replicate, Direct Access, Virtualization – Pros & Cons.
Technical and Business Use Cases with Capabilities
Roadmaps and Future direction of IBM

Speakers

Cüneyt Göksu

Executive IT Specialist, IBM

Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, Bachelor’s degree and PhD in Computer Science. He has been working with Db2 for z/OS and IBM Z... Read More →

Mateo Tošić

Senior Technical Staff Member, IBM

Monday September 28, 2026 3:20pm - 4:20pm BST
Arrabida

Track B, Technical Session

Topic Best Practices, Data Movement and Analytics, Data Movement and Integration, Latest and Features z/OS, User Stories
Audience Intermediate
Platform Cross Platform

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

10:20am BST

F10 AI Agents Meet Mainframe: Building MCP Servers on Replicated Db2 z/OS Data

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

Miragaia

AI agents are transforming enterprise applications, but they need access to trusted, business-critical mainframe data. This session shows how MCP servers enable agents to query up-to-date, replicated Db2 z/OS data from targets like Db2 LUW or watsonx.data. It covers the rationale for agent integration, architecture patterns, implementation steps, and a live demo of an agent working with z/OS data.

Speakers

Cüneyt Göksu

Executive IT Specialist, IBM

Mateo Tošić

Senior Technical Staff Member, IBM

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

Track F, Technical Session

Topic AI GenAI and Machine Learning, Data Movement and Analytics, Data Movement and Integration, Working with SQL
Audience Intermediate
Platform Cross Platform

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

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

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

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

9:00am BST

B15 Db2 Analytics Accelerator: V8, Migration experiences, future and customer updates

Thursday October 1, 2026 9:00am - 10:00am BST

Arrabida

This session is deep dive technical details about Db2 Analytics Accelerator on IBM Z with latest V8 product updates, new capabilities, with migration details.
There will be z17 and LinuxONE 5 Migration Experiences with V7 and V8, platform specific details, migration planning and deployment details.
Session will contain IBM Z platform specific details z17 and LinuxONE 5, in the context of Accelerator such as machine configuration, CBU and Flex Capacity usage, different architecture alternatives for different business needs including GDPS usage with 2-, 3-, 4- site GDPS alternatives.
There will be Lessons Learned from PoCs, current implementations, architecture discussions and health checks.

Speakers

Cüneyt Göksu

Executive IT Specialist, IBM

Björn Broll

Product Manager, Db2, IBM

Senior Technical Staff Member (STSM) for IBM z Data and AI in IBM Germany Research and Development Lab.

Thursday October 1, 2026 9:00am - 10:00am BST
Arrabida

Track B, Technical Session

Topic Data Movement and Analytics, Latest and Features z/OS
Audience Intermediate
Platform z/OS

10:20am BST

C16 Fine-Tuning Db2 Datalake Tables Performance

Thursday October 1, 2026 10:20am - 11:20am BST

Porto

Db2 Datalake tables allow defining and managing vendor-agnostic Hive and Iceberg tables atop open data formats used in data analytics environments. However, Datalake tables are configured and maintained differently from traditional Db2 tables. Participants will learn valuable skills such as creating workload-optimized Datalake tables, and monitoring and tuning them to preserve their performance as the table grows.

Speakers

Olivier Bernin

IBM Gold Consultant for Data & AI, IBM

Thursday October 1, 2026 10:20am - 11:20am BST
Porto

Track C, Technical Session

Topic Data Movement and Analytics, Db2 Cloud and Warehouse, Performance and Monitoring
Audience Intermediate
Platform LUW

10:20am BST

E16 Getting Started with OpenTelemetry for Db2: Metrics, Traces, and What They Really Mean

Thursday October 1, 2026 10:20am - 11:20am BST

Luis

OpenTelemetry is becoming a standard for observability,but what does it mean for Db2? This introductory session shows how metrics and traces help you understand what’s really happening in your Db2 workloads. Learn how SQL activity can be exposed as meaningful metrics, and how distributed traces can follow transactions end-to-end into Db2.We focus on practical outcomes: where time is spent, where bottlenecks occur, and whether issues originate in Db2 or upstream systems. Designed for DBAs and performance specialists, this session gives you a clear starting point to understand what these signals really mean, and how to begin using them in your day-to-day work.

Speakers

Rabah Beggar

Software Developer, Broadcom

Product Manager at Broadcom, part of the team shaping the strategy and roadmap for mainframe database and infrastructure tools (IMS & Db2). I focus on simplifying complex operations and enhancing the experience for enterprise customers running critical workloads on the mainframe... Read More →

Thursday October 1, 2026 10:20am - 11:20am BST
Luis

Track E, Technical Session

Topic Back to Basics, Data Movement and Analytics, Performance and Monitoring, Working with SQL
Audience All
Platform z/OS

11:30am BST

2:00pm BST

3:20pm BST

10:20am BST

10:20am BST

10:20am BST

11:30am BST

2:00pm BST

4:30pm BST

4:30pm BST

9:00am BST

10:20am BST

10:20am BST

Get help with the event