IDUG EMEA 2026: Full Schedule

4:30pm BST

B5 Beyond the Basics: Backup and Recovery for Resilient Db2 Environments

Monday September 28, 2026 4:30pm - 5:30pm BST

This session explores backup and recovery strategies for Db2 for z/OS, emphasizing the critical importance of compliance and recoverability in today’s data-driven world. Attendees will learn about various backup types, tools, and recovery processes, with a focus on creating resilient systems that align with modern compliance requirements. Through use cases, the session will demonstrate how to ensure recoverability, data integrity, minimize downtime, and maintain availability.

Speakers

Rahul Bajaj

Software Engineer, Broadcom

Rahul is a Db2 for z/OS professional at Broadcom Inc., working as part of the Db2 tools development team. His work focuses on supporting and evolving database management solutions that power critical enterprise systems.

Aysen Svoboda

Product Owner, Broadcom

A former System Programmer and DBA with 17 years in the mainframe space. Currently a Product Owner, dedicated to bridging the gap between software development and the real-world needs of the Db2 z/OS community.

Monday September 28, 2026 4:30pm - 5:30pm BST
Arrabida

Track B, Technical Session

Topic Best Practices, Database Resiliency
Audience Intermediate
Platform z/OS

4:30pm BST

C5 400 TB of LOBs witin a single Table - Challenges during growth over 25 Years

Monday September 28, 2026 4:30pm - 5:30pm BST

Porto

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.

Speakers

Norbert Menzel

Db2 for zos DBA expert, Volkswagen AG

Norbert Menzel works with Db2 on different platforms (z/OS, OS/2, AIX) for about 40 years. Since 2005 he works for Volkswagen and manages Db2 LUW on AIX.

Monday September 28, 2026 4:30pm - 5:30pm BST
Porto

Track C, Technical Session

Topic Best Practices, Database Resiliency, User Stories
Audience All
Platform LUW

10:20am BST

A6 Strategic Efficiency: Maximizing Db2 Utilities

Tuesday September 29, 2026 10:20am - 11:20am BST

Infante

Are you running maintenance because it’s Sunday, or because the data actually needs it? With shrinking windows and massive data growth, "business as usual" is no longer an option. This session explores how Broadcom Db2 utilities provide the precision and confidence needed to manage modern environments. We will discuss establishing data-driven housekeeping practices, leveraging recovery toolkits to validate resilience without production impact, and optimizing high-speed data movement to support DevOps and rapid testing. Learn to transform your batch utilities from a routine expense into a high-performance engine.

Speakers

Denis Tronin

Product Manager, Broadcom Mainframe Software

Denis Tronin is an experienced IT professional and product manager, skilled in mainframe technologies (Db2 for z/OS, system performance, workload automation), API management (Zowe API Mediation Layer), and DevOps. He is an IBM Champion and a frequent speaker at major industry con... Read More →

Tuesday September 29, 2026 10:20am - 11:20am BST
Infante

Track A, Technical Session

Topic Best Practices, Database Resiliency, Data Movement and Integration, Utilities
Audience All
Platform z/OS

10:20am BST

C6 Zero Downtime Dreams: A Newcomer’s Guide to Db2 Resilience

Tuesday September 29, 2026 10:20am - 11:20am BST

Porto

High availability and disaster recovery capabilities are essential for safeguarding mission-critical Db2 environments. Yet for many beginners, the variety of available technologies including backup and recovery strategies, clustering solutions, replication tools, and multi-cloud architecture can feel overwhelming. This session provides a clear, approachable introduction to the full Db2 High availability and disaster recovery landscape, based on real-world experiences. We will walk through the fundamentals of Db2 backup and recovery, explain how Db2 HADR works and when it’s the right choice, and demystify clustering frameworks such as Pacemaker and PowerHA. You will also learn where pureScale fits into HA planning, how Q Replication and CDC support active-active or near real-time availability, and how modern cloud and multi-cloud deployment models are reshaping resiliency design. Whether you’re new to Db2 or looking to strengthen your foundational knowledge, this session will give you t

Speakers

Iqbal Goralwalla

Principal Sales Engineer, Triton Consulting Ltd

An IBM Gold Consultant and an IBM Champion for Data Management, Iqbal Goralwalla has over 20 years of experience in all aspects of relational databases on the LUW platform. Iqbal is also a member of IBM’s Technical Advisory Board. Iqbal is a highly experienced Data Management specialist... Read More →

Damir Wilder

Db2 SME and Data Architect, Triton Consulting Ltd

I am a Senior Consultant at Triton Consulting, a UK based company that specializes in Hybrid Data Management, Digital Transformation and DB2 database and Information Management services for the z/OS and Midrange.
My area of expertise is the Midrange platform (predominantly Linux and AIX, both on-prem and Cloud).I have started working as a DB2 DBA in year 2000 on the DB2 version 5.0 and have working experience from that version up to the latest v12.1.I am a certified DB2 v10/v11.1/v11.5 LUW... Read More →

Tuesday September 29, 2026 10:20am - 11:20am BST
Porto

