Loading…
Audience: Beginner clear filter
Sunday, September 27
 

9:00am BST

B201 Hands-on Lab: zDBA - Infusing Db2 for z/OS with AI
Sunday September 27, 2026 9:00am - 1:00pm BST
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
Arrabida
 
Monday, September 28
 

10:30am BST

IDUG Db2 for LUW Essentials
Monday September 28, 2026 10:30am - 5:30pm BST

Speakers
avatar for Davor Rodnis

Davor Rodnis

IDUG Db2 for LUW Essentials Instructor
Davor is an expert trainer and consultant with 30+ years’ experience in Db2. He specialized in providing Db2 and other training services for IBM customers in over 25 countries according to global standards. He has taught over 300 courses on IBM software products as an IBM Authorized... Read More →
Monday September 28, 2026 10:30am - 5:30pm BST
Glass 1

10:30am BST

IDUG Db2 for z/OS Essentials
Monday September 28, 2026 10:30am - 5:30pm BST

Speakers
avatar for Dougie Lawson

Dougie Lawson

IDUG Db2 for z/OS Essentials Instructor

Monday September 28, 2026 10:30am - 5:30pm BST
Noble

11:30am BST

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

Michael Kühnel

Professor, HUK-COBURG
Db2 LUW DBA since 2016 in a Data Warehouse environment
Monday September 28, 2026 11:30am - 12:30pm BST
Miragaia
 
Tuesday, September 29
 

10:20am BST

C6 Zero Downtime Dreams: A Newcomer’s Guide to Db2 Resilience
Tuesday September 29, 2026 10:20am - 11:20am BST
High availability and disaster recovery capabilities are essential for safeguarding mission-critical Db2 environments. Yet for many beginners, the variety of available technologies including backup and recovery strategies, clustering solutions, replication tools, and multi-cloud architecture can feel overwhelming. This session provides a clear, approachable introduction to the full Db2 High availability and disaster recovery landscape, based on real-world experiences. We will walk through the fundamentals of Db2 backup and recovery, explain how Db2 HADR works and when it’s the right choice, and demystify clustering frameworks such as Pacemaker and PowerHA. You will also learn where pureScale fits into HA planning, how Q Replication and CDC support active-active or near real-time availability, and how modern cloud and multi-cloud deployment models are reshaping resiliency design. Whether you’re new to Db2 or looking to strengthen your foundational knowledge, this session will give you t
Speakers
avatar for Iqbal Goralwalla

Iqbal Goralwalla

Principal Sales Engineer, Triton Consulting Ltd
An IBM Gold Consultant and an IBM Champion for Data Management, Iqbal Goralwalla has over 20 years of experience in all aspects of relational databases on the LUW platform. Iqbal is also a member of IBM’s Technical Advisory Board. Iqbal is a highly experienced Data Management specialist... Read More →
avatar for Damir Wilder

Damir Wilder

Db2 SME and Data Architect, Triton Consulting Ltd
I am a Senior Consultant at Triton Consulting, a UK based company that specializes in Hybrid Data Management, Digital Transformation and DB2 database and Information Management services for the z/OS and Midrange.
My area of expertise is the Midrange platform (predominantly Linux and AIX, both on-prem and Cloud).I have started working as a DB2 DBA in year 2000 on the DB2 version 5.0 and have working experience from that version up to the latest v12.1.I am a certified DB2 v10/v11.1/v11.5 LUW... Read More →
Tuesday September 29, 2026 10:20am - 11:20am BST
Porto

10:30am BST

IDUG Db2 for LUW Essentials
Tuesday September 29, 2026 10:30am - 5:30pm BST

Speakers
avatar for Davor Rodnis

Davor Rodnis

IDUG Db2 for LUW Essentials Instructor
Davor is an expert trainer and consultant with 30+ years’ experience in Db2. He specialized in providing Db2 and other training services for IBM customers in over 25 countries according to global standards. He has taught over 300 courses on IBM software products as an IBM Authorized... Read More →
Tuesday September 29, 2026 10:30am - 5:30pm BST
Glass 1

10:30am BST

IDUG Db2 for z/OS Essentials
Tuesday September 29, 2026 10:30am - 5:30pm BST

Speakers
avatar for Dougie Lawson

Dougie Lawson

IDUG Db2 for z/OS Essentials Instructor

Tuesday September 29, 2026 10:30am - 5:30pm BST
Noble
 
Wednesday, September 30
 

10:20am BST

A10 Linuxification of Db2 for z/OS - a journey from ISPF and JCL to Shell and Playbooks
Wednesday September 30, 2026 10:20am - 11:20am BST
This session will be about bridging existing legacy programs with "modern"interfaces, such as the Unix shell and Ansible. Next-generation mainframers are typically well-versed in Unix shells and scripting, largely due to Linux's dominance in the server market. But how does this apply to traditional mainframe tools? That is what we want to show you.
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.
avatar for Marketa Muzikova

Marketa Muzikova

Software Architect, Broadcom
Markéta is an experienced software engineer with expertise in mainframe automation, including Ansible and Zowe. Markéta is a recognised expert on Ansible and facilitates the Broadcom Ansible Collection.
Wednesday September 30, 2026 10:20am - 11:20am BST
Infante

