Loading…
Audience: Intermediate clear filter
Monday, September 28
 

11:30am BST

B2 Assessing Your Db2 Security for z/OS Without Losing Your Mind (or Your Data)
Monday September 28, 2026 11:30am - 12:30pm BST
Arrabida
As cyber threats grow increasingly sophisticated, ensuring the security of Db2 for z/OS environments is critical to protecting sensitive data and maintaining compliance. This presentation explores a comprehensive security assessment designed to identify vulnerabilities, evaluate access controls, and strengthen configurations. Experts with extensive mainframe experience will review key elements such as grants and permissions, DSNZPARMs, audit policies, and DDF settings, providing detailed findings and actionable recommendations. Attendees will gain insights into optimizing user privileges, securing data, while also preparing for an easier transition to external security. Enhance your security posture and mitigate risks with proven strategies tailored to Db2 for z/OS.
Speakers
avatar for Jørn Thyssen

Jørn Thyssen

Principal Solution Engineer, Rocket Software
Jørn Thyssen is a Senior Technical Staff Member at Rocket Software, working with mainframe and Db2 tools in customer modernization and performance projects. He has extensive experience with IBM Z and Db2 for z/OS, and collaborates closely with development teams on initiatives involving... Read More →
Monday September 28, 2026 11:30am - 12:30pm BST
Arrabida
  Track B, 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

3:20pm BST

B4 Z Data Integration Update
Monday September 28, 2026 3:20pm - 4:20pm BST
Arrabida
This session is about deep dive technical details of how Z data is integrated with other platforms and solutions.
This is an architectural, use case and product level technical session. There will be latest news from the zSW Development and Product Management in the context of Data Management, focused on Db2 for z/OS.
The goal of this session is

What are data modernization Challenges – Past, Present, Future
IBM Z Data and AI Enterprise Architecture
Architectural alternatives to provide Db2 for z/OS data into other platforms for data modernization story
Core Products, Virtualization, Data Integration and AI Techniques
Replicate, Direct Access, Virtualization – Pros & Cons.
Technical and Business Use Cases with Capabilities
Roadmaps and Future direction of IBM
Speakers
avatar for Cüneyt Göksu

Cüneyt Göksu

Executive IT Specialist, IBM
Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, Bachelor’s degree and PhD in Computer Science. He has been working with Db2 for z/OS and IBM Z... Read More →
avatar for Mateo Tošić

Mateo Tošić

Senior Technical Staff Member, IBM
Monday September 28, 2026 3:20pm - 4:20pm BST
Arrabida
  Track B, 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

B5 Beyond the Basics: Backup and Recovery for Resilient Db2 Environments
Monday September 28, 2026 4:30pm - 5:30pm BST
Arrabida
This session explores backup and recovery strategies for Db2 for z/OS, emphasizing the critical importance of compliance and recoverability in today’s data-driven world. Attendees will learn about various backup types, tools, and recovery processes, with a focus on creating resilient systems that align with modern compliance requirements. Through use cases, the session will demonstrate how to ensure recoverability, data integrity, minimize downtime, and maintain availability.
Speakers
avatar for Rahul Bajaj

Rahul Bajaj

Software Engineer, Broadcom
Rahul is a Db2 for z/OS professional at Broadcom Inc., working as part of the Db2 tools development team. His work focuses on supporting and evolving database management solutions that power critical enterprise systems.
avatar for Aysen Svoboda

Aysen Svoboda

Product Owner, Broadcom
A former System Programmer and DBA with 17 years in the mainframe space. Currently a Product Owner, dedicated to bridging the gap between software development and the real-world needs of the Db2 z/OS community.
Monday September 28, 2026 4:30pm - 5:30pm BST
Arrabida
  Track B, Technical Session
 
Tuesday, September 29
 

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

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

11:30am BST

F7 The Anatomy of Universal Tablespaces
Tuesday September 29, 2026 11:30am - 12:30pm BST
Miragaia
Universal Tablespaces (UTS) have been the strategic tablespace types for Db2 for z/OS since Version 9, effectively rendering legacy tablespaces obsolete. But what truly lies beneath the surface? Why has IBM designated UTS as the future of data storage?
In this session, we will place the Universal Tablespace on the operating table for a surgical comparison against legacy objects. We will examine the internal anatomy of Partition-by-Growth (PBG) and Partition-by-Range (PBR) tablespaces. By dissecting the underlying page structures, space map management, and segmentation logic, we will reveal exactly what makes UTS special.
Join us for a deep dive into the bits and bytes of Db2 storage to understand why the transition to UTS is not just a recommendation, but a necessity for modern database performance and management.
Speakers
avatar for Emil Kotrc

Emil Kotrc

