IDUG EMEA 2026

High Performance DBATs (HP DBATS) is a very important performance feature of Db2 for DDF workloads. If applied and used intelligently this feature can generate significant savings in CPU resource consumption. This session will cover the following topics: what is a connection?; what is a DBAT (THREAD)?; thread (DBAT) pooling and DRDA inactive connections; what are High Performance DBATs; good candidate application workloads for High Performance DBATs; general guidance for configuring High Performance DBATs; performance metrics and monitoring; WLM and High Performance DBATs; Issues; Summary.

Db2 for z/OS continues to advance through Db2 13 continuous delivery, introducing performance‑focused enhancements that impact SQL execution, system scalability, resource efficiency, and operational behavior. Effectively exploiting these capabilities requires understanding not only what has changed, but how the changes interact with workloads, subsystem configuration, and the underlying IBM Z platform.
This session provides a technical deep dive into recent Db2 for z/OS performance enhancements, including features delivered through Db2 13 continuous delivery and insights gained from real customer experiences. We will examine how these updates influence critical performance areas such as CPU consumption, concurrency behavior, and subsystem scalability.
In addition, we will cover monitoring and instrumentation updates, discussing how to interpret new or enhanced metrics and how they can be used to validate performance behavior and guide tuning decisions.
Attendees will leave with concret

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

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.

Many Db2 environments still depend on inherited, legacy home-grown housekeeping processes, increasing cost, risk and instability. This session shares a customer journey that modernized REORG strategy using data-driven principles and operational criteria. We discuss organizational challenges, architectural decisions, and unexpected outcomes, offering guidance for a more sustainable and scalable Db2 housekeeping model.

The presentation is aiming to explore the introduction and evolution of Fast Traversal Blocks (FTB) in IBM Db2 for z/OS, focusing on the initial implementation in Db2 12 and the subsequent enhancements delivered in Db2 13.
The session will outline the architectural concepts behind FTB, key eligibility criteria, and the functional improvements introduced in Db2 13 for z/OS. The major focus of the presentation will be a real-world case study from GarantiBBVA, highlighting their experience implementing FTB in their Db2 for z/OS systems. This includes practical insights into planning, configuration, and deployment strategies, as well as challenges encountered and lessons learned during adoption. It will also examine how to identify suitable indexes for FTB and the tangible benefits of FTB usage at GarantiBBVA. The session will also be aiming to demonstrate how to measure and validate performance improvements using key metrics, system statistics, and monitoring tools. By combining theoreti

Db2 group buffer pools are an important component of a Db2 for z/OS datasharing environment. They help to insure data consistency across members of aDb2 data sharing group.As such, group buffer pool interactions represent additional work that Db2 hasto perform in a data sharing environment, and are one of the main contributorsof Db2 data sharing overhead.Therefore, from a performance perspective it is important that your group bufferpools are in good shape.This session will introduce group buffer pool concepts, but focusses on how tomonitor group buffer pool performance, the available options and metrics touse.

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.