Track C, Technical Session

Topic Automation, Back to Basics, Database Resiliency
Audience Beginner
Platform LUW

10:20am BST

E6 High Availability Q-replication in a heterogeneous Db2 HA environment

Tuesday September 29, 2026 10:20am - 11:20am BST

Luis

When using Q-replication in evironments with different Db2 HA configuraions like HADR and pureScale and even single server Db2 installations or Db2 z/Os all together, configuration of Q-replication can become quite complex, especially on pureScale when trying to integrate the capture and apply programs into the resource model.
In this presentraion we will go through a different approach and build a seperate HA cluster for the Q-replication environment. This approach simplifies the setup of Q-replicatation and makes the target and source Db2 environment trasnparent to the replication environment, and it works with all possible Db2 setups.
And the best part, if you use Q-replication and Db2 LUW, you already have all the needed parts for this setup.

Speakers

Sven Heidorn

Senior Sales Engineer, CSN

I have 35 years of experience with Db2 starting with Db2 on z/OS but have spent the last 25 years working with Db2 LUW as a DBA and system programer. Primary expertise is with HA environment e.g. pureScale GDPC. I also have extensive experience with both SQL- and Q-replication.

Tuesday September 29, 2026 10:20am - 11:20am BST
Luis

Track E, Technical Session

Topic Database Resiliency, Data Movement and Integration, User Stories
Audience Intermediate
Platform LUW

11:30am BST

F7 The Anatomy of Universal Tablespaces

Tuesday September 29, 2026 11:30am - 12:30pm BST

Miragaia

Universal Tablespaces (UTS) have been the strategic tablespace types for Db2 for z/OS since Version 9, effectively rendering legacy tablespaces obsolete. But what truly lies beneath the surface? Why has IBM designated UTS as the future of data storage?
In this session, we will place the Universal Tablespace on the operating table for a surgical comparison against legacy objects. We will examine the internal anatomy of Partition-by-Growth (PBG) and Partition-by-Range (PBR) tablespaces. By dissecting the underlying page structures, space map management, and segmentation logic, we will reveal exactly what makes UTS special.
Join us for a deep dive into the bits and bytes of Db2 storage to understand why the transition to UTS is not just a recommendation, but a necessity for modern database performance and management.

Speakers

Emil Kotrc

Principal Software Architect, Broadcom

Emil is a software architect at Broadcom Mainframe Software, he holds a Ph.D. in Mathematical Engineering, is a member of the IDUG Content Committee, and an IBM Champion since 2015.

Tuesday September 29, 2026 11:30am - 12:30pm BST
Miragaia

Track F, Technical Session

Topic Back to Basics, Database Resiliency
Audience Intermediate
Platform z/OS

10:20am BST

B10 Db2 13 latest real customer experiences - new functions, best practices and some more…

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

Arrabida

This presentation will provide the ongoing success story Db2 z/OS Version 13 and covers the latest experiences with Db2 13 at Commerzbank AG. It will talk about some key important areas which are essential for the success and how to prevent some known avoidable pitfalls. We share the important latest experiences of the last 12 months, explains the upcoming and validated best practices in several key areas. This session will also dive into Function Level dependencies, maintenance aspects, some tooling dependencies, and some performance aspects as well as base utilities and system functionalities.

Speakers

Ute Kleyensteuber

Senior Technical Staff Member, Commerzbank AG

Ute Kleyensteuber is a Principal Product Owner, Senior Infrastructure Engineer and Director at Commerzbank AG in Germany, responsible for Db2 for z/OS since more than 35 years. Knowing and working with Db2 since Version 1.2 I've extensive experiences of Db2 in terms of system- and... Read More →

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

Track B, Technical Session

Topic Best Practices, Database Resiliency, Latest and Features z/OS, Security and Compliance, User Stories, Utilities
Audience All
Platform z/OS

2:00pm BST

F12 Hidden in Plain Sight: Unlocking Db2 for z/OS Recovery Capabilities at NatWest

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

Miragaia

In 2025, NatWest undertook a comprehensive reassessment of its Db2 recovery strategy to align with evolving banking regulations and to take advantage of modern platform capabilities. This review aimed to uncover limitations in existing processes, improve operational performance, and strengthen compliance.
As part of this effort, the bank evaluated Db2 utility features and automation tools that could streamline recovery activities, enforce consistent best‑practice standards, and reduce the need for continual manual tuning of utility options. Future resilience was also a priority, with the strategy designed to support NatWest’s planned adoption of Cyber Vault technology.
This session explores the challenges encountered throughout the transformation, the solutions implemented to overcome them, and the best practices that emerged—highlighting how NatWest is modernising its Db2 recovery landscape while preparing for the future.

Speakers

Dhiren Chaudhary

VP of Development and IBM Fellow, IBM Software, NatWest Group

I am a Technical Lead for Db2 at NatWest Group responsible for Db2 strategy and direction at the Bank. I oversee design for Db2 related new applications or changes to existing implementations. I also maintain the various standards related to Design, Performance, Utilities, Naming... Read More →

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

