Loading…
Company: Performance and Monitoring clear filter
Sunday, September 27
 

9:00am BST

B201 Hands-on Lab: Project Aura - Infusing Db2 for z/OS with AI
Sunday September 27, 2026 9:00am - 1:00pm BST
Porto
Artificial intelligence is transforming how database administrators manage and optimize enterprise data platforms. By integrating AI capabilities directly into Db2 for z/OS, organizations can streamline operations, gain faster insights, and reduce the time required to diagnose and resolve complex database issues.
Experience the enhanced and smarter solution built on top of IBM Db2 AI for z/OS. It provides a unified intelligent workspace that acts as a force multiplier for every DBA, enabling intelligent and automated database administration and accelerating troubleshooting. This helps application and AI initiatives move faster.
With these enhanced capabilities, you will learn how to perform core DBA tasks such as catalog navigation, SQL tuning, and troubleshooting issues like deadlocks, timeouts, and lock escalations. You will also explore object management, Db2 health checks, and the AI agent that translates complex issues into simple, understandable explanations.
Please bring your la
Speakers
JL

Jae Lee

Db2 for z/OS Development, IBM
Jae Lee is a Senior Software Engineer at the IBM Silicon Valley Lab, specializing in the development of Db2 AI for z/OS, SQL Data Insights, and the Db2 RDS component.
avatar for Brian Tsao

Brian Tsao

System Architekt, IBM
Architect of IBM Z Database Assistant and Technical Lead for IBM Db2 for z/OS Agent. Experienced in enterprise mainframe systems, modern cloud-native tooling, and emerging agentic workflows. Passionate about bridging Z systems with modernization, driving innovation that brings legacy... Read More →
Sunday September 27, 2026 9:00am - 1:00pm BST
Porto
  Track B, Hands-On Lab

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

2:00pm BST

B202 Next Chapter for Db2 for z/OS Administration and Development - Workshop
Sunday September 27, 2026 2:00pm - 6:00pm BST
Porto
Join us for an exciting workshop to learn how you can benefit from the latest capabilities to boost your Db2 for z/OS user experience. During this workshop, we will present the overall architecture and showcase the recent features designed to transform the experience of database administrators and application developers.
The workshop attendees will have opportunity to interact with the presenters to simulate their daily tasks and test drive the solution. For example:

Db2 administrator personas, will experience a very intuitive way to tuning queries, catalog navigation, capture SQLs from different sources, stabilize and free SQLs, etc…
Db2 application developer personas, will experience how they can meet the fast-paced demands of today’s businesses by developing, testing and deploying applications, including stored procedures, via the most popular development tool integrated with Db2 for z/OS.
Speakers
avatar for Sueli Almeida

Sueli Almeida

IBM Certified Thought Leader, IBM Silicon Valley Lab
Sueli Almeida is an IBM Certified Thought Leader and member of Db2 for z/OS development located at the IBM Silicon Valley Lab in San Jose, California. She has extensive experience with DB2, including database administration and systems programming. She has worked on DB2 for z/OS advanced... Read More →
avatar for Brian Tsao

Brian Tsao

System Architekt, IBM
Architect of IBM Z Database Assistant and Technical Lead for IBM Db2 for z/OS Agent. Experienced in enterprise mainframe systems, modern cloud-native tooling, and emerging agentic workflows. Passionate about bridging Z systems with modernization, driving innovation that brings legacy... Read More →
Sunday September 27, 2026 2:00pm - 6:00pm BST
Porto
  Track B, Workshop
 
Monday, September 28
 

11:30am BST

A2 Hard Lessons Learned with High Performance DBATs for Db2 for z/OS
Monday September 28, 2026 11:30am - 12:30pm BST
Infante
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.
Speakers
avatar for John Campbell

John Campbell

Customer Success Engineer - Data Strategic, Broadcom
John is an IBM Alumni, a retired IBM Distinguished Engineer, and now works as a Distinguished Technical Consultant for Broadcom Inc. He has worked with Db2 for z/OS for over 40 years and has extensive experience with Db2 in terms of systems, database and application design. He specialises... Read More →
Monday September 28, 2026 11:30am - 12:30pm BST
Infante
  Track A, Technical Session

2:00pm BST

A3 What’s New in Db2 for z/OS Performance
Monday September 28, 2026 2:00pm - 3:00pm BST
Infante
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
Speakers
avatar for Akiko Hoshikawa

Akiko Hoshikawa

Distinguished Engineer - Db2 for z/OS and Db2 AI for z/OS, IBM

