Loading…
arrow_back View All Dates
Wednesday, September 30
 

9:00am BST

K3 Women in Technology (WIT): TEAMship – The Human Side of High Performance
Wednesday September 30, 2026 9:00am - 10:00am BST
Noble
Technology transforms organizations, but people determine whether transformation succeeds.

Drawing from two decades at the highest level of international sport, Ann Wauters explores what enables teams to perform consistently in environments where change, pressure and complexity are the norm.

Through inspiring stories and practical insights, she shares how trust, leadership, ownership and connection create the foundation for innovation, collaboration and sustainable high performance.

Because the strongest teams are not built on expertise alone—they are built on people who bring out the best in one another.
Speakers
avatar for Ann Wauters

Ann Wauters

President, Athletes' Commission of the Belgian Olympic and Interfederal Committee (BOIC)
Ann Wauters is a former professional basketball player, Olympic athlete and one of Europe's most decorated basketball players of all time. During her twenty-year international career, she won a WNBA Championship, four EuroLeague titles, and was named European Player of the Year five... Read More →
Wednesday September 30, 2026 9:00am - 10:00am BST
Noble
  Keynote, Keynote

9:00am BST

IDUG Badging
Wednesday September 30, 2026 9:00am - 5:30pm BST
Laboratory

Wednesday September 30, 2026 9:00am - 5:30pm BST
Laboratory
  Badging, Certification & Badging

9:00am BST

IDUG Certification
Wednesday September 30, 2026 9:00am - 5:30pm BST
Laboratory

Wednesday September 30, 2026 9:00am - 5:30pm BST
Laboratory
  Certification, Certification & Badging

10:00am BST

Coffee Break
Wednesday September 30, 2026 10:00am - 10:20am BST
Archive
Wednesday September 30, 2026 10:00am - 10:20am BST
Archive
  IDUG, Break

10:20am BST

A10 Linuxification of Db2 for z/OS - a journey from ISPF and JCL to Shell and Playbooks
Wednesday September 30, 2026 10:20am - 11:20am BST
Infante
This session will be about bridging existing legacy programs with "modern"interfaces, such as the Unix shell and Ansible. Next-generation mainframers are typically well-versed in Unix shells and scripting, largely due to Linux's dominance in the server market. But how does this apply to traditional mainframe tools? That is what we want to show you.
Speakers
avatar for Emil Kotrc

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.
avatar for Marketa Muzikova

Marketa Muzikova

Software Architect, Broadcom
Markéta is an experienced software engineer with expertise in mainframe automation, including Ansible and Zowe. Markéta is a recognised expert on Ansible and facilitates the Broadcom Ansible Collection.
Wednesday September 30, 2026 10:20am - 11:20am BST
Infante
  Track A, Technical Session

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
avatar for Ute Kleyensteuber

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

10:20am BST

C1 Db2 Spotlight Session / Latest News
Wednesday September 30, 2026 10:20am - 11:20am BST
Porto
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
avatar for David Kalmuk

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

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
avatar for Mark Gillis

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

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
avatar for Martin Heitkämper

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

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
avatar for Colin Oakhill

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

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
avatar for Cüneyt Göksu

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 →
avatar for Mateo Tošić

Mateo Tošić

Senior Technical Staff Member, IBM
Wednesday September 30, 2026 10:20am - 11:20am BST
Miragaia
  Track F, Technical Session

10:30am BST

IDUG Db2 for LUW Essentials
Wednesday September 30, 2026 10:30am - 5:30pm BST
Glass 1

Speakers
avatar for Davor Rodnis

Davor Rodnis

IDUG Db2 for LUW Essentials Instructor
Davor is an expert trainer and consultant with 30+ years’ experience in Db2. He specialized in providing Db2 and other training services for IBM customers in over 25 countries according to global standards. He has taught over 300 courses on IBM software products as an IBM Authorized... Read More →
Wednesday September 30, 2026 10:30am - 5:30pm BST
Glass 1
  Essentials, Essentials

10:30am BST

IDUG Db2 for z/OS Essentials
Wednesday September 30, 2026 10:30am - 5:30pm BST
Noble