Principal Software Architect, Broadcom
Emil is a software architect at Broadcom Mainframe Software, he holds a Ph.D. in Mathematical Engineering, is a member of the IDUG Content Committee, and an IBM Champion since 2015.
Tuesday September 29, 2026 11:30am - 12:30pm BST
Miragaia
  Track F, 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

2:00pm BST

E8 "No pain - no gain - story of optimizing DELETE purge processing"
Tuesday September 29, 2026 2:00pm - 3:00pm BST
Luis
A critical Db2 for z/OS purge batch is repeatedly abending after hitting CPU limits—without deleting a single row. What followed was a six-month troubleshooting marathon. With the batch spending over 80% of its time in I/O wait and racking up 500 million GETPAGEs on a 2-million-row table, standard tuning simply wasn't enough.This session dives into the gritty reality of complex performance tuning: the dead ends, the false starts, and the eventual breakthroughs. We will walk through the entire investigation—from utilizing monitoring tools to experimenting with UTS conversions and dedicated buffer pools. Finally, we’ll reveal how rethinking our DELETE index strategy, host variables, and leveraging ON DELETE CASCADE NOT ENFORCED transformed a CPU-crushing failure into a consistent, 20-minute purge process. Attendees will leave with a practical, battle-tested methodology for rescuing failing batch processes.
Speakers
avatar for Tereza Binarova

Tereza Binarova

Technical Lead zProducts, Kyndryl
Tereza Binarova is a Db2 for z/OS Database Administrator at Kyndryl, where she has worked since 2021. She specializes in performance optimization, concurrency tuning, and complex production problem resolution in enterprise mainframe environments. Her responsibilities include maintenance... Read More →
Tuesday September 29, 2026 2:00pm - 3:00pm BST
Luis
  Track E, Technical Session

2:00pm BST

F8 Ready Player One? Db2 vNext Migration (Made Easy)
Tuesday September 29, 2026 2:00pm - 3:00pm BST
Miragaia
Are you, and all of your sub-systems, ready for Db2 vNext that is coming to an enterprise near you soon? Are you aware that you cannot even get to Db2 13 FL511 if you have any of the specially announced “deprecated” items that we all have hanging around? Do you have a plan to get you out of this mess?
This session explains how you can find all the migration blockers that exist in your system and how to fix nearly all of them as well. It will also delve into VTAM/SNA and workfile usage to round off everything that can bite you!
Speakers
avatar for Roy Boxwell

Roy Boxwell

Senior Software Architect, Software Engineering GmbH
Roy is an IBM Champion with more than 40 years of experience in MVS, OS/390, and z/OS environments – 39 of those in Db2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real-time database maintenance... Read More →
Tuesday September 29, 2026 2:00pm - 3:00pm BST
Miragaia
  Track F, Technical Session

4:30pm BST

A9 Db2 zOS Utility Internals — and How to Get the Most Out of Them
Tuesday September 29, 2026 4:30pm - 5:30pm BST
Infante
Db2 utilities are fundamental to database availability, performance, and recoverability—yet many sites treat them as black boxes.
This session explores the internal behaviour of key Db2 z/OS utilities such as REORG, RUNSTATS, COPY, and LOAD. We examine how these utilities interact with data, logging, locking, and system resources, and how understanding their internals helps DBAs run them more efficiently and safely.

Description:
How Db2 utilities really run
How Db2 utilities use buffer pools, logging, IRLM, and the catalogWhy utilities should be treated like normal Db2 work, not background jobs
REORG utility explained
What happens during each REORG phase: unload, sort, reload, rebuild, and switchHow REORG affects locking and loggingWhen REORG improves performance and when it provides little or no benefit
RUNSTATS and the optimizer
Difference between table statistics and index statisticsHow histograms and sampling influence query plansWhy the timing of RUNSTATS matters for access pa
Speakers
avatar for Preetham Kannan

Preetham Kannan

Director of IT Services, Rocket Software
I am a Principal Software Engineer at Rocket Software India and a Subject Matter Expert for Db2 on z/OS, with over 20 years of experience supporting critical systems across Retail, Banking, and Manufacturing industries. I’m passionate about solving real‑world Db2 challenges and... Read More →
avatar for Kiran Seela

Kiran Seela

Senior Director, Rocket Software
I am a Senior Director at Rocket Software India with more than 25 years of experience driving technical excellence in mission‑critical enterprise environments. With a strong foundation in Db2 on z/OS and enterprise architecture, I lead modernization and innovation efforts that bridge... Read More →
Tuesday September 29, 2026 4:30pm - 5:30pm BST
Infante
  Track A, 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
 
Wednesday, September 30
 

10:20am BST

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

Colin Oakhill