10:30am BST

IDUG Db2 for LUW Essentials
Wednesday September 30, 2026 10:30am - 5:30pm BST

Speakers
avatar for Davor Rodnis

Davor Rodnis

IDUG Db2 for LUW Essentials Instructor
Davor is an expert trainer and consultant with 30+ years’ experience in Db2. He specialized in providing Db2 and other training services for IBM customers in over 25 countries according to global standards. He has taught over 300 courses on IBM software products as an IBM Authorized... Read More →
Wednesday September 30, 2026 10:30am - 5:30pm BST
Glass 1

10:30am BST

IDUG Db2 for z/OS Essentials
Wednesday September 30, 2026 10:30am - 5:30pm BST

Speakers
avatar for Dougie Lawson

Dougie Lawson

IDUG Db2 for z/OS Essentials Instructor

Wednesday September 30, 2026 10:30am - 5:30pm BST
Noble

11:30am BST

E11 Exploring Db2 explain facility for the next Gen of Db2 DBAs and using AI to bridge the skills gap.
Wednesday September 30, 2026 11:30am - 12:30pm BST
Poorly written or optimized Db2 SQL queries can use huge amounts of CPU and render applications unusable causing business impact.
This session will cover the different types of access paths the Db2 Optimizes uses to return data for queries and discuss their merits and use cases. We will look at the data written by the DB2 optimizer in the EXPLAIN tables and how we can interpret the data using AI to determine if an SQL is going to be cheap or expensive to run.
The session will cover filter factors and the role of RUNSTATS on access path selection and cover how one can influence the access path.
Speakers
avatar for Phill Baker

Phill Baker

Software Consultant, BMC
A passionate technologist specializing in BMC mainframe solutions. Twenty plus years experience working as a Database engineer across Db2, SQL Server, MySQL and Oracle.  Working on mainframe z/OS, AIX, Linux, UNIX and Windows, supporting large scale data warehouse applications to... Read More →
Wednesday September 30, 2026 11:30am - 12:30pm BST
Luis

4:30pm BST

B13 Introduction to SQL-PL
Wednesday September 30, 2026 4:30pm - 5:30pm BST
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
 
Thursday, October 1
 

9:00am BST

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

Iqbal Goralwalla

Principal Sales Engineer, Triton Consulting Ltd
An IBM Gold Consultant and an IBM Champion for Data Management, Iqbal Goralwalla has over 20 years of experience in all aspects of relational databases on the LUW platform. Iqbal is also a member of IBM’s Technical Advisory Board. Iqbal is a highly experienced Data Management specialist... Read More →
avatar for Damir Wilder

Damir Wilder

Db2 SME and Data Architect, Triton Consulting Ltd
I am a Senior Consultant at Triton Consulting, a UK based company that specializes in Hybrid Data Management, Digital Transformation and DB2 database and Information Management services for the z/OS and Midrange.
My area of expertise is the Midrange platform (predominantly Linux and AIX, both on-prem and Cloud).I have started working as a DB2 DBA in year 2000 on the DB2 version 5.0 and have working experience from that version up to the latest v12.1.I am a certified DB2 v10/v11.1/v11.5 LUW... Read More →
Thursday October 1, 2026 9:00am - 10:00am BST
Maria

9:00am BST

F15 Db2 Load – Strategies to speed up loading very large tables
Thursday October 1, 2026 9:00am - 10:00am BST
With the push for more and more availability replacing the data in very large tables with many indexes can be problematic especially when the business is enforcing small outage windows.
This presentation outlines how we designed a process to replace the data in a 1.6bn row table in the required outage window when the initial load time was nearly 5 times the available window.
Speakers
avatar for Rob Gould

Rob Gould

Database Consultant, Triton Consulting Ltd
Rob is a Consultant at Triton Consulting, a UK based company that specializes in Hybrid Data Management, Digital Transformation and DB2 database and Information Management services for the z/OS and Midrange platforms.
His area of expertise is the Mainframe platform, but he has also worked with Db2 LUW. He started working as a DB2 Systems programmer in 1988 has been active in the Db2 world since then. Rob also worked for IBM as a Systems programmer and then a Technical Sales Specialist. Thro... Read More →
Thursday October 1, 2026 9:00am - 10:00am BST
Miragaia

9:00am BST

IDUG Db2 for LUW Essentials
Thursday October 1, 2026 9:00am - 12:30pm BST

Speakers
avatar for Davor Rodnis

Davor Rodnis

IDUG Db2 for LUW Essentials Instructor
Davor is an expert trainer and consultant with 30+ years’ experience in Db2. He specialized in providing Db2 and other training services for IBM customers in over 25 countries according to global standards. He has taught over 300 courses on IBM software products as an IBM Authorized... Read More →
Thursday October 1, 2026 9:00am - 12:30pm BST
Glass 1

2:30pm BST

B203 Hands-on Lab: Performing AI Queries with SQL Data Insights Pro
Thursday October 1, 2026 2:30pm - 6:30pm BST
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
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.