Loading…
Company: Working with SQL clear filter
Sunday, September 27
 

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

2:00pm BST

E202 SQL Correction Agent: Building a Self-Correcting AI Agent for Db2
Sunday September 27, 2026 2:00pm - 6:00pm BST
Joao
Standard Text-to-SQL tools fail when they hit the complexity of enterprise Db2 schemas. This hands-on session demonstrates how to transition from basic prompting to Agentic AI - creating an autonomous "Query Guard" that reasons, acts, and fixes its own mistakes.We will build an agent capable of navigating the Db2 lifecycle independently.You will learn to architect a Agent that doesn't just error out, but proactively traps SQLCODEs, autonomously queries the Db2 Catalog to resolve schema mismatches, and refactors its own SQL on the fly.
Attendees will leave with a functional blueprint for an agent that transforms Db2 from a passive subsystem into a resilient, self-healing partner. This will be an hands on Session so attendes will learn to create agents around DB2
Speakers
avatar for Niraj Garudkar

Niraj Garudkar

Senior Db2 LUW Consultant, BMC Software
I am a Data Scientist at BMC Software, where I work on integrating agentic AI with mainframe systems. My work focuses on applying modern AI techniques to mission‑critical enterprise platforms, with a strong emphasis on DB2, IMS and intelligent automation across mainframe environments... Read More →
Sunday September 27, 2026 2:00pm - 6:00pm BST
Joao
  Track E, Hands-On Lab
 
Monday, September 28
 

2:00pm BST

F3 Connect, Visualise, Predict: Visualization Db2 Data on z/OS using Python libraries and Machine learning tools.
Monday September 28, 2026 2:00pm - 3:00pm BST
Miragaia
In the modern era of data-driven decision-making, leveraging the power of mainframe data, such as Db2 on z/OS, can provide deep insights into business operations. However, visualizing this data and utilizing advanced analytics can often seem challenging. This session will explore how Python libraries, along with machine learning tools, can bridge the gap by providing intuitive and powerful solutions to visualize and analyze Db2 data on z/OS.
We will begin by discussing the fundamentals of accessing Db2 data on z/OS using Python library ibm_db. Once data is ready we will explore popular python libraries to create clear and informative visualizations.
The session will then dive into the integration of machine learning tools, to uncover hidden patterns in the data, perform predictive analytics, and gain deeper insights.
Speakers
avatar for Niraj Garudkar

Niraj Garudkar

Senior Db2 LUW Consultant, BMC Software
I am a Data Scientist at BMC Software, where I work on integrating agentic AI with mainframe systems. My work focuses on applying modern AI techniques to mission‑critical enterprise platforms, with a strong emphasis on DB2, IMS and intelligent automation across mainframe environments... Read More →
Monday September 28, 2026 2:00pm - 3:00pm BST
Miragaia
  Track F, Technical Session

3:20pm BST

A4 Supercharging Db2 with Generative AI: From Natural Language Queries to Autonomous Performance Optimization
Monday September 28, 2026 3:20pm - 4:20pm BST
Infante
Enterprises are under pressure to deliver faster insights and streamline operations - the ultimate Boss Fight of managing large Db2 for z/OS environments. Generative AI is your new power-up for development and administration and your secret weapon against complexity. This session will show how to flip on the Auto-Pilot to tune SQL with expert-level precision, master complex schema management, and drive utilities intelligently for object maintenance. We'll walk through real speedruns (use cases) that demonstrate how GenAI simplifies workloads, cuts troubleshooting time, and improves efficiency, giving your team the cheat codes to unlock Db2's full value and achieve the High Score in productivity.
Speakers
avatar for Chris Crone

Chris Crone

Distinguished Engineer, Broadcom
Chris is a Distinguished Engineer for Database Technology and a lead architectfor the Data Management portfolio within the Mainframe Division of BroadcomSoftware Group. He oversees strategy and architecture decisions for theBroadcom database products IDMS and Datacom, as well as for... Read More →
Monday September 28, 2026 3:20pm - 4:20pm BST
Infante
  Track A, 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

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

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

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

Andreas Weininger

Principal Information Architecture Technical Specialist, IBM
Andreas Weininger is part of the Information Architecture team of IBM in Munich. He has more than 20 year of experience with scalable solutions for data intensive solutions focussing especially on the performance aspects. He is a regular speaker at database and data warehousing events... Read More →
Tuesday September 29, 2026 4:30pm - 5:30pm BST
Maria
  Track D, Technical Session
 
Wednesday, September 30
 

10:20am BST

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

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

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

Tony Andrews

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

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

B13 Introduction to SQL-PL
Wednesday September 30, 2026 4:30pm - 5:30pm BST
Arrabida
In this session, we'll go back to basics and look at SQL-PL, Db2's built in server-side application logic. We'll take a look at the code constructs and how to leverage in stored procedures, user defined functions and triggers. We'll also look at more complex scenarios like code for a Data Partitioning Feature (DPF) environment. The majority of this session will be looking at and executing source code.
Speakers
avatar for Les King

Les King

DBA, Db2 technical lead, Les King Learning, Seneca College
Les King is a part-time professor at multiple Ontario Colleges, offering courses in Mathematics, Programming and Data Management. Les has also been an instructor at the University of Toronto in the Mathematics department. Les effectively draws a connection between what the marketplace... Read More →
Wednesday September 30, 2026 4:30pm - 5:30pm BST
Arrabida
  Track B, Technical Session
 
Thursday, October 1
 

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

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

Andreas Weininger

Principal Information Architecture Technical Specialist, IBM
Andreas Weininger is part of the Information Architecture team of IBM in Munich. He has more than 20 year of experience with scalable solutions for data intensive solutions focussing especially on the performance aspects. He is a regular speaker at database and data warehousing events... Read More →
Thursday October 1, 2026 11:30am - 12:30pm BST
Maria
  Track D, Technical Session

2:30pm BST

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

B203 Hands-on Lab: Performing AI Queries with SQL Data Insights Pro
Thursday October 1, 2026 2:30pm - 6:30pm BST
Luis
Experience the new features of SQL Data Insights Pro, including unstructured text support, model training offloading to IDAA, and incremental retraining. SQL Data Insights Pro combines unsupervised deep learning with traditional SQL queries, allowing you to run similarity, dissimilarity, clustering, analogy, and commonality AI queries on your Db2 for z/OS data.
In this hands-on lab, learn how to train models using both structured and unstructured data to gain deeper insights from your enterprise data. With the new option to run model training on IDAA, you gain greater flexibility while saving valuable system resources. You will also learn how incremental retraining can save time and resources when updating models with new data.
With these capabilities, you can uncover hidden relationships across tables and views in your Db2 data, quickly gain actionable insights to address business problems as they arise, and confidently make better business decisions. In this lab, you will see how AI
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.
Thursday October 1, 2026 2:30pm - 6:30pm BST
Luis
  Track B, Hands-On Lab
 

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