Loading…
Subject: LUW clear filter
Sunday, September 27
 

9:00am BST

C201 From Db2 First Responder to Emergency Technician - The problem determination master workshop
Sunday September 27, 2026 9:00am - 1:00pm BST
Maria
Db2 delivers a wide range of tools for problem determination. Those tools range from the new Log Analysis Capability in IBM Db2 Genius Hub to classical tools that can and should be used for deeper analysis.
As the Db2 community constantly welcomes new database administrators and application developers, an effecient tooling and its use is required for those new community mambers.
The session will share tools and best practices for the first occurrence data capture (FODC) tools available for DBAs and developers. This session will cover the first steps in the process of problem determination and problem source identification (PD/PSI). It provides hands-on and practical examples for the strategy and process to encircle and find problems by asking the right questions.
Speakers
avatar for Olaf Depper

Olaf Depper

Customer Success Engineer, IBM
With over two decades of experience in the IT industry, I specialise in database technologies. Currently serving as a Customer Success Engineer at IBM, I focus on technical pre-sales for IBM Db2, IBM Netezza, IBM Informix, and OEM partners, leveraging my deep technical knowledge and... Read More →
avatar for Thomas Rech

Thomas Rech

Architect Db2 SAP Dev. & Client Adoption Engineering, IBM
Thomas has been working in the Db2 area since 1996. Starting as a Db2 course instructor, he soon moved to the SAP on Db2 environment in 1997. He joined the SAP/IBM Db2 Development Team, followed by a role as technical sales consultant. He led several lighthouse projects like the first... Read More →
Sunday September 27, 2026 9:00am - 1:00pm BST
Maria
  Track C, Workshop

9:00am BST

E201 Building AI Applications with a Serverless Database Workshop
Sunday September 27, 2026 9:00am - 1:00pm BST
Joao
This workshop will give you the education and information you need to to master building applications with a serverless database. In this workshop you learn how to use serverless capabilities in Db2 to go from prompt to production. You will learn about the power capabilities that Db2 provides and get to experience this yourself as you work through real world and customizable scenarios. If you want to supercharge your Db2 skills for the future this is the workshop to join.
Speakers
avatar for Andrew Hilden

Andrew Hilden

Chief Architect Db2 SaaS, IBM
Andrew Hilden is the Chief Architect of Db2 SaaS. He is involved extensively in the development and architecture of several data-oriented cloud services in IBM. In the past 25 years he has worked in development, architectural and leadership roles in Db2 from SaaS to areas like appliances... Read More →
Sunday September 27, 2026 9:00am - 1:00pm BST
Joao
  Track E, Workshop

2:00pm BST

C202 Believe It. Try It. Master Db2 Pacemaker on Any Cloud in 4 Hours.
Sunday September 27, 2026 2:00pm - 6:00pm BST
Maria
Become a Db2 Pacemaker Expert in Just 4 Hours — Across All Major Clouds and learn how Db2 supports the High Availability needs of many customers today. Db2 v11.5.5.0 saw the general availability of High Availability with Pacemaker on the Linux platform, providing a newer, Cloud-ready alternative to the TSA implementation. Newer releases have added support for AWS, Azure, Google Cloud, and IBM Cloud environments.
This - will give you hands-on experience for managing a Db2 HADR with Pacemaker Cluster on AWS, Microsoft Azure, Google Cloud, or IBM Cloud. The session will cover the Cloud-specific implementation of Fencing mechanisms and Virtual IP (VIP) addresses across different cloud platforms. Key topics include: Implementation of Route 53 for DNS-based VIP management, Setup of Disk Fencing, Qdevice (Quorum Device) for enhanced split-brain prevention.
Speakers
avatar for Nisha Choudhary

Nisha Choudhary

Solutions Advisor, IBM Germany
Nisha joined IBM in 2024. She is working with the SAP on Db2 LUW development team as a working student. In the past year, she is building a monitoring solution for Db2 which can integrate with all major public cloud platforms. Before IBM, she was working as a Software Engineer at... Read More →
avatar for Thomas Rech

Thomas Rech