Monday September 28, 2026 2:00pm - 3:00pm BST
Infante
  Track A, 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

E4 Smarter Db2 REORGs : A Real-World User Story
Monday September 28, 2026 3:20pm - 4:20pm BST
Luis
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.
Speakers
avatar for Shivam Pratap Singh

Shivam Pratap Singh

Database Performance Specialist, Kyndryl CIC S.R.O., Brno
Shivam pratap singh is a Senior Lead Database Administrator specializing in Db2 Z/OS, with extensive experience supporting large enterprise environments. His work focuses on Db2 operations, performance optimization, automation and modernizing existing processes. He works with customers... Read More →
Monday September 28, 2026 3:20pm - 4:20pm BST
Luis
  Track E, Technical Session

3:20pm BST

F4 Insights and experiences from GarantiBBVA's Fast Traverse Block index implementation in production
Monday September 28, 2026 3:20pm - 4:20pm BST
Miragaia
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
Speakers
avatar for Ayşenur Başoğlu

Ayşenur Başoğlu

Senior Consultant, GarantiBBVA
I am a Database Administrator and System Engineer with 7 years of experience in Db2 for z/OS at Garanti BBVA. My work focuses on Db2 migrations, function level activation, and RSU maintenance, as well as maintaining the IBM Db2 Analytics Accelerator (IDAA) environment. I am also actively... Read More →
avatar for Gülfem Öğütgen

Gülfem Öğütgen

Db2 for z/OS, Data &AI on IBM Z Systems mainframe db2 systems programmer and dba, IBM
Gulfem has over 30 years of experience in mainframes and in Db2 for z/OS. She has worked as a database administrator, system administrator in financial institutions including leading banks in Turkey and also as a database consultant in IBM business partners and consultancy companies... Read More →
Monday September 28, 2026 3:20pm - 4:20pm BST
Miragaia
  Track F, Technical Session

4:30pm BST

A5 Starter’s Guide to Db2 for z/OS Group Buffer Pool Monitoring and Tuning
Monday September 28, 2026 4:30pm - 5:30pm BST
Infante
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.
Speakers
BS

Bart Steegmans

Db2 for z/OS L2 Performance, IBM
Bart Steegmans is a Consulting Db2 Product Support Specialist from IBM Belgium. He is working remotely for the Silicon Valley Laboratory in San Jose and providing technical support for Db2 for z/OS performance problems. He has over 35 years of experience in Db2.  Before joining IBM... Read More →
Monday September 28, 2026 4:30pm - 5:30pm BST
Infante
  Track A, 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
 
Tuesday, September 29
 

11:30am BST

B7 Revisiting Query Parallelism: Targeted Use of zIIP Processors for Db2 Queries
Tuesday September 29, 2026 11:30am - 12:30pm BST
Arrabida
This presentation explores the nuances of query parallelism in Db2, focusing on how to effectively tune queries for optimal zIIP exploitation. Attendees will gain insights through real-world query examples that will illustrate these principles in action, showcasing tangible improvements. Additionally, we will discuss how ChatGPT can assist in the query tuning processs. Join me to rediscover the power of parallelism and leverage zIIP processors to their fullest potential.
Speakers
avatar for Thomas Baumann

Thomas Baumann

Data Evangelist, Swiss Mobiliar
As Data Evangelist at Swiss Mobiliar in Bern, Switzerland, Thomas is dedicated to optimizing databases and managing database risks. When he's not in the office, he can be found sharing his expertise on database optimization and risk management at various speaking engagements. Thomas... Read More →
Tuesday September 29, 2026 11:30am - 12:30pm BST
Arrabida
  Track B, Technical Session

2:00pm BST

B8 Get Cozy with WLM: Why Every Db2 DBA Needs to Understand Workload Management
Tuesday September 29, 2026 2:00pm - 3:00pm BST
Arrabida
Many Db2 DBAs treat the z/OS Workload Manager (WLM) as "the system programmer’s problem," but WLM is actually the engine that determines if your SQL succeeds or fails. In this session, we will demystify WLM from a DBA’s perspective. We’ll cover the basics: defining service classes, importance, and goals. You will learn how WLM distinguishes between "local" work (like batch) and "remote" SQL (using enclaves), and why this matters for your daily performance monitoring. We’ll wrap up with simple best practices and a look at how to spot WLM issues before they become outages. Join this session to learn how to speak the language of WLM and ensure your Db2 workload gets the priority it deserves.
Speakers
avatar for Denis Tronin

Denis Tronin