Speakers
avatar for Dougie Lawson

Dougie Lawson

IDUG Db2 for z/OS Essentials Instructor

Wednesday September 30, 2026 10:30am - 5:30pm BST
Noble
  Essentials, Essentials

11:30am BST

A11 From Pay Slips to P1 Incidents: Db2 for z/OS in a Payroll Company
Wednesday September 30, 2026 11:30am - 12:30pm BST
Infante
In this session, I provide an inside look at how Db2 is used, operated, and evolved within SD Worx, a payroll/HR service provider, running running a mixed COBOL and .NET application landscape.
The presentation walks through the Db2 environment at SD Worx and illustrates real-world production workloads (with its struggles). We'll explore trends in Db2 growth, the impact of data integration (including the migration from IDMS), and how replication technologies are used to offload reporting, analytics, and decentral processing without impacting core workloads.
Special attention is given to Db2 Connect and connection management challenges in distributed .NET environments. Including real‑world P1 incidents (don't trust your distributed teams blindly!) and how to avoid them using Db2 Profiles, driver configuration and monitoring.Db2 Profiles are also used to regain control over legacy clients and get rid of the soon to be deprecated (and this time for real!) synonyms, which will be explained
Speakers
avatar for Tim Vermeulen

Tim Vermeulen

Senior Technical Staff Member, SD Worx
Tim Vermeulen started his career where many Db2 problems are first observed: as a mainframe operator, watching production at 3 a.m. and wondering who scheduled that job. From there, he grew into an application DBA, then a Db2 for z/OS system DBA - a role he still actively performs... Read More →
Wednesday September 30, 2026 11:30am - 12:30pm BST
Infante
  Track A, Technical Session

11:30am BST

B11 Bringing Mainframe into the Future: OpenTelemetry for Db2 for z/OS
Wednesday September 30, 2026 11:30am - 12:30pm BST
Arrabida
OpenTelemetry is rapidly becoming the industry standard for application observability —offering a unified approach across distributed platforms. But did you know that even mainframe applications and subsystems can now be part of this modern observability ecosystem?
In this session, we’ll dive into what OpenTelemetry means from a Db2 for z/OS perspective. You’ll learn its core concepts, why they matter for mainframe environments, and how to take your first steps toward OpenTelemetry-based end-to-end monitoring of Db2 for z/OS applications with minimal effort. We’ll also highlight common pitfalls and explain why OpenTelemetry complements — rather than replaces — traditional Db2 monitoring.
Speakers
avatar for Christoph Theisen

Christoph Theisen

Db2 Security Architect, Rocket Software
Christoph began his career in IBM’s Global Services unit in 1991, working on numerous client engagements — primarily focused on Db2 for z/OS — as an application developer, database administrator, architect, and consultant. Over time, his role evolved into that of a Client Technical... Read More →
Wednesday September 30, 2026 11:30am - 12:30pm BST
Arrabida
  Track B, Technical Session

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
avatar for Dale McInnis

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

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
avatar for Olaf Stephan

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

11:30am BST

E11 Exploring Db2 explain facility for the next Gen of Db2 DBAs and using AI to bridge the skills gap.
Wednesday September 30, 2026 11:30am - 12:30pm BST
Luis
Poorly written or optimized Db2 SQL queries can use huge amounts of CPU and render applications unusable causing business impact.
This session will cover the different types of access paths the Db2 Optimizes uses to return data for queries and discuss their merits and use cases. We will look at the data written by the DB2 optimizer in the EXPLAIN tables and how we can interpret the data using AI to determine if an SQL is going to be cheap or expensive to run.
The session will cover filter factors and the role of RUNSTATS on access path selection and cover how one can influence the access path.
Speakers
avatar for Phill Baker

Phill Baker

Software Consultant, BMC
A passionate technologist specializing in BMC mainframe solutions. Twenty plus years experience working as a Database engineer across Db2, SQL Server, MySQL and Oracle.  Working on mainframe z/OS, AIX, Linux, UNIX and Windows, supporting large scale data warehouse applications to... Read More →
Wednesday September 30, 2026 11:30am - 12:30pm BST
Luis
  Track E, Technical Session

11:30am BST

F11 SQL Oldies but Goodies and the Power of the SQL Rewrite
Wednesday September 30, 2026 11:30am - 12:30pm BST
Miragaia
There have been so many enhancements in Db2 SQL for developers in the last 3 or 4 versions that many developers have never really taken advantage of. This presentation picks my personal favorites that I believe all developers should get knowledgeable on and possibly applied to current and future applications. Developers should be informed of all of newer features in Db2 and this presentation is a great summary for this topic. When it comes to performance, often times the answer to better performance is rewriting queries different ways, and redesigning programs differently. Attendees will leave with a better understanding of some great SQL enhancements, application table designs, along with getting stronger in the SQL language. This is a great session for developers on Db2 LUW or Db2 z/OS. Developers 'Get Empowered'.
Speakers
avatar for Tony Andrews

Tony Andrews

Mainframe Db2 Developer, Performance and Tuning, P&T Solutions, Inc.
Tony Andrews has more than 30 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs... Read More →
Wednesday September 30, 2026 11:30am - 12:30pm BST
Miragaia
  Track F, Technical Session

12:30pm BST

Lunch & Passport to Prizes Drawing
Wednesday September 30, 2026 12:30pm - 2:00pm BST
Archive
Wednesday September 30, 2026 12:30pm - 2:00pm BST
Archive
  IDUG, Lunch

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
GC

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

2:00pm BST

B12 Db2 critical events monitoring
Wednesday September 30, 2026 2:00pm - 3:00pm BST
Arrabida
Db2 for z/OS environments generate thousands of system messages and codes every day, only a small subset of which indicate truly critical conditions. This session focuses on how Db2 DBAs can effectively identify, interpret, and respond to critical events that threaten system availability, data integrity, resource consumption, and security. Starting from the structure and meaning of Db2 messages, reason codes, and return codes, the presentation walks through real-world scenarios such as log space exhaustion, storage shortages, dataset access failures, and recovery-related errors. Attendees will learn how to distinguish symptoms from root causes and how timely detection can prevent hangs, outages, and data loss. The session emphasizes a proactive monitoring and troubleshooting approach based on SYSLOG and Db2 address space analysis. It is aimed at Db2 DBAs who want to strengthen operational resilience, improve incident response, and consistently meet SLA and recovery objectives.
Speakers
avatar for Roberto Cason

Roberto Cason

Sales Engineer Manager, BMC Software

Wednesday September 30, 2026 2:00pm - 3:00pm BST
Arrabida
  Track B, Technical Session

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
avatar for David Kalmuk

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

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
avatar for Robert Proffitt

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

2:00pm BST

E12 SQL Injection on SterAIds: Is Your Db2 Ready for AI-Assisted Attackers?
Wednesday September 30, 2026 2:00pm - 3:00pm BST
Luis
SQL injection remains one of the most damaging classes of flaws against data-driven applications—and the workflow around it has changed: security testers and attackers alike can pair classic tooling with generative AI to iterate payloads faster, interpret ambiguous responses, and explore injection chains with less manual trial and error. This session focuses on Db2-backed applications: how SQL injection manifests in practice, how to recognize fragile dynamic SQL and unsafe integration patterns, and how to prioritize prevention (parameterization, safe composition, and tight error handling). We will connect that baseline to today’s landscape—examples include AI-assisted DAST/exploration tools, AI-augmented automation around sqlmap, and red-team harnesses that probe whether LLM-driven apps avoid unsafe database access—so you leave with a clearer understanding of both defenses and new risks.This is an upgraded version of my session on IDUG EMEA 2022: SQL Injection and Db2 - Pathology and P
Speakers
avatar for Petr Plavjaník

Petr Plavjaník

Db2 Architect, Broadcom
AI assistants are most useful when they can act on real systems through well-defined tools. Zowe MCP brings the open Model Context Protocol to z/OS so assistants in VS Code and other MCP clients can work with data sets, jobs, USS, and commands in a structured, guardrailed way. This... Read More →
Wednesday September 30, 2026 2:00pm - 3:00pm BST
Luis
  Track E, Technical Session

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
avatar for Dhiren Chaudhary

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

3:00pm BST

Coffee Break
Wednesday September 30, 2026 3:00pm - 3:20pm BST
Archive
Wednesday September 30, 2026 3:00pm - 3:20pm BST
Archive
  IDUG, Break

3:20pm BST

A102 Z Data and Application integration for Analytics and AI
Wednesday September 30, 2026 3:20pm - 4:20pm BST
Infante

Sponsors
I
Wednesday September 30, 2026 3:20pm - 4:20pm BST
Infante
  PSP, PSP

3:20pm BST

B102 I Know Why I’m Seeing Red: Db2 Performance Dashboards
Wednesday September 30, 2026 3:20pm - 4:20pm BST
Arrabida

Sponsors
B
Wednesday September 30, 2026 3:20pm - 4:20pm BST
Arrabida
  PSP, PSP

3:20pm BST

C102 Smart Db2 Administration (z/LUW)
Wednesday September 30, 2026 3:20pm - 4:20pm BST
Porto

Sponsors
I
Wednesday September 30, 2026 3:20pm - 4:20pm BST
Porto
  PSP, PSP

3:20pm BST

D102 Coming Soon
Wednesday September 30, 2026 3:20pm - 4:20pm BST
Maria

Wednesday September 30, 2026 3:20pm - 4:20pm BST
Maria
  PSP, PSP

3:20pm BST

F102 Coming Soon
Wednesday September 30, 2026 3:20pm - 4:20pm BST
Miragaia

Wednesday September 30, 2026 3:20pm - 4:20pm BST
Miragaia
  PSP, PSP

4:30pm BST

A13 Db2 for z/OS Expert Panel
Wednesday September 30, 2026 4:30pm - 5:30pm BST
Infante

Wednesday September 30, 2026 4:30pm - 5:30pm BST
Infante
  Track A, Expert Panel

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
avatar for Les King

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

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
avatar for Kamil Kuduk

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

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
avatar for David Lynch

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

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
avatar for Andreas Weininger

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

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
avatar for Christian Garcia-Arellano

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

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

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
avatar for Derek Tempongko

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

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
avatar for Michal Bialecki

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 →
avatar for Julia Carter

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

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
avatar for Devanand Karunakaran

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

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
avatar for Laurent Kuperberg

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

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
avatar for Andrea Luca Boaretto

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 →
MC

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
 

Get help with the event

Contact event planner Event login
View support guides Find upcoming events
Create an event you'd love to attend!
Explore why organizers choose Sched • Success stories
Event App • Event scheduling • Event registration • Event ticketing • Sched forms • Call for papers • Badges • Conferences
© 2026. SCHED LLC - All rights reserved - Helping events since 2008
Event Planning App • Privacy • Terms
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Filtered by Date - 
Clear filter
Sunday, September 27
Monday, September 28
Tuesday, September 29
Wednesday, September 30
Thursday, October 1
Archive
Arrabida
Glass 1
Infante
Joao
Laboratory
Luis
Maria
Miragaia
Noble
Porto
  • Badging
  • Certification
  • Essentials
  • Expert Panel
  • IDUG
  • Keynote
  • PSP
  • Track A
  • Track B
  • Track C
  • Track D
  • Track E
  • Track F
  • Topic
  • AI GenAI and Machine Learning
  • AppDev
  • Automation
  • Back to Basics
  • Best Practices
  • Data Movement and Analytics
  • Data Movement and Integration
  • Database Resiliency
  • Db2 Cloud and Warehouse
  • Expert
  • Keynote
  • Latest and Features LUW
  • Latest and Features z/OS
  • Modernization in Development
  • Modernization in Operations
  • Performance and Monitoring
  • PSP
  • Security and Compliance
  • User Stories
  • Utilities
  • Working with SQL
  • Audience
  • All
  • Beginner
  • Intermediate
  • Platform
  • AI / ML
  • AppDev
  • Cross Platform
  • LUW
  • z/OS
  • Company
  • Broadcom
  • IBM