Architect Db2 SAP Dev. & Client Adoption Engineering, IBM
Thomas has been working in the Db2 area since 1996. Starting as a Db2 course instructor, he soon moved to the SAP on Db2 environment in 1997. He joined the SAP/IBM Db2 Development Team, followed by a role as technical sales consultant. He led several lighthouse projects like the first... Read More →
Sunday September 27, 2026 2:00pm - 6:00pm BST
Maria
  Track C, Workshop
 
Monday, September 28
 

11:30am BST

C2 Latest From the Lab
Monday September 28, 2026 11:30am - 12:30pm BST
Porto
Learn about the latest developments in Db2 ecosystem coming out of the Labs. A refresher on whats been delivered already. A deep dive into the most recently released mod packs. And catch a sneak peak at our future plans.
Speakers
avatar for Mike Springgay

Mike Springgay

STSM Db2 Architect, IBM
Mike Springgay is the Db2 Architect. Prior to that he was responsible for architecting extensions to Db2’s Warehouse capabilities, SQL compatibility features, routine infrastructure and client server connectivity.
Monday September 28, 2026 11:30am - 12:30pm BST
Porto
  Track C, Technical Session

11:30am BST

D2 Bridging Relational and Data Lake Architectures: Db2 Datalake Tables
Monday September 28, 2026 11:30am - 12:30pm BST
Maria
Warehouse and data lakehouses are converging and Db2 is ready for this shift. Db2 Datalake tables enable access to open-format data stored on remote object storage directly from within the relational database, eliminating the need for complex ETL pipelines or data duplication. This session explores the technical architecture supporting both Hive (ODF) and Iceberg table formats, demonstrating how organizations can query PARQUET, ORC, AVRO, and TEXTFILE data alongside traditional Db2 tables in complex SQL queries while maintaining ACID properties where needed. Attendees will learn implementation strategies for converged warehouse architectures, performance optimization techniques, and real-world use cases where Datalake tables provide bidirectional data flow between relational databases and data lake / lakehouses.
Speakers
avatar for Olivier Bernin

Olivier Bernin

IBM Gold Consultant for Data & AI, IBM

Monday September 28, 2026 11:30am - 12:30pm BST
Maria
  Track D, Technical Session

11:30am BST

F2 Experiences with CDC Qlik Replicate as Db2 DBA
Monday September 28, 2026 11:30am - 12:30pm BST
Miragaia
For over two years, I've been managing QLIK Replicate as a Change Data Capture (CDC) tool for our Db2 LUW databases and also for the host Db2 z/OS. I've gained a lot of experience in this area, which I'd like to share. I'll describe the environment with replications between Db2 z/OS and Db2 LUW. For which use cases is the tool suitable, and for which is it less appropriate? What problems have we encountered, and what workarounds have we found?
Speakers
avatar for Michael Kühnel

Michael Kühnel

Owner, Professor, HUK-COBURG
Db2 LUW DBA since 2016 in a Data Warehouse environment
Monday September 28, 2026 11:30am - 12:30pm BST
Miragaia
  Track F, Technical Session

2:00pm BST

C3 Cloud Update: The latest on Db2 Fully Managed Services
Monday September 28, 2026 2:00pm - 3:00pm BST
Porto
Join us for a deep dive into the latest innovations shaping the continued evolution of Db2 Cloud Services across leading cloud platforms. This session explores recent advancements in Db2 SaaS including Db2 Serverless, AWS Amazon RDS for Db2, and Db2 as a Service on Microsoft Azure as well as Google Cloud. You’ll learn how these offerings enable flexible deployment choices while meeting demanding enterprise requirements. Whether your focus is efficient application development, optimization, regulatory compliance, cloud strategy, availability, or feature adoption, this session will demonstrate how Db2 Cloud Services are designed to adapt to your needs—providing enterprise-grade reliability, scalability, and flexibility.
Speakers
avatar for Venkatesh Gopal

Venkatesh Gopal

STSM, Warehouse SaaS Offerings, IBM
Venkatesh is an STSM at IBM focused on the Cloud offerings and HDM strategy for their offerings in these Hypersclaer platforms. He designs and architects how Db2 will be delivered on Cloud platforms as a first class SaaS offering and how they integrate with the Hyperscaler ecosys... Read More →
Monday September 28, 2026 2:00pm - 3:00pm BST
Porto
  Track C, Technical Session