Db2 LUW DBA, Insoft Infotel Software GmbH
Colin has been working with mainframes since 1974. Along his career he has worked as a systems programmer, DBA and developer. He started with CICS & IMS systems and with Db2 since 1988. He founded InSoft in 1986 and was chief architect and developer for the Db2 products. As part of... Read More →
Wednesday September 30, 2026 10:20am - 11:20am BST
Luis
  Track E, Technical Session

10:20am BST

F10 AI Agents Meet Mainframe: Building MCP Servers on Replicated Db2 z/OS Data
Wednesday September 30, 2026 10:20am - 11:20am BST
Miragaia
AI agents are transforming enterprise applications, but they need access to trusted, business-critical mainframe data. This session shows how MCP servers enable agents to query up-to-date, replicated Db2 z/OS data from targets like Db2 LUW or watsonx.data. It covers the rationale for agent integration, architecture patterns, implementation steps, and a live demo of an agent working with z/OS data.
Speakers
avatar for Cüneyt Göksu

Cüneyt Göksu

Executive IT Specialist, IBM
Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, Bachelor’s degree and PhD in Computer Science. He has been working with Db2 for z/OS and IBM Z... Read More →
avatar for Mateo Tošić

Mateo Tošić

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

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

2:00pm BST

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

Petr Plavjaník

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

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

5:40pm BST

D14 Db2 for z/OS Tuning Techniques: Practical Strategies for Maximum Performance
Wednesday September 30, 2026 5:40pm - 6:40pm BST
Maria
With growing data volumes, mixed workloads, and strict SLAs, effective tuning demands a structured, end-to-end approach.
This session focuses on practical, real-world Db2 tuning techniques that deliver measurable performance improvements in production systems. Attendees will learn how to identify high-cost SQL using Db2 accounting and statistics data, analyse access paths with EXPLAIN, and apply targeted tuning at the SQL, object, and subsystem levels.
Topics include SQL and predicate optimization, index design best practices, EDM pool and sort tuning considerations, and understanding performance differences between static and dynamic SQL.
Participants will leave with actionable techniques they can immediately apply to improve response times and control Db2 CPU usage.
Speakers
avatar for Devanand Karunakaran

Devanand Karunakaran

Senior Technical Advisor, BMC Software
Senior Solution Engineer at BMC, help our customers get the most out of our BMC AMI Data for Db2 and IMS products. Also, help our customers modernize their mainframe environment to meet their business and market demands. Have expertise on IBM MVS zOS DB2 and IMS mainframe platforms... Read More →
Wednesday September 30, 2026 5:40pm - 6:40pm BST
Maria
  Track D, Technical Session

5:40pm BST

E14 Detect, analyze and reduce IX Splits using RTS History.
Wednesday September 30, 2026 5:40pm - 6:40pm BST
Luis
Index pages splitting is a normal DB2 process when inserting or updating rows into table. However, this process can consume CPU resources and generate latch contention especially in a Data Sharing environment. Index page splits in also the main cause of index disorganization. In this presentation we will see how to identify costly index page splits and reduce their frequency with the help of RTS history tables.
Speakers
avatar for Laurent Kuperberg

Laurent Kuperberg

Db2 technical consultant, SQLK
Laurent has 30 years of experience in the DB2 world as a consultant. He has acquired expertise ranging from database design to system administration and data sharing.
He has developed his own REXX tools, which he makes available to everyone.
He also provides DB2 training... Read More →
Wednesday September 30, 2026 5:40pm - 6:40pm BST
Luis
  Track E, Technical Session

5:40pm BST

F14 Beyond COPY: Modern Recovery Strategies in Db2 for z/OS—Balancing Speed, Resilience, and Automation
Wednesday September 30, 2026 5:40pm - 6:40pm BST
Miragaia
In modern DB2 for z/OS environments, delivering efficient, resilient, and reliable services depends on the alignment of multiple critical components. With the introduction of DORA regulations, the focus has evolved from simply ensuring service continuity to enhancing it by making recovery processes faster, more robust, and easier to manage.
While many technologies and strategies already support service continuity, real-world scenarios still reveal gaps, particularly when unexpected errors lead to temporary service disruptions impacting customers.
Starting from a legacy disaster recovery framework based on traditional batch jobs, we conducted a thorough assessment to identify limitations in flexibility, performance, and reliability. Building on this foundation, we redesigned and enhanced recovery processes by introducing new strategies, improving automation, and increasing customization to better align with business objectives.
In this presentation, we share our journey: from understand
Speakers
avatar for Andrea Luca Boaretto

Andrea Luca Boaretto

DB2 Administrator, Nexi Payments
I am a dedicated Database Administrator (DBA) at Nexi, a leading European PayTech company. I specialize in managing, optimizing, and securing complex database infrastructures that support mission-critical payment systems. With a strong focus on performance tuning, high availability... Read More →
MC

Martin Crippa