Product Manager, Broadcom Mainframe Software
Denis Tronin is an experienced IT professional and product manager, skilled in mainframe technologies (Db2 for z/OS, system performance, workload automation), API management (Zowe API Mediation Layer), and DevOps. He is an IBM Champion and a frequent speaker at major industry con... Read More →
Tuesday September 29, 2026 2:00pm - 3:00pm BST
Arrabida
  Track B, 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

4:30pm BST

B9 Buffer Pool tuning process with a reverse application analysis
Tuesday September 29, 2026 4:30pm - 5:30pm BST
Arrabida
The presentation is based on real life BPool tuning process for one of the Ensono clients. The "reverse application analysis" reveals the opportunities the IFCID(199) usage gives to every Db2 SYSPROG.
The standard Ensono BPool tuning process presented with a multiple charts.It also was enhanced with IFCID(199) implementation, giving amaizing results.
How to use IFCID(199), different characteristics SYNC I/O, ASYNCH I/O, GetPages can be involved into the the analysis uncovering the hidden performance bugs.
Speakers
avatar for Pawel Hryb

Pawel Hryb

Senior Mainframe DB2 Systems Programmer, Ensono
Started as a System Programmer for VM/ESA and then z/OS in 1997.With Db2 v4 from 1998.For a couple of years a developer in Cobol, PL/I, REXX (ocasionally is still doing this for admin purposes :-) for a smaller polish software company.In 2005 started my longest carrier span for the... Read More →
Tuesday September 29, 2026 4:30pm - 5:30pm BST
Arrabida
  Track B, 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
 
Wednesday, September 30
 

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

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

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

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

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

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

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

9:00am BST

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

John Campbell

Customer Success Engineer - Data Strategic, Broadcom
John is an IBM Alumni, a retired IBM Distinguished Engineer, and now works as a Distinguished Technical Consultant for Broadcom Inc. He has worked with Db2 for z/OS for over 40 years and has extensive experience with Db2 in terms of systems, database and application design. He specialises... Read More →
Thursday October 1, 2026 9:00am - 10:00am BST
Infante
  Track A, Technical Session

10:20am BST

B16 From Lilliput to Brobdingnag. Compression flavors in Db2 for z/OS
Thursday October 1, 2026 10:20am - 11:20am BST
Arrabida
There are several flavors of compression in Db2 for z/OS.
You can reduce the space required for a table by using data compression. Compressing the data in a table space can significantly reduce the amount of disk space that is needed to store data and can help improve buffer pool performance.
You can also compress your indexes to significantly reduce the physical space requirements for most indexes.
You can also reduce the size of data in a LOB table space to ensure that the LOB table space and its associated base table space remain available for inserting data.
In this presentation you will learn the different algorithms used for compression in Db2, comparing the cost and benefit of each of them. You will learn how to measure the effect of compression, the space savings but also the effect on applications and utility processing and of course the recent changes in the latest versions and function levels of Db2 for z/OS.
Speakers
avatar for Ramon Menendez

Ramon Menendez

Senior Technical Staff Member, BMC Software
Ramon Menendez is a Principal Solution Engineer from BMC Software in Spain, specialized in the DB2 family of products. Started in IT as a QUEL developer and INGRES administrator. Worked for several years for IBM with DB2, mainly in competitive analysis, implementation and performance... Read More →
Thursday October 1, 2026 10:20am - 11:20am BST
Arrabida
  Track B, 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

E16 Getting Started with OpenTelemetry for Db2: Metrics, Traces, and What They Really Mean
Thursday October 1, 2026 10:20am - 11:20am BST
Luis
OpenTelemetry is becoming a standard for observability,but what does it mean for Db2? This introductory session shows how metrics and traces help you understand what’s really happening in your Db2 workloads. Learn how SQL activity can be exposed as meaningful metrics, and how distributed traces can follow transactions end-to-end into Db2.We focus on practical outcomes: where time is spent, where bottlenecks occur, and whether issues originate in Db2 or upstream systems. Designed for DBAs and performance specialists, this session gives you a clear starting point to understand what these signals really mean, and how to begin using them in your day-to-day work.
Speakers
avatar for Rabah Beggar

Rabah Beggar

Software Developer, Broadcom
Product Manager at Broadcom, part of the team shaping the strategy and roadmap for mainframe database and infrastructure tools (IMS & Db2). I focus on simplifying complex operations and enhancing the experience for enterprise customers running critical workloads on the mainframe... Read More →
Thursday October 1, 2026 10:20am - 11:20am BST
Luis
  Track E, Technical Session