Track F, Technical Session

Topic Back to Basics, Best Practices, Database Resiliency, User Stories, Utilities
Audience All
Platform z/OS

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

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

A14 DDF Best Practice

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

Infante

Db2 Distributed Data Facility (DDF) is the gateway to delivering business enterprise data in our modern world of cloud computing. DDF is widely exploited in the information technology space and this session aims to share best practices and success stories to optimize your business with DDF. Some of the topics includes, infrastructure, security, protecting data over the network, monitoring resources (threads/connections), sysplex workload balancing, and so forth. The objective of this session is provide you with practical, useful knowledge that you can take back to your work and manage DDF confidently.

Speakers

Derek Tempongko

PM, IBM Silicon Valley Lab

Derek Tempongko is a Senior Software Engineer on the Db2 for z/OS distributed development team at the IBM Silicon Valley Laboratory. With over 20 years of experience in Distributed Data Facility (DDF), presented at previous IDUG events, authored a Redpaper on TLS/SSL which has been... Read More →

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

Track A, Technical Session

Topic Best Practices, Database Resiliency, Performance and Monitoring
Audience All
Platform z/OS

5:40pm BST

F14 Beyond COPY: Modern Recovery Strategies in Db2 for z/OS—Balancing Speed, Resilience, and Automation

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

Miragaia

In modern DB2 for z/OS environments, delivering efficient, resilient, and reliable services depends on the alignment of multiple critical components. With the introduction of DORA regulations, the focus has evolved from simply ensuring service continuity to enhancing it by making recovery processes faster, more robust, and easier to manage.
While many technologies and strategies already support service continuity, real-world scenarios still reveal gaps, particularly when unexpected errors lead to temporary service disruptions impacting customers.
Starting from a legacy disaster recovery framework based on traditional batch jobs, we conducted a thorough assessment to identify limitations in flexibility, performance, and reliability. Building on this foundation, we redesigned and enhanced recovery processes by introducing new strategies, improving automation, and increasing customization to better align with business objectives.
In this presentation, we share our journey: from understand

Speakers

Andrea Luca Boaretto

DB2 Administrator, Nexi Payments

I am a dedicated Database Administrator (DBA) at Nexi, a leading European PayTech company. I specialize in managing, optimizing, and securing complex database infrastructures that support mission-critical payment systems. With a strong focus on performance tuning, high availability... Read More →

Martin Crippa

Senior Solution Enginner, Nexi Payments

DB2 System Administrator with two years of experience working with IBM Db2 on z/OS. Currently working at Nexi Payments, managing DB2 environments supporting payment systems.
Experienced in both DBA and system-level activities, including database object management, system maintenance, and migration projects. Focused on ensuring performance, stability, and reliability in mission-critical environments... Read More →

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

Track F, Technical Session

Topic Database Resiliency, User Stories
Audience Intermediate
Platform z/OS

9:00am BST

A15 JC Greatest Hits, War Stories and Best Practice 2026

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

Infante

This session will share experience from client studies and engagements: sharing proven recommended best practice; learning good, bad and ugly; providing answers ti important, frqeeunt or difficuly questions. This session will cover the following topics: Complacency about component failure and ability to absorb workload failover in a dat asharing environment; missed opportinity for elapsed time performance improvementnfor skip sequnetial batch processing; misteps in evaluating the performance benenfit of CICS-Db2 thread reuse and RELEASE(DEALLOCATE); SQL coding to avoid update anomaly when using cursor stability isolation; misadventures when using High Performance DBATs;monitoring WLM policy achievement; options for mass data recovery following logical data recovery and data loss; performance issue with remote DDF batch workload; tuning ogf GBPs; thorough Disaster Restart testingh.

Speakers

John Campbell

Customer Success Engineer - Data Strategic, Broadcom

John is an IBM Alumni, a retired IBM Distinguished Engineer, and now works as a Distinguished Technical Consultant for Broadcom Inc. He has worked with Db2 for z/OS for over 40 years and has extensive experience with Db2 in terms of systems, database and application design. He specialises... Read More →

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

Track A, Technical Session

Topic Best Practices, Database Resiliency, Latest and Features z/OS, Performance and Monitoring, User Stories
Audience Intermediate
Platform z/OS

11:30am BST

F17 Architecting the Perfect Restore: Mastering Db2 Copies, and Compliance

Thursday October 1, 2026 11:30am - 12:30pm BST

Miragaia

Recovery is only as good as the backup that fuels it. While "taking an Image Copy" is a daily routine for every DBA, understanding the internal mechanics of that process is critical for modern data resilience. In this session, we go beyond the syntax to explore the physics of Db2 data protection.We will dissect the copy process showing how the choice of backup type directly dictates recovery performance.

Speakers

Ahmed Hamed

Software Engineer, Broadcom

Ahmed Hamed is a Software Engineer at Broadcom, specializing in the development and mission-critical support of Db2 Backup and Recovery solutions for z/OS. With nine years of experience in the software industry, the last seven are dedicated to the mainframe ecosystem. Ahmed focuses... Read More →