IDUG EMEA 2026: Full Schedule

arrow_back View All Dates

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

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

10:20am BST

E10 “Stabilize your Dynamic SQL and don’t let it remain Unpredictable”

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

Luis

In the world of Db2 for z/OS, SQL performance tuning is one of the most critical and often most complex of DBA tasks. While static SQL has long been the standing order for traditional mainframe applications, the growing use of dynamic SQL - driven by modern applications, APIs, and distributed workloads - has changed the tuning game.Dynamic SQL’s agility and flexibility introduces a new layer of complexity that can hinder performance if not well managed and cause inconsistent performance and even be unpredictable. Dynamic SQL is becoming more prevalent as agile development and hybrid workloads become the norm. But with the flexibility of dynamic SQL comes responsibility - DBAs must adapt and develop new ways of monitoring and tuning dynamic workloads in real-time and across the application lifecycle. Colin Oakhill will share a proven approach to bring order to chaos by giving DBAs the visibility, control, and insight they need to ensure that dynamic SQL performs efficiently and predic

Speakers

Colin Oakhill

Db2 LUW DBA, Insoft Infotel Software GmbH

Colin has been working with mainframes since 1974. Along his career he has worked as a systems programmer, DBA and developer. He started with CICS & IMS systems and with Db2 since 1988. He founded InSoft in 1986 and was chief architect and developer for the Db2 products. As part of... Read More →

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

Track E, Technical Session

Topic Best Practices, Latest and Features z/OS, Performance and Monitoring
Audience Intermediate
Platform z/OS

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

A12 Db2 13 for z/OS – DDF Connection Security controls

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

Infante

Db2 for z/OS offers advanced capabilities to strengthen security management in distributed environments. This session discusses best practices for establishing secure connections including protected ID authentication using SSL, IDT, or trusted connection. This session also reviews the key system parameters that govern distributed access and discusses how system profile tables can be leveraged to enforce granular connection controls and secure TCP/IP connectivity.

Speakers

Gayathiri Chandran

Customer Success Manager and Principal Consultant, IBM

Gayathiri Chandran is a Senior Technical Staff Member in Db2 for z/OS development at IBM Silicon Valley Lab driving Db2 security strategy and delivery. She provides technical leadership across enterprise security initiatives, contributes to database security standards, and is a frequent... Read More →

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

Track A, Technical Session

Topic Best Practices, Security and Compliance
Audience All
Platform z/OS

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

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

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

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

B14 The Db2z Game: From 90% to "The 1% Club"

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

Arrabida

Think you’re in the elite 1% of Db2 for z/OS pros? Or just starting your journey to the top? Ditch the slides for a high-stakes, 1% Club style tournament! We’ll scale the heights of Db2 knowledge together, from SQL basics to zIIP offloading and hex-level internals. It’s a no-shame game where every wrong answer leads to a deep-dive technical debrief. Come for the fun, stay for the insights, and level up your Db2 skills!

Speakers

Michal Bialecki

Principal Software Engineer, Broadcom

Michal Bialecki is a Db2 Technical Consultant at Broadcom, bringing over 20 years of experience to the role. Prior to joining Broadcom in 2025, he spent two decades working remotely for IBM Silicon Valley Lab, where he served as a member of Db2 z/OS Development SWAT team with John... Read More →

Julia Carter

Db2 Technical Consultant, Broadcom

Julia Carter has 20 years' experience with Db2 and is a Db2 Consultant at Broadcom in Europe. Previously she has worked as a Database Administrator for banks in the UK and Mexico.
She is a member of the IDUG Content Committee and Global Marketing Committee and is co-host of the IDUG Db2 Table Talk podcasts. Julia has been an IBM Champion for Data and AI since 2020... Read More →

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

Track B, Technical Session

Topic Best Practices
Audience All
Platform z/OS

5:40pm BST

D14 Db2 for z/OS Tuning Techniques: Practical Strategies for Maximum Performance

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

Maria

With growing data volumes, mixed workloads, and strict SLAs, effective tuning demands a structured, end-to-end approach.
This session focuses on practical, real-world Db2 tuning techniques that deliver measurable performance improvements in production systems. Attendees will learn how to identify high-cost SQL using Db2 accounting and statistics data, analyse access paths with EXPLAIN, and apply targeted tuning at the SQL, object, and subsystem levels.
Topics include SQL and predicate optimization, index design best practices, EDM pool and sort tuning considerations, and understanding performance differences between static and dynamic SQL.
Participants will leave with actionable techniques they can immediately apply to improve response times and control Db2 CPU usage.

Speakers

Devanand Karunakaran

Senior Technical Advisor, BMC Software

Senior Solution Engineer at BMC, help our customers get the most out of our BMC AMI Data for Db2 and IMS products. Also, help our customers modernize their mainframe environment to meet their business and market demands. Have expertise on IBM MVS zOS DB2 and IMS mainframe platforms... Read More →

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

Track D, Technical Session

Topic Best Practices, Performance and Monitoring, User Stories
Audience Intermediate
Platform z/OS

5:40pm BST

E14 Detect, analyze and reduce IX Splits using RTS History.

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

Luis

Index pages splitting is a normal DB2 process when inserting or updating rows into table. However, this process can consume CPU resources and generate latch contention especially in a Data Sharing environment. Index page splits in also the main cause of index disorganization. In this presentation we will see how to identify costly index page splits and reduce their frequency with the help of RTS history tables.

Speakers

Laurent Kuperberg

Db2 technical consultant, SQLK

Laurent has 30 years of experience in the DB2 world as a consultant. He has acquired expertise ranging from database design to system administration and data sharing.
He has developed his own REXX tools, which he makes available to everyone.
He also provides DB2 training... Read More →

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

Track E, Technical Session

Topic Best Practices, Performance and Monitoring, User Stories
Audience Intermediate
Platform z/OS

10:20am BST

10:20am BST

11:30am BST

11:30am BST

2:00pm BST

2:00pm BST

2:00pm BST

4:30pm BST

4:30pm BST

5:40pm BST

5:40pm BST

5:40pm BST

5:40pm BST

Get help with the event