11:30am BST

A17 DB2 for z/OS Workfile Deep Dive - How to Survive and Thrive
Thursday October 1, 2026 11:30am - 12:30pm BST
Infante
This presentation explains how DB2 uses workfiles for a range of purposes, including SORT, scrollable cursors, and temporary tables. It also describes how workfile allocation and usage behave both before and after the enhancements introduced in V13 FL508. Finally, it reviews the workfile monitoring capabilities available today, with particular emphasis on the enhancements introduced over the past decade and how they can be leveraged to identify tuning opportunities.
Speakers
avatar for Adrian Collett

Adrian Collett

Consultant, Expertise4IT
Adrian is a partner and Senior DB2 Specialist for Expertise4IT S.r.l. based in Milan, Italy. Although specialising in System and Application Performance Tuning, Adrian has been involved in all aspects of DB2 for z/OS: from Systems Analysis, Data Modelling and Database Design to Implementation... Read More →
BS

Bart Steegmans

Db2 for z/OS L2 Performance, IBM
Bart Steegmans is a Consulting Db2 Product Support Specialist from IBM Belgium. He is working remotely for the Silicon Valley Laboratory in San Jose and providing technical support for Db2 for z/OS performance problems. He has over 35 years of experience in Db2.  Before joining IBM... Read More →
Thursday October 1, 2026 11:30am - 12:30pm BST
Infante
  Track A, Technical Session

11:30am BST

B17 Leave the dark side – Turn on the lights in Db2 performance management
Thursday October 1, 2026 11:30am - 12:30pm BST
Arrabida
In this session we will demonstrate how data can be utilized to gain valuable insights into system performance and optimization. We will provide an introduction of the newest and greatest capabilities in visualizing performance data for an easy step in, which can lead to significant performance improvements.
The objective of this session is to demonstrate some real-world examples mainly out of Db2 and WLM and how visualizing performance data helped the Performance Teams diagnose performance issues, better perform capacity planning and how attendees can learn easily more about their z/OS /CICS /Db2 environment.
Speakers
avatar for Tim Meisner

Tim Meisner

Teamlead zProducts, SVA GmbH
My mainframe career started in 2001 at an independent software vendor in Germany developing tools for Db2. I began as developer for a tool automating Db2 maintenance. Then moving forward as lead for a point in time recovery tool and later added a tool for homogenous system cloning... Read More →
avatar for Gerald Pfeiffer

Gerald Pfeiffer

Senior Database Administrator, SVA GmbH
After a few years as a bank clerk, I started my mainframe career in 1987.So next year, I 'm 40 years Mainframe Professional. I began as a developer, then moved to systems engineering and project management at banks and insurance companies. In 1997, I joined my first ISV. Primarily... Read More →
Thursday October 1, 2026 11:30am - 12:30pm BST
Arrabida
  Track B, Technical Session

11:30am BST

F17 Architecting the Perfect Restore: Mastering Db2 Copies, and Compliance
Thursday October 1, 2026 11:30am - 12:30pm BST
Miragaia
Recovery is only as good as the backup that fuels it. While "taking an Image Copy" is a daily routine for every DBA, understanding the internal mechanics of that process is critical for modern data resilience. In this session, we go beyond the syntax to explore the physics of Db2 data protection.We will dissect the copy process showing how the choice of backup type directly dictates recovery performance.
Speakers
avatar for Ahmed Hamed

Ahmed Hamed

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

Vyacheslav Stebletsov

Staff Software Engineer, Broadcom

Thursday October 1, 2026 11:30am - 12:30pm BST
Miragaia
  Track F, Technical Session

2:30pm BST

A203 From Problem SQL to Proven Gains: Tuning Performance on Db2 for z/OS
Thursday October 1, 2026 2:30pm - 6:30pm BST
Infante
SQL performance tuning is a core DBA skill, yet many efforts remain reactive and inconsistent. This session presents a practical, end-to-end tuning workflow for Db2 for z/OS from identifying problem SQL to validating improvements. Attendees will walk through real tuning decisions using metrics, access path analysis, and supporting tools to achieve measurable performance gains.
Speakers
avatar for Carlos Davis

Carlos Davis

Back-End Developer, Rocket Software
Carlos Davis is a Solutions Advisor at Rocket Software with more than 20 years of hands-on experience powering mission critical Db2 environments across a wide range of industries. As a trusted advisor to his clients, he helps organizations maximize performance, minimize risk, and... Read More →
Thursday October 1, 2026 2:30pm - 6:30pm BST
Infante
  Track A, 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