2:00pm BST

D3 Underrated ITC Tables in Db2
Monday September 28, 2026 2:00pm - 3:00pm BST
Maria
Insert Time Clustering (ITC) tables are not an obscure feature in Db2 - many practitioners know them, and they do appear in logging, event, and similar append-oriented workloads. However, their practical design space is often underestimated, especially when the discussion stays at a high level and does not go into physical organization and concurrency details.
This session looks at ITC as a technical design choice rather than a theoretical table attribute. I will briefly position ITC within the Db2 table organization family and then focus on the internals that matter in practice: its MDC-derived physical layout, insert behavior, extent reuse, ordered access to rows in their natural arrival sequence, and the locking patterns taken on pages and extents during insert, scan, and processing activity. These details are not just implementation trivia - they directly determine whether ITC is a good fit for a given workload.
The talk will compare ITC with APPEND mode for FIFO-style patterns suc
Speakers
avatar for Alexander Veremev

Alexander Veremev

Senior System Engineer specializing in Db2 for z/OS, VereData
I started working with IBM Db2 on UNIX platforms in 1996 at the Institute for High Performance Computing and Databases in St. Petersburg, Russia. Since then, Db2 has remained at the core of my professional life. My education in Mathematics and Computer Science at Peter the Great St... Read More →
Monday September 28, 2026 2:00pm - 3:00pm BST
Maria
  Track D, Technical Session

3:20pm BST

C4 Performance monitoring made simple
Monday September 28, 2026 3:20pm - 4:20pm BST
Porto
This presention will give the attendee a deep understanding of real life performance problem determination.
Drawing on success and the custom tools and techiques developed tuning an OTLP database that sustains in excess of 100,000 SQL statement per second throughput, the focus will be on how to identify bottlenecks in the system before they start. Custom tools and targeted application of the right tool for the job will be the focus. Scripts for custom tools will be shared with attendees.
Speakers
LP

Leo Pedron

DBA, ASM Research, LLC
Senior Database Architect and Performance Engineering Specialist with over 22 years of experience designing, optimizing, and supporting mission-critical database systems using IBM Db2 LUW and PostgreSQL. Proven expertise operating large-scale transactional systems processing over... Read More →
Monday September 28, 2026 3:20pm - 4:20pm BST
Porto
  Track C, Technical Session

3:20pm BST

D4 What's New in V12.1 Security
Monday September 28, 2026 3:20pm - 4:20pm BST
Maria
This session will cover the new features in Db2 12.1 security, covering 12.1.3, 12.1.4 and 12.1.5. Attend to hear about new auditing capabilities, including audit to cloud object storage, and directly to CSV files. You will also learn about new JWT authentication enhancements features online key retrieval. 12.1.5 sees the completion of the reduce file permission feature started in 12.1.2 that really locks down a Db2 instance. You will also hear about new Quantum Safe Crypto support in TLS.
Speakers
avatar for Greg Stager

Greg Stager

Senior Software Engineer, IBM
Greg Stager is the security architect for Db2 LUW at the IBM Toronto Lab. Greg has been a member of the Db2 security development team since 2000, where he has worked on all aspects of security within Db2, including authentication, authorization, auditing and encryption.
Monday September 28, 2026 3:20pm - 4:20pm BST
Maria
  Track D, Technical Session

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
NM

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

4:30pm BST

D5 Db2 AI Query Rewrite
Monday September 28, 2026 4:30pm - 5:30pm BST
Maria
SQL is a very powerful language and can get complex. There are many ways of writing semantically equivalent queries.SQL SQL may be written by database users or ncluding external tools and these may not always be the most suitable for the Db2 engine for performance as written. The Query Rewrite component in Db2 helps towards simplifying this task for the user or external toolThe Query Rewrite (one of two optimizer components, the other being the Plan Optimizer) automatically rewrites queries within Db2 towards a better performing version for the Plan Optimizer and the Db2 execution engine.
This session delves into how AI is used to help the Query Rewrite component make better decisions. We present the challenges involved, how we tackle these challenges and touch on our next steps to transform the Query Rewrite component to exploit AI to make it even more powerful than it currently is.
Speakers
avatar for Calisto Zuzarte