Senior Solution Enginner, Nexi Payments
DB2 System Administrator with two years of experience working with IBM Db2 on z/OS. Currently working at Nexi Payments, managing DB2 environments supporting payment systems.
Experienced in both DBA and system-level activities, including database object management, system maintenance, and migration projects. Focused on ensuring performance, stability, and reliability in mission-critical environments... Read More →
Wednesday September 30, 2026 5:40pm - 6:40pm BST
Miragaia
  Track F, Technical Session
 
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

9:00am BST

B15 Db2 Analytics Accelerator: V8, Migration experiences, future and customer updates
Thursday October 1, 2026 9:00am - 10:00am BST
Arrabida
This session is deep dive technical details about Db2 Analytics Accelerator on IBM Z with latest V8 product updates, new capabilities, with migration details.
There will be z17 and LinuxONE 5 Migration Experiences with V7 and V8, platform specific details, migration planning and deployment details.
Session will contain IBM Z platform specific details z17 and LinuxONE 5, in the context of Accelerator such as machine configuration, CBU and Flex Capacity usage, different architecture alternatives for different business needs including GDPS usage with 2-, 3-, 4- site GDPS alternatives.
There will be Lessons Learned from PoCs, current implementations, architecture discussions and health checks.
Speakers
avatar for Cüneyt Göksu

Cüneyt Göksu

Executive IT Specialist, IBM
Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, Bachelor’s degree and PhD in Computer Science. He has been working with Db2 for z/OS and IBM Z... Read More →
BB

Björn Broll

Product Manager, Db2, IBM
Senior Technical Staff Member (STSM) for IBM z Data and AI in IBM Germany Research and Development Lab.
Thursday October 1, 2026 9:00am - 10:00am BST
Arrabida
  Track B, Technical Session

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

10:20am BST

A16 Get ready for Db2 version 13+1
Thursday October 1, 2026 10:20am - 11:20am BST
Infante
In the next version of Db2 for z/OS IBM is removing some deprecated functions. I will describe how to find the affected objects and functions and how to convert them. I will also touch on some pitfalls and share our experiences. Some examples are non-UTS tablespaces, but there are more. And there are some more things that is not documented yet.
The presentation will not cover the conversion from VTAM to TCPIP.
Speakers
avatar for Martin Ålund

Martin Ålund

STSM (Senior Technical Staff Member), Handelsbanken
Started my Db2 career in 1998 as a development DBA. Since 2020 working as a system programmer and tech lead for Db2 for z/OS.
Thursday October 1, 2026 10:20am - 11:20am 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

F16 Db2 Connect – New Challenges and New Opportunities
Thursday October 1, 2026 10:20am - 11:20am BST
Miragaia
Db2 Connect Version 12, released in November 2024, introduces a wave of enhancements—alongside changes that may challenge existing practices. This session will guide you through the most impactful updates in Db2 Connect V12 and its subsequent fix packs from a Db2 for z/OS perspective. We’ll explore critical topics such as strengthened TLS encryption, licensing transformations, and emerging capabilities in monitoring and observability. Join us to understand not only what’s new, but how these changes can unlock new opportunities for performance, security, and operational insight.
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 →
Thursday October 1, 2026 10:20am - 11:20am BST
Miragaia
  Track F, 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

C17 Accelerating AI Workloads in Db2 v12.1.5.0: Introducing High‑Performance Vector Indexes
Thursday October 1, 2026 11:30am - 12:30pm BST
Porto
Discover how Db2’s new DiskANN‑powered vector index delivers fast, scalable similarity search while integrating seamlessly into existing database workflows.
We’ll walk through expected performance gains using AWS benchmark results and share practical tuning strategies to help you get the most out of vector search in Db2.
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 →
Thursday October 1, 2026 11:30am - 12:30pm BST
Porto
  Track C, Technical Session

11:30am BST

E17 Db2 13 for z/OS – Security updates
Thursday October 1, 2026 11:30am - 12:30pm BST
Luis
Maintaining a secure Db2 for z/OS environment is essential for protecting critical business data and meeting continuously evolving compliance requirements. This session explores key Db2 security functions, including quantum safe encryption capabilities, online transfer ownership of application objects, and the process for removing private protocol authorization behavior. The session also covers enhanced usage capabilities of trusted contexts and column masks, as well as auditing security related catalog tables using temporal table support.
Speakers
GC

Gayathiri Chandran

Customer Success Manager and Principal Consultant, IBM
Gayathiri Chandran is a Senior Technical Staff Member in Db2 for z/OS development at IBM Silicon Valley Lab driving Db2 security strategy and delivery. She provides technical leadership across enterprise security initiatives, contributes to database security standards, and is a frequent... Read More →
Thursday October 1, 2026 11:30am - 12:30pm BST
Luis
  Track E, 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

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