Calisto Zuzarte

Principal Product Owner, IBM
Calisto Zuzarte is a Senior Technical Staff Member (STSM) in the Db2 development organization in IBM. His expertise is in query optimization and is focused on infusing AI in Db2 in this area towards making Db2 performant, reliable and easy to use.
Monday September 28, 2026 4:30pm - 5:30pm BST
Maria
  Track D, Technical Session

4:30pm BST

E5 Power-Up for Db2: A Guide to Modernizing Administration with Python and Ansible
Monday September 28, 2026 4:30pm - 5:30pm BST
Luis
As Db2 environments grow in complexity, traditional shell scripting often reaches its limits in maintainability and modern DevOps integration. This session serves as a high-level roadmap for Db2 administrators and developers to leverage Python and Ansible for modernizing their daily workflows. We will explore foundational database connectivity using the ibm_db driver and demonstrate how to transition from static text logs to interactive analysis using Pandas for efficient data wrangling and visualization. By utilizing modern tools like Jupyter Notebooks for exploration and Visual Studio Code for development, we will discuss the benefits of Object-Oriented Programming (OOP) in creating modular, reusable connector classes. Finally, the presentation dives into the DevOps world, showing how to extend Ansiblethrough custom filter, action, and lookup plugins to build flexible, database-driven automation frameworks.
Key Presentation Highlights:
Connectivity Essentials: A practical guide to se
Speakers
avatar for Norbert Munkel

Norbert Munkel

Senior Software Engineer, ITGAIN Consulting GmbH
Norbert Munkel is a veteran of the database and enterprise IT ecosystem with a career spanning nearly four decades. Currently a Senior Consultant and Specialist for Db2 (LUW), Python, and Ansible at x1F MTS GmbH he is a recognized speaker and regular contributor to the International... Read More →
Monday September 28, 2026 4:30pm - 5:30pm BST
Luis
  Track E, Technical Session
 
Tuesday, September 29
 

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
avatar for Iqbal Goralwalla

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 →
avatar for Damir Wilder

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

10:20am BST

D6 Permitting, masking and trusting, a deep dive into 3 new Db2 12.1 security features
Tuesday September 29, 2026 10:20am - 11:20am BST
Maria
This session is a deep dive into 3 new Db2 12.1 security features, Reduce file permissions, RCAC mask at read enhancements, and defining a Trusted Context using the new trust procedure and client callbacks. This will be a face paced session offering practical details on how to make use of these new features in more depth than a what's new session can cover. Reduced file permissions address the common concern of everyone having access to the db2diag.log (and others). Mask at read offers an alternative masking behaviour with fundamental changes to SQL behaviour. And Trust Procedures allow custom definitions of trust for determining a trusted connection.
Speakers
avatar for Greg Stager

Greg Stager

Senior Software Engineer, IBM
Greg Stager is the security architect for Db2 LUW at the IBM Toronto Lab. Greg has been a member of the Db2 security development team since 2000, where he has worked on all aspects of security within Db2, including authentication, authorization, auditing and encryption.
Tuesday September 29, 2026 10:20am - 11:20am BST
Maria
  Track D, Technical Session

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
avatar for Sven Heidorn

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

11:30am BST

C7 Db2 AI Query Optimizer: Smarter Plans, Less Tuning
Tuesday September 29, 2026 11:30am - 12:30pm BST
Porto
Since Db2 12.1, the Db2 AI Query Optimizer has been improving the quality of your query access plans through improved cardinality estimates. This was super-charged in 12.1 mod3 when it was enhanced to support pair-wise join cardinality estimates. Participants will learn how this technology reduces tuning efforts so you can confidently use it in production. You may also get a glimpse into what's in store for the future.
Speakers
avatar for Liam Finnie

Liam Finnie

Senior Software Developer, IBM
Liam joined IBM in 1999 as a software developer, and since then has been designing and implementing various features in Db2 LUW. Most recently, Liam has been leading the Machine Learning Infrastructure area for the Db2 AI Query Optimizer.
Tuesday September 29, 2026 11:30am - 12:30pm BST
Porto
  Track C, Technical Session

11:30am BST

D7 Near zero downtime migration to Db2 12.1
Tuesday September 29, 2026 11:30am - 12:30pm BST
Maria
When upgrading to Db2 12.1 additional activities like OS upgrade or cluster technique change might occur. In addition, test migrations should be possible with no or minimal impact on a productive system. The presentation shows, how Db2 can be migrated to 12.1 including OS upgrade scenarios and cluster technology changes, build on pure Db2 functionality. It describes a near zero downtime solution. With it's repeatability, the solution can easily be used for pre-migration testing.
Speakers
avatar for Christiane Beyer

Christiane Beyer

Senior Solution Engineer, Arvato Systems GmbH
Experienced IT professional with over 25 years experience in database administration on LUW.
Specialized in IBM Db2 on Linux over 10 years. Supporting High Availability Systems in health care & financial sector, which are based on IBM Db2 HADR TSAMP & Pacemaker Cluster.
Tuesday September 29, 2026 11:30am - 12:30pm BST
Maria
  Track D, Technical Session

11:30am BST

E7 Why this query runs so slow? Step-by-step SQL troubleshooting with MON_GET interfaces and event monitors
Tuesday September 29, 2026 11:30am - 12:30pm BST
Luis
It is the classic DBA dilemma: the statistics are current, the access plan looks "clean" at first glance, yet the application is dragging. When the low-hanging fruit has been picked, how do you move from intuition to evidence-based troubleshooting?
This session follows a real-world "detective story" of a slow-running SQL statement originating from a Java (JDBC) application. We will move beyond basic EXPLAIN facility outputs to uncover the hidden bottlenecks that standard tools often miss. Using a step-by-step methodology, we will demonstrate how to:
- Capture the invisible: Isolate specific statements from the Package Cache and extract elusive parameter marker values.
- Leverage MON_GET: Use light-weight monitoring interfaces to identify where time is actually being spent (CPU vs. Wait times).
- Analyze the "Why": Utilize Activity Event Monitors and Section Actuals to compare estimated vs. actual cardinalities within a live execution.
- Apply Surgical Fixes: Explore advanced remediatio
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.
Tuesday September 29, 2026 11:30am - 12:30pm BST
Luis
  Track E, Technical Session

2:00pm BST

C8 Db2 Meets Generative AI: Agentic AI, Vector Search, and Beyond.
Tuesday September 29, 2026 2:00pm - 3:00pm BST
Porto
This session will bring you up to speed on exciting enhancements and capabilities we are bringing to Db2 for the Generative AI era. We’ll talk about our overall AI strategy for Db2 and how we are both leveraging Generative AI as well as supporting the emerging frontier of Generative AI applications. We’ll then dive into specifics including our AI Vector Search capabilities, AI integrated LLM capabilities, and our Agentic AI powered tooling including the new Genius Hub.
Speakers
avatar for Jillian Quiller

Jillian Quiller

Senior Software Engineer, Db2 Development, IBM
Growth Product Manager focused on accelerating adoption and impact across IBM’s Db2 portfolio. I combine analytics, design thinking, and experimentation to help enterprise customers unlock value faster — turning insights into measurable, scalable growth.
avatar for Mike Springgay

Mike Springgay

STSM Db2 Architect, IBM
Mike Springgay is the Db2 Architect. Prior to that he was responsible for architecting extensions to Db2’s Warehouse capabilities, SQL compatibility features, routine infrastructure and client server connectivity.
Tuesday September 29, 2026 2:00pm - 3:00pm BST
Porto
  Track C, Technical Session

2:00pm BST

D8 SQL in Action: One Statement to Rule Them All - MERGE and integrated SQL operations
Tuesday September 29, 2026 2:00pm - 3:00pm BST
Maria
If multiple statements can be combined into a single one it will be more efficient.
In this session we will explore multiple options to combine different SQL statements. Have you ever used the FINAL TABLE clause or selected the data you just deleted? Besides this the main focus is on the MERGE stamement which is probably the most powerful SQL operation which offers a lot of processing options and can even be used in ETL architectures and with temporal tables. Practical use case will be shown and explained.
Speakers
avatar for Michael Tiefenbacher

Michael Tiefenbacher

Distinguished Engineer, Broadcom
Michael Tiefenbacher holds a Master of Science degree from the Munich Institute of Technology. He began his career as a Db2 trainer and was instrumental in introducing IBM’s Business Intelligence course curriculum in Germany.
With more than 25 years of experience in projects an... Read More →
Tuesday September 29, 2026 2:00pm - 3:00pm BST
Maria
  Track D, Technical Session

4:30pm BST

C9 Mining db2mon
Tuesday September 29, 2026 4:30pm - 5:30pm BST
Porto
The folks at the Db2 Lab provide us with a great tool to monitor Db2. it's free and already installed with Db2. This session will show you how db2mon works and how to use it. Then, we'll discuss how to run it in different ways for different use cases. Next, we'll present a way to run db2mon for historical data gathering and trend analysis. Finally, we'll show examples of the data db2mon provides and what to look for in various performance scenarios.
Speakers
avatar for Ken Shaffer

Ken Shaffer

Db2 Consultant, Aerodata, Inc.
Ken has been a Db2 Consultant for over 20 years, specializing in LUW systems. He has worked on a variety of large databases for large corporate and government clients. Most of these projects have involved deploying and supporting mission-critical applications where constant availability... Read More →
Tuesday September 29, 2026 4:30pm - 5:30pm BST
Porto
  Track C, Technical Session

4:30pm BST

D9 More SQL tricks with Db2
Tuesday September 29, 2026 4:30pm - 5:30pm BST
Maria
SQL is a very powerful language. But to make best use of it one has to come to a "set-oriented" thinking to solve problems instead of the procedural thinking most application programmers are used to. This presentation discusses some important problems for which a set-oriented solution is initially not obvious, and shows how solutions of these problems can be developed with SQL in Db2. This presentation is a continuation with new problems and solutions of the presentation "SQL tricks with Db2" shown at IDUG EMEA 2024.
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 →
Tuesday September 29, 2026 4:30pm - 5:30pm BST
Maria
  Track D, Technical Session
 
Wednesday, September 30
 

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

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

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

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
 
Thursday, October 1
 

9:00am BST

C15 A Modern Approach to Db2 Backup & Recovery: Snapshot Technology with Cloud Integration
Thursday October 1, 2026 9:00am - 10:00am BST
Porto
This session presents a comprehensive approach to database backup and recovery using Snapshot Backup technology integrated with Cloud infrastructure. The solution leverages the Db2 ACS Scripted interface to automate backup operations on Linux systems, enabling efficient data protection strategies for enterprise databases.
The implementation utilizes Linux LVM (Logical Volume Manager) to create consistent point-in-time snapshots of database volumes, ensuring data integrity during backup operations.
By combining snapshot-based backup techniques with cloud object storage capabilities, this approach delivers a robust disaster recovery solution that minimizes backup windows, reduces storage costs, and enhances data availability. The scripted automation through Db2 ACS interface ensures consistent, repeatable backup procedures while maintaining operational efficiency in Linux environments.
This methodology addresses critical requirements for modern database management, including rapid recov
Speakers
avatar for Thomas Rech

Thomas Rech

Architect Db2 SAP Dev. & Client Adoption Engineering, IBM
Thomas has been working in the Db2 area since 1996. Starting as a Db2 course instructor, he soon moved to the SAP on Db2 environment in 1997. He joined the SAP/IBM Db2 Development Team, followed by a role as technical sales consultant. He led several lighthouse projects like the first... Read More →
Thursday October 1, 2026 9:00am - 10:00am BST
Porto
  Track C, Technical Session

9:00am BST

D15 Db2 Upgrade Lessons the Manuals Don’t Teach You
Thursday October 1, 2026 9:00am - 10:00am BST
Maria
Db2 upgrades can look straightforward in your favourite manual, but real-world environments often tell a different story. In this session, we share practical user experiences and lessons learned from two recent Db2 upgrade projects that we undertook – moving from Db2 v11.1 to v11.5 on Windows, and from Db2 v11.5 to v12.1.3 on Linux. These upgrades involved very different setups, including single versus multiple instances, standalone databases versus HADR clusters, and the contrasting challenges between Windows and Linux platforms. We will walk through the expected and unexpected issues we encountered, highlight pitfalls not clearly documented in the manuals, and explain the workarounds and strategies that allowed us to complete the upgrades successfully.
Speakers
avatar for Iqbal Goralwalla

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 →
avatar for Damir Wilder

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 →
Thursday October 1, 2026 9:00am - 10:00am BST
Maria
  Track D, Technical Session

9:00am BST

E15 Vibe Coding with a Serverless Database
Thursday October 1, 2026 9:00am - 10:00am BST
Luis
In this session we will show you how application building with a serverless database gives you superpowers. Serverless databases are built for the AI Era handling the workloads of the future and turning you into a 10X Engineer. We will show you how to develop applications for Db2 from prompt to production and demonstrate how a serverless database tackles AI and Machine driven workloads all while reducing cost and effort. Join us for this groundbreaking session and experience the future of Db2 SaaS services!
Speakers
avatar for Andrew Hilden

Andrew Hilden

Chief Architect Db2 SaaS, IBM
Andrew Hilden is the Chief Architect of Db2 SaaS. He is involved extensively in the development and architecture of several data-oriented cloud services in IBM. In the past 25 years he has worked in development, architectural and leadership roles in Db2 from SaaS to areas like appliances... Read More →
Thursday October 1, 2026 9:00am - 10:00am BST
Luis
  Track E, Technical Session

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
avatar for Olivier Bernin

Olivier Bernin

IBM Gold Consultant for Data & AI, IBM

Thursday October 1, 2026 10:20am - 11:20am BST
Porto
  Track C, Technical Session

10:20am BST

D16 Db2 as Containerized Deployment
Thursday October 1, 2026 10:20am - 11:20am BST
Maria
Db2 containerization makes Db2 more flexible, scalable, and cloud-native by running it in containers managed by Kubernetes. As Kubernetes is constantly evolving, so does Db2U, our Db2 Universal Container. Come and learn the great deal of innovative work coming your way, in terms of the next-gen capabilities of Db2U.
Speakers
avatar for Vijaya Katikireddy

Vijaya Katikireddy

Senior Technology Leader, IBM

Thursday October 1, 2026 10:20am - 11:20am BST
Maria
  Track D, Technical Session

11:30am BST

D17 Using Db2 for more than just relational data
Thursday October 1, 2026 11:30am - 12:30pm BST
Maria
Many users and applications make only use of Db2 as a relational database. But Db2 is much more than just a relational database. Db2 support the efficient processing of JSON and XML data, allows queries on spatial data, and supports text search and even semantic searches. This presentation gives an overview of these "non-relational" features of Db2, and demonstrates how these features can be used and combined to implement various use cases.
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 →
Thursday October 1, 2026 11:30am - 12:30pm BST
Maria
  Track D, Technical Session

2:30pm BST

C203 Amazon RDS for Db2 Workshop
Thursday October 1, 2026 2:30pm - 6:30pm BST
Maria
This updated workshop will give you the education and information you need to use existing and new features of Amazon RDS for Db2. Some of the topics covered during this workshop will include provisioning, scaling, backup, monitoring, migration and beyond.
Each module will be introduced and presented and then participants will be provided an environment they can use and go through a series of instructor led exercises to practice what they have learned and explore. This will be a joint workship between the IBM and AWS RDS teams.
Speakers
avatar for Hafsa Ali

Hafsa Ali

Executive IT Specialist for IBM® Z solutions, IBM

avatar for Javeed Mohammed

Javeed Mohammed

Sr. Database Solutions Architect, Amazon Web Services
Javeed is a Sr. Database Specialist Solutions Architect with Amazon Web Services. He works with the Amazon RDS team, focusing on commercial database engines like Db2 and Oracle. He enjoys working with customers to help design, deploy, and optimize relational database workloads in... Read More →
Thursday October 1, 2026 2:30pm - 6:30pm BST
Maria
  Track C, Workshop
 

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.
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