IDUG NA 2025: Full Schedule

9:00am EDT

C201 | Hands–on SSL/TLS Deployment for Db2 LUW Clients and Servers

Sunday June 8, 2025 9:00am - 12:30pm EDT

This half–day hands–on workshop is designed to provide you with all the details you need to know for a successful SSL/TLS deployment for Db2 LUW and on–going certificate maintenance. Encrypting network communications is essential in today’s security conscious world and is a complex task with many moving parts. That complexity is confirmed by the number of cases Db2 support and development see asking for help configuring TLS. This workshop builds on those years of experience to give you the knowledge you need to set things up correctly and securely. The workshop will start with the very basics of asymmetric cryptography, which form the foundation of certificates and turn the discussion to trust and the role it plays. From there, we will turn to hands on exercises configuring the Db2 server, followed by Db2 clients/drivers allowing encrypted client/server communication. Topics such as certificate creation, keystore management, and hostname validation will be discussed and practiced. The steps required for certificate renewal will be demonstrated. Advanced topics such as TLS with HADR will be discussed, showing how the practiced knowledge of setting up client/server TLS will follow through to HADR. While not necessary to attend the workshop and learn something, the hands on–portions will require you to bring your own laptop and be able to establish an SSH connection to the public IBM Cloud.

Speakers

Greg Stager

Db2 Security Architect, 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.

Sunday June 8, 2025 9:00am - 12:30pm EDT
Spring

Workshop

Audience Beginner
Subject LUW

9:00am EDT

D201 | The HADR with Pacemaker for Cloud Deployments Workshop

Sunday June 8, 2025 9:00am - 12:30pm EDT

Techwood

Db2 databases support the High Availability needs of many customers today. Db2 v11.5.5.0 saw the general availability of High Availability with Pacemaker on the Linux platform, providing a newer, Cloud–ready alternative to the TSA implementation. Newer releases have added support for AWS, Azure, Google Cloud and IBM Cloud environments, and many other refinements. This workshop will give you hands–on experience for managing a Db2 HADR with Pacemaker Cluster on the AWS, Microsoft Azure, Google Cloud or IBM Cloud. The session will cover the Cloud specific Implementation of Fencing and virtual IP Addresses. It will help you understand the information provided by the cluster utilities, across basic operations, diagnostics, and best practices from the IBM Labs This workshop will also demonstrate basic problem scenarios, troubleshooting and collection of essential support data to accelerate problem resolution in emergency cases.

Speakers

Toby Haynes

Senior Software Developer, IBM Canada

With a background in Observational Astronomy at the University of Cambridge, England, Toby joined IBM Canada in 1999 as a software developer in the Db2 Runtime engine. After eight years of development experience, he moved over to the Db2 Performance team to start work on what would... Read More →

Thomas Rech

Senior IT Architect - DB2 SAP Development, IBM

Thomas has been working in the Db2 area since 1996. Starting as a Db2 course instructor, he soon moved to the SAP on Db2 environment in 1997. He joined the SAP/IBM Db2 Development Team, followed by a role as technical sales consultant. He led several lighthouse projects like the first... Read More →

Sunday June 8, 2025 9:00am - 12:30pm EDT
Techwood

Workshop

Audience Intermediate
Subject LUW

1:30pm EDT

C202 | MaaS – Db2 Monitoring as a Service in AWS, Azure, GC and IBM Cloud

Sunday June 8, 2025 1:30pm - 5:00pm EDT

Spring

A cloud native resource without monitoring (or with a very complex monitoring setup) is like driving a car without a dashboard – you wouldn't know if you are speeding or low on fuel! Db2 needs a concise and simplified monitoring solution that gives a bird eye's view on the performance metrics and Db2 diagnostics. We present here a solution that is available in AWS, Azure, Google Cloud and IBM Cloud while running Db2 with a Infrastructure as a Service model.
The speaker will cover her experience of collaboration with all cloud vendors, Db2 development and customers like SAP. The session will share the findings from that reserach and development project and it is based on the cloud native monitoing solutions currently available. The solution consists of a smart combination of Db2 monitoring capabilities, Operating System scheduling and Cloud logging functionality resulting in an out–of–the–box Db2 monitoing solution.
The solution has the following features:

Displays the most important metrics (based on customer data) of a database instance namely, Bufferpool quality, Activities per second, Activity wait time and Logging performance.
Information regarding Db2 Diagnostics by providing the count of increasing errors that can be easily extended for a comprehensive diagnostic analysis.
Whether or not the database is alive.

This solution introduces the Monitoring as a Service infrastructure and ables you to build your own cloud native monitoring solution with a few fingertips.

Speakers

Thomas Rech

Senior IT Architect - DB2 SAP Development, IBM

Sunday June 8, 2025 1:30pm - 5:00pm EDT
Spring

Workshop

Audience All
Subject LUW

1:30pm EDT

F202 | Amazon RDS for Db2 Workshop

Sunday June 8, 2025 1:30pm - 5:00pm EDT

University

This 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

Andrew Hilden

Chief Architect Db2 SaaS, IBM

Andrew Hilden is the Chief Architect of Db2 SaaS. He is involved extensively in the development and architecture of several data-oriented cloud services in IBM. In the past 25 years he has worked in development, architectural and leadership roles in Db2 from SaaS to areas like appliances... Read More →

Javeed Mohammed

Database Solutions Architect, Amazon

Sunday June 8, 2025 1:30pm - 5:00pm EDT
University

Workshop

Audience All
Subject LUW

8:30am EDT

IDUG Db2 for LUW Essentials Course

Monday June 9, 2025 8:30am - 5:00pm EDT

Edgewood

This 3.5-day foundational course introduces the essentials of Db2 12.1 for relational DBAs, covering architecture, installation, configuration, and basic database management. It then builds on these core essentials with topics such as data movement, backup and recovery, and routine maintenance to ensure performance and integrity. Designed for new and transitioning DBAs, the course emphasizes hands-on learning with minimal prerequisites beyond basic SQL and database knowledge.

Note: There is no certification for the foundational course, but students can take a proctored quiz after the class to obtain the badge.

Monday June 9, 2025 8:30am - 5:00pm EDT
Edgewood

IDUG Essentials

Subject LUW

10:20am EDT

B1 | Db2 LUW Spotlight Session

Monday June 9, 2025 10:20am - 11:20am EDT

Embassy D/E

Hear from the lab leadership on recently shipped / announced Db2 content, and our perspective and vision for the future.

Speakers

Satya Krishnaswamy

Director, Hybrid Data Management Development, IBM, IBM

Satya Krishnaswamy is the Director of Product Development for Hybrid Data Management at IBM which includes the Db2 family of products.

Wesley Gyure

Monday June 9, 2025 10:20am - 11:20am EDT
Embassy D/E

Spotlight

Audience All
Subject LUW

11:30am EDT

B2 | Db2 Latest from the Lab

Monday June 9, 2025 11:30am - 12:30pm EDT

Roswell

Both an overview and a deep dive of recently shipped / announced Db2 content, and then a look into what is coming soon.

Speakers

Mike Springgay

Db2 Architect, IBM

Mike Springgay is the Db2 Architect. Prior to that he was responsible for architecting extensions to Db2’s Warehouse capabilities, SQL compatibility features, routine infrastructure and client server connectivity.

Monday June 9, 2025 11:30am - 12:30pm EDT
Roswell

Technical Session, Db2 Features Improvements and Tips LUW

Audience Beginner
Subject LUW

11:30am EDT

C2 | Basics of Shell Scripting for the Db2 DBA

Monday June 9, 2025 11:30am - 12:30pm EDT

Spring

For work I try to stick to a rule: "Never do something three times!". I do it once, the second time I'm annoyed and for the third time I try to automate it.As I'm currently managing around 40 RHEL servers with nearly 700DBs on it, automation, conventions and rules are key.
In this session I want to show the audience general commands and constructs within shell programming. Givng a method at hand how to fast develop shell scripts and oneliners and some tricks to get around some possible pitfalls on the way.

Speakers

Sebastian Zok

Senior Database Administrator, Cancom Managed Services GmbH

Sebastian got a diploma in IT in 2007 and started first in software development. He worked on Db2 performance monitoring and switched to Db2 consultancy shortly after. He is working with Db2 LUW since version 7. Currently Sebastian is working for an IT provider as Senior Db2 DBA administering... Read More →

Monday June 9, 2025 11:30am - 12:30pm EDT
Spring

Technical Session, Database Practices

Audience Beginner
Subject z/OS, LUW

2:00pm EDT

B3 | Introducing the IBM Database AI Assistant for Db2

Monday June 9, 2025 2:00pm - 3:00pm EDT

Roswell

This session will introduce you to the new IBM Database AI assistant, a new AI powered tool designed for DBAs that provides insights and smart recommendations through a natural language chat interface. Leveraging Large Language Models (LLMs) in combination with a wide knowledge base and telemetry from your database fleet, the assistant acts as a copilot that can streamline information retrieval and help you to quickly answer questions and troubleshoot problems on your database systems.

Speakers

David Kalmuk

Distinguished Engineer, Analytic Databases, Data & AI, IBM

David is a distinguished engineer at IBM, working on IBM's analytic database products.

Monday June 9, 2025 2:00pm - 3:00pm EDT
Roswell

Technical Session, Db2 Features Improvements and Tips LUW

Audience All
Subject LUW

2:00pm EDT

E3 | Evolution of Database Infrastructure: Performance & Monitoring Considerations when Migrating Large–Scale COBOL Application in Banking from Db2 z/OS to Db2 LUW

Monday June 9, 2025 2:00pm - 3:00pm EDT

Inman

This presentation examines a complex strategic migration of a mission–critical COBOL banking application from Db2 z/OS hosted on IBM mainframe to Db2 LUW on Power Linux, drawing from a Polish banking institution's transformation initiative serving 12 million customers. We explore our comprehensive approach to database performance monitoring and capacity planning while migrating a 30+ TB database to a distributed architecture. The discussion focuses on practical methodologies for performance testing, benchmarking, and risk mitigation, highlighting key differences between Db2 z/OS and Db2 LUW environments. We will share our experience in addressing platform–specific considerations and architectural adaptations required for successful migration. Through real–world scenarios and lessons learned, attendees will gain actionable insights into our approach for designing monitoring frameworks and implementing effective migration strategies for similar large–scale database modernization projects.

Speakers

Jakub Rosiak

Monday June 9, 2025 2:00pm - 3:00pm EDT
Inman

Technical Session, Performance Monitoring and Troubleshooting

Audience All, Intermediate
Subject z/OS, LUW

2:00pm EDT

F3 | Db2 – Mission Critical High Volume Highly Complex Cross Platform Migration to Cloud – Next Steps

Monday June 9, 2025 2:00pm - 3:00pm EDT

University

This is my preferred presentation for IDUG–2025.This was presented at IBM TechXChange and IDUG – 2024.This is updated presentation with all enhancement for Cross platform migration for AIX to AWS/RDS/Db2.
Description
DB2 – High Volume Highly Complex cross platform migration to Cloud – Next Step– Mission Critical database– Volume more than 125,000 per seconds– From AIX to AWS/RDS/Db2– Feathering HADR, Federation, Multi–partition tables, CDC– Encrypted databases with high volume of transaction logs– Optimized Power system with compression at every level– Specially Project help from AWS beta and POC– AIX to RDS via S3 without Linux/EC2 requirements

Speakers

Nemi Agrawal

CEO & Director, DataStorm Inc

Nemi AgrawalTechnical Program Manager | Speaker | Tech Influencer | IBM Champion (2023-24) With over 30 years of experience spanning global organizations like the Department of Homeland Security/Customs and Border Protection, Citibank, IBM, Deutsche Bank, and Deutsche Telekom... Read More →

Monday June 9, 2025 2:00pm - 3:00pm EDT
University

Technical Session, Cloud Warehouse and Data Lakes

Audience Intermediate
Subject LUW

2:00pm EDT

Badging at IDUG

Monday June 9, 2025 2:00pm - 3:30pm EDT

Fairlie

Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information:

First & Last Name:
Email Address:
Exam Choice:
Day & Time Choice:

Exam choices include:

Db2 11.5 Foundations Exam
Db2 11.5 Administration Exam
Db2 11.5 Advanced Database Resilience Exam
Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
Db2 12.1 Foundations Exam * NEW *
Db2 12.1 Administration Exam * NEW *

IMPORTANT NOTES: No walk-ins. You must book in advance and you will receive a confirmation once you are officially booked. This is a Bring Your Own Device exam. Photo ID will be required at exam time.

Monday June 9, 2025 2:00pm - 3:30pm EDT
Fairlie

Badging & Certification

Subject LUW

3:20pm EDT

B4 | Db2 12.1: Advances in Operational Resiliency for Mission–Critical Workloads

Monday June 9, 2025 3:20pm - 4:20pm EDT

Roswell

Db2 offers a wide range of operational resilient deployment patterns, and for each management features that maintain the database online. With the release 12.1, Db2 continues to make progress in delivering improvements in the operational resilience functionality to ensure your most demanding environments maintain the highest availability that the 24x7 world demands. In this session we will cover the features that allow Db2 to scale resources up or down to meet changing workload demands efficiently. We will also discuss how a Db2 database system can maintain its critical functions and operations in the face of disruptions or challenges.

Speakers

Christian Garcia–Arellano

Francis Wong

Program Director - Db2 Development, IBM

Francis Wong is a technical leader in data management software development. He is the Program Director of Db2 Development. He led the development of several hybrid data management cloud services. He launched watsonx.data cloud service, a fit-for-purpose open data lakehouse service... Read More →

Monday June 9, 2025 3:20pm - 4:20pm EDT
Roswell

Technical Session, Db2 Features Improvements and Tips LUW

Audience All
Subject LUW

3:20pm EDT

E4 | Using db2mon and R for Deep Insights into your Database Activity

Monday June 9, 2025 3:20pm - 4:20pm EDT

Inman

Db2 offers many rich data monitoring sources to collect, but how do you decide what is important or useful to collect? This session looks at regular db2mon data collection with a focus on extracting insights from the data, both from a single db2mon report and also from multiple data collections over time.
This session will cover many performance metrics including
– system basics – activity, utilization– bottleneck checks – waiting on disk, network, locks, etc.– bufferpool activity and effectiveness– insights over time – looking at metrics from multiple reports and charting important trends
R provides a rich and repeatable set of data manipulations that provide a flexible and composable set of tools to dig into and chart the db2mon data. This is supplemented by custom Db2–developed tooling that is now open–sourced to convert multiple db2mon reports into data files grouped by report types for deeper insights on database behaviour.

Speakers

Toby Haynes

Senior Software Developer, IBM Canada

Monday June 9, 2025 3:20pm - 4:20pm EDT
Inman

Technical Session, Performance Monitoring and Troubleshooting

Audience Intermediate
Subject LUW

4:00pm EDT

Badging at IDUG

Monday June 9, 2025 4:00pm - 5:30pm EDT

Fairlie

Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information:

First & Last Name:
Email Address:
Exam Choice:
Day & Time Choice:

Exam choices include:

Db2 11.5 Foundations Exam
Db2 11.5 Administration Exam
Db2 11.5 Advanced Database Resilience Exam
Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
Db2 12.1 Foundations Exam * NEW *
Db2 12.1 Administration Exam * NEW *

Monday June 9, 2025 4:00pm - 5:30pm EDT
Fairlie

Badging & Certification

Subject LUW

4:30pm EDT

B5 | Db2 LUW V12: New Security Features and Changes

Monday June 9, 2025 4:30pm - 5:30pm EDT

Roswell

Db2 LUW V12 has a plethora of changes in the area of security and this session will highlight everything new and changed. This includes features such as enhancements to trusted context, tablespace administration, fenced stored procedure lockdown, and minor authentication improvements. A focus has been made on cleaning up less than secure defaults and features. These have direct impact to many daily operations, be sure to attend to learn about all of these changes.

Speakers

Greg Stager

Db2 Security Architect, IBM

Monday June 9, 2025 4:30pm - 5:30pm EDT
Roswell

Technical Session, Db2 Features Improvements and Tips LUW

Audience All
Subject LUW

4:30pm EDT

F5 | Db2 On–prem to Cloud Transformation Journey

Monday June 9, 2025 4:30pm - 5:30pm EDT

University

This presentation explores the process of moving Db2 databases from on–premises environments to the cloud, focusing on AWS, Azure, and GCP. For AWS, both EC2 and RDS solutions are discussed. This presentation even covers HA and DR solutions on–cloud.

Speakers

Mohankumar Saraswatipura

Senior Consultant - Data and AI, DBA Automation

Mohankumar (Mohan) Saraswatipura works as a Senior Consultant - Data and AI at DBA Automation Corp., focusing on IBM Db2, Linux, UNIX, and Windows, Data Replication (Q Rep, CDC, HVR, Qlik, and Golden Gate) solutions. Prior to his current position, he worked as a Database Solutions... Read More →

Monday June 9, 2025 4:30pm - 5:30pm EDT
University

Technical Session, Cloud Warehouse and Data Lakes

Audience All
Subject LUW

8:30am EDT

IDUG Db2 for LUW Essentials Course

Tuesday June 10, 2025 8:30am - 5:00pm EDT

Edgewood

Tuesday June 10, 2025 8:30am - 5:00pm EDT
Edgewood

IDUG Essentials

Subject LUW

10:20am EDT

C6 | DB2 LUW PureScale – Custom Disaster Recovery Configuration

Tuesday June 10, 2025 10:20am - 11:20am EDT

Spring

IBM provides us number of solution to achieve multisite HA/DR for PureScale clusters. Those include technologies like HADR Replication for PureScale Clusters, Geographically Dispersed PureScale Clusters, GPFS replication for PureScale Clusters, Q Replication for PureScale Clusters.
In the presentation we will describe alternative approach, where replication across 2 sites is provided by Storage Array Layer, which allows us to achieve additional benefits like consistency groups going beyond single GPFS filesystem used by the PureScale, optimized network utilization where Storage Array replication happens on SAN Fiber, additional HA layer where filesystem can be cross mounted across sites which gives additional redundancy layer for storage availability.

We implement solution by deploying Synchronic Storage Replication across 2 sites, where SAN fabric provides us NSD multi path connections from each side. This way on each side we have collection of NSD disks that are local to given side, and also connection to remote NSD disks from DR side. On both sites we install standalone PureScale clusters, independent from each, therefore failure of any of those clusters does not impact other side counterpart. Having 2 clusters we designate one as primary by creating PureScale managed GPFS on top of Storage Array Layer, and on top of that create Database with its' associated paths. Next we use gpfssync capabilities to export primary GPFS filesystem , and next mount the same on DR site. This allows us to mimic primary cluster on DR site, and next attach those synchronized mount points to TSAMP cluster on secondary site. Later on, we just move application connection to DR site, which can handle further ongoing workloads.

Proposed solution is active–passive deployment, when at any given time only one cluster has connection to synchronized storage array. We achieve this by protections on each layer (NSD disks active on one site only, GPFS mounts online on one site only, database cataloging on one site only). This is crucial to ensure only one side has active writes to the cluster, so that we prevent any corruption of the data. In the presentation we provide procedures to setup such deployment, along with failover procedures where we move storage attachment from primary to secondary, and reverse. We also provide testing results where we verify solution, by forcing failover and more failure scenarios while processing application workload.

Speakers

Mateusz Ksiazek

IT Expert, PKO BP

Technical Leader in mainframe modernization project - Cross platform monitoring design & performance analysis(mainframe/distributed) - Application migration to distributed env - Dr architecture for cross platform env - TroubleshootingDB2 system AdministratorDB2 performance monitoring... Read More →

Marcin Baster

Senior Manager, IBM Software Support - Db2, IBM

Tuesday June 10, 2025 10:20am - 11:20am EDT
Spring

Technical Session, Backup Recovery & Data Movement

Audience Beginner, Intermediate
Subject z/OS, LUW

10:20am EDT

F6 | So Your Auditors Really Want to Know What is Happening In a Database

Tuesday June 10, 2025 10:20am - 11:20am EDT

University

In these days of heightened security, it is likely that you will be asked about Db2’s audit facility, db2audit. This tool has the ability to collect a number of types of security information and this presentation will show how to configure and use db2audit. dbaudit can collect massive amounts of data but there are ways to limit the data and those techniques will be shown in the presentation.

Speakers

Paul Turpin

Group Technology Manager, Truist

Paul Turpin manages a database engineering team for a financial services company. He specializes in Db2 for LUW on large systems, along with other DBMS like PostgreSQL, Neo4j and MongoDB. He enjoys exploring new features and functionality in Db2. He has spoken at IDUG North America... Read More →

Tuesday June 10, 2025 10:20am - 11:20am EDT
University

Technical Session, Security Compliance and Governance

Audience Intermediate
Subject LUW

10:30am EDT

Badging at IDUG

Tuesday June 10, 2025 10:30am - 12:00pm EDT

Fairlie

Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information:

First & Last Name:
Email Address:
Exam Choice:
Day & Time Choice:

Exam choices include:

Db2 11.5 Foundations Exam
Db2 11.5 Administration Exam
Db2 11.5 Advanced Database Resilience Exam
Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
Db2 12.1 Foundations Exam * NEW *
Db2 12.1 Administration Exam * NEW *

Tuesday June 10, 2025 10:30am - 12:00pm EDT
Fairlie

Badging & Certification

Subject LUW

11:30am EDT

C7 | Db2 Advanced Log Space Management – Unleashed

Tuesday June 10, 2025 11:30am - 12:30pm EDT

Spring

Trying to figure out the ins and outs of Db2 Log Space Management? Spent too much time trying to figure out what settings are best for your environment? With the introduction of Advanced Log Space Management the time has come to unleash it's potential. Fully supported, the journey has begun in making log space management more autonomic. This presentation will introduce you to some of the concepts and principles behind it all. We will do a deep dive into the technology and transformation behind making log space management more hands off, which in the end will make life simple for you and your organization.

Speakers

Michael Roecken

Software Developer, IBM Canada

Michael Roecken is a senior software developer with Db2 for Linux, UNIX, and Windows platforms at the IBM Toronto Lab. Michael has worked since 2000 designing, implementing and supporting various features and capabilities in the areas of: backup/restore, crash/rollforward recovery... Read More →

Tuesday June 10, 2025 11:30am - 12:30pm EDT
Spring

Technical Session, Backup Recovery & Data Movement

Audience Beginner, All
Subject z/OS, LUW

11:30am EDT

E7 | Explain EXPLAIN

Tuesday June 10, 2025 11:30am - 12:30pm EDT

Inman

There are many sessions about the EXPLAIN facility in Db2 LUW, but they all lack the concise statements to find the right SQL queries, set everything up, do the EXPLAIN and draw the right conclusions by examples and working statements to copy–and–paste.
This is a back–to–basics session, enhanced with experiences from real situations and best practices.
The material was used for internal training of colleagues.

Speakers

Roland Schock

Principal, tasdevil Consulting

Roland is installing, using and tuning Db2 on distributed since 1993 or Version 2.1 for OS/2. After working for 25+ years for ARS Computer und Consulting GmbH as a Db2 expert he is now an independent consultant.His expertise and engagement for the community allowed him to become IBM... Read More →

Tuesday June 10, 2025 11:30am - 12:30pm EDT
Inman

Technical Session, Db2 Solutions Utilities and Tools

Audience All
Subject z/OS, LUW

2:00pm EDT

B8 | IBM Db2 for AI: Building AI Systems with Db2

Tuesday June 10, 2025 2:00pm - 3:00pm EDT

Roswell

Relational databases serve as the primary data source for enterprise AI projects. Traditionally, when an AI project requires data from a relational database, engineers duplicate the data onto a separate system for model development and inference. However, this duplication process presents various challenges, including network latency, complex data governance, and the need for multiple APIs. These challenges often impede the successful implementation of AI models in production for many enterprise projects. To address these obstacles, IBM Db2 offers in–database AI capabilities and external tools. With Db2, ML practitioners can create and deploy AI models directly within their databases, significantly simplifying the complexities of AI pipelines. By leveraging in–db AI features, enterprises can safeguard sensitive data, expedite inferencing processes, and seamlessly integrate AI models with downstream business applications. In this talk, I will present the AI capabilities and tools provided by Db2. I will showcase how these capabilities can be effectively utilized in upcoming AI projects, demonstrating their potential to transform enterprise AI implementations.

Speakers

Shaikh Quader

AI Architect, IBM Db2, IBM

Shaikh Quader is the AI architect of IBM Db2. He develops database features to improve database operations with ML and help users deploy ML models in the database. Shaikh manages research collaboration between IBM and a few Canadian universities. He and his team developed 5 Python... Read More →

Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Roswell

Technical Session, AI Data Mining and ML

Audience All
Subject LUW

2:00pm EDT

F8 | Db2 Audit and Audit Exceptions with SAP

Tuesday June 10, 2025 2:00pm - 3:00pm EDT

University

Prior to Db2 12.1, with Db2 audit enabled for the database using the db2audit facility, an unsustainably large amount of audit data is generated which has an impact on the general database performance, I/O, and space. This is especially true for the “execute” category of Db2 auditing. Almost all the data is generated by the SAP application and the SAP database connect user. Unfortunately, the db2audit facility provides very little in terms of application context that comes from the SAP system such as SAP logon user, reports, and so on.
On the other hand, there are SAP–level auditing functions and auditing within the SAP system which can provide application–related details.
However, auditing on SAP application level has its limits: You cannot audit statements that execute directly against the database and that come from outside the local ABAP stack.With Db2 12.1, the Db2 audit facility has been enhanced to overcome the above–mentioned limitation. Generally, the database data should only be accessed in a trusted way from the SAP application through the SAP database connect user, and all other connections to the database should be audited.
As of Db2 12.1, you can exclude auditing for connections originating from the local SAP application by the SAP connect user. This reduces the amount of audit data generated by the Db2 audit facility to something more manageable.

Speakers

Donald Vorhees

Thomas Rech

Senior IT Architect - DB2 SAP Development, IBM

Tuesday June 10, 2025 2:00pm - 3:00pm EDT
University

Technical Session, Security Compliance and Governance

Audience All
Subject LUW

2:00pm EDT

Badging at IDUG

Tuesday June 10, 2025 2:00pm - 3:30pm EDT

Fairlie

Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information:

First & Last Name:
Email Address:
Exam Choice:
Day & Time Choice:

Exam choices include:

Db2 11.5 Foundations Exam
Db2 11.5 Administration Exam
Db2 11.5 Advanced Database Resilience Exam
Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
Db2 12.1 Foundations Exam * NEW *
Db2 12.1 Administration Exam * NEW *

Tuesday June 10, 2025 2:00pm - 3:30pm EDT
Fairlie

Badging & Certification

Subject LUW

3:20pm EDT

PSP1 | Db2 Strategy & Business Update

Tuesday June 10, 2025 3:20pm - 4:20pm EDT

Piedmont

Join the product management leadership to get an update on the Db2 business and the overall investment strategy we have in place for Db2 as we now deliver our first big new version in 5 years with Db2 12.1

Speakers

Miran Badzak

Program Director, Databases, IBM

Miran Badzak is the Program Director running the IBM Db2, Db2 Warehouse and Informix portfolio of businesses. His mission is simple: establish and maintain IBM’s dominance in the databases market. Miran has held various roles since joining IBM in 2007, launching several cloud services... Read More →

Tuesday June 10, 2025 3:20pm - 4:20pm EDT
Piedmont

Partner-Sponsored Presentation

Audience All
Subject LUW

4:00pm EDT

Badging at IDUG

Tuesday June 10, 2025 4:00pm - 5:30pm EDT

Fairlie

Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information:

First & Last Name:
Email Address:
Exam Choice:
Day & Time Choice:

Exam choices include:

Db2 11.5 Foundations Exam
Db2 11.5 Administration Exam
Db2 11.5 Advanced Database Resilience Exam
Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
Db2 12.1 Foundations Exam * NEW *
Db2 12.1 Administration Exam * NEW *

Tuesday June 10, 2025 4:00pm - 5:30pm EDT
Fairlie

Badging & Certification

Subject LUW

4:30pm EDT

C9 | HADR – How and Where to Start

Tuesday June 10, 2025 4:30pm - 5:30pm EDT

Spring

This session is meant to be a HADR beginners session (101. back to basics, however you want to call it). Showing what HADR is, how it works in general and how you get it started. Additionally I'll explain the most common configuration parameters, their purpose and possible trip wires on the way to a running HA cluster.
This session will NOT cover any cluster autmation like TSA or Pacemaker.

Speakers

Sebastian Zok

Senior Database Administrator, Cancom Managed Services GmbH

Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Spring

Technical Session, Backup Recovery & Data Movement

Audience Beginner
Subject z/OS, LUW

4:30pm EDT

E9 | Db2 Automatic Statistics Deep Dive

Tuesday June 10, 2025 4:30pm - 5:30pm EDT

Inman

Accurate catalog statistics are the lifeblood of the Db2 query optimizer. Db2 has had automatics statistics support since version 8.2 and real–time statistics were introduced in version 9.5. Automatic statistics collection is enabled by default for new databases and is the recommend best practice. So if you are still hesitant to use them, attend this session to gain a deeper understanding of how they work and why you can trust them to simplify your DB administration and improve overall query performance. In addition to providing details on the automatic statistics architecture, this presentation will provide details on ways to monitor and control automatic statistics collection so that it works well for any type of Db2 system.

Speakers

John Hornibrook

Senior Technical Staff Member, IBM

John is a Senior Technical Staff Member responsible for relational database query optimization on IBM's distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator... Read More →

Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Inman

Technical Session, Db2 Solutions Utilities and Tools

Audience All, Beginner
Subject z/OS, LUW

8:30am EDT

IDUG Db2 for LUW Essentials Course

Wednesday June 11, 2025 8:30am - 5:00pm EDT

Edgewood

Wednesday June 11, 2025 8:30am - 5:00pm EDT
Edgewood

IDUG Essentials

Subject LUW

10:20am EDT

B10 | Db2 pureScale v12.1 on Azure

Wednesday June 11, 2025 10:20am - 11:20am EDT

Roswell

Db2 pureScale with Pacemaker on Azure is an exciting new chapter for Db2 pureScale on Cloud platforms! The Microsoft Azure platform has both TCP/IP and RDMA private network capabilities, allowing more scale–out and scale–up opportunities for the most demanding customer workloads.
This session– walks through the deployment of a Db2 pureScale cluster on the Azure platform– examines the performance for scale up and scale out– compares the TCP/IP and RDMA platforms for cost and performance– discusses the current capabilities and some of the next areas under development
This work builds on the existing Db2 pureScale on AWS knowledge and the session will provide comparisons between the two Cloud offerings

Speakers

Christian Garcia–Arellano

Andrew Hilden

Chief Architect Db2 SaaS, IBM

Wednesday June 11, 2025 10:20am - 11:20am EDT
Roswell

Technical Session, Db2 Features Improvements and Tips LUW

Audience Intermediate
Subject LUW

10:20am EDT

C10 | Automatic Fast DB Size Reduction, NO DELETE, NO REORG, NO System Down

Wednesday June 11, 2025 10:20am - 11:20am EDT

Spring

Databases keep growing. Many applications do not need the older data at certain age, which could vary from a few days to a few years. Reducing the DB size can not only save storage, but also the backup/restore time, and more importantly improves the database performance, in most cases. But, DELETE/REORG has always been a nightmare to DBAs, specially on large databases. This presentation demonstrates a working system which purges the older data from DB2 databases, FAST (in seconds/minutes), with NO System down, NO DELETE/REORG involvement, which is pretty much independent of the database size. The system also provides the option of old–data–archive before purging.

Speakers

Farid Hosseini

Tech Lead Database Engineer, Freddie Mac

Farid Hosseini is a former IBMer at DB2 Lab in late 90s and early 2000s, working as a DB2 consultant for decades with multiple mission critical organizations, resolved tough issues and currently working at Freddie Mac as a Tech lead Database Engineer.

Wednesday June 11, 2025 10:20am - 11:20am EDT
Spring

Technical Session, Operations & Automation

Audience Advanced
Subject LUW

10:20am EDT

F10 | Experiences with BLU in a Banking Environment

Wednesday June 11, 2025 10:20am - 11:20am EDT

University

The increased regulatory requirements following the banking crisis in 2007 required Finanz Informatik (the IT service provider of the Sparkassen–Finanzgruppe which contains all 353 German savings banks) to make some changes to its data warehouses:In addition to being able to generate reports for any point in time in the past, it was also necessary to support the requirement for ad–hoc reports. Finanz Informatik decided to address these challenges by using Db2 on AIX with BLU Acceleration and bitemporal tables.This presentation will discuss the experiences and lessons learned which Finanz Informatik gained during this project with these technologies.

Speakers

Klaus Zentarra

Datamanager, Finanz Informatik GmbH & Co. KG

Klaus Zentarra worked after studying mathematics in a market research institute. He has been working at Finanz Informatik GmbH & Co KG in Münster in the data management department for more than 25 years. He specializes in database management systems and metadata reposititories.

Wednesday June 11, 2025 10:20am - 11:20am EDT
University

Technical Session, Cloud Warehouse and Data Lakes

Audience All
Subject z/OS, LUW

10:30am EDT

Badging at IDUG

Wednesday June 11, 2025 10:30am - 12:00pm EDT

Fairlie

Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information:

First & Last Name:
Email Address:
Exam Choice:
Day & Time Choice:

Exam choices include:

Db2 11.5 Foundations Exam
Db2 11.5 Administration Exam
Db2 11.5 Advanced Database Resilience Exam
Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
Db2 12.1 Foundations Exam * NEW *
Db2 12.1 Administration Exam * NEW *

Wednesday June 11, 2025 10:30am - 12:00pm EDT
Fairlie

Badging & Certification

Subject LUW

11:30am EDT

B11 | Db2 Expert Panel – LUW

Wednesday June 11, 2025 11:30am - 12:30pm EDT

Embassy B/C

Wednesday June 11, 2025 11:30am - 12:30pm EDT
Embassy B/C

Expert Panel

Audience All
Subject LUW

2:00pm EDT

B12 | Everyday DB2 Insights: Lessons from the Trenches

Wednesday June 11, 2025 2:00pm - 3:00pm EDT

Roswell

We will share about 10 items/issues we ecncountered in past few years regarding availablity, performance we learned from our day to day work.
These topics including:
– Julies' Scenario
– locks
– SQL execution time
– quick gain with manipulating statistics
– HADR and infinite logging
– Play with rid
– impact of AIC
– performance impact with password check daemon , etc.

Speakers

Kevin Hong

Senior Principal Database Architect, worldPay

Kevin has been working on IBM Db2 for 30 years. He received his first Db2 Admin certification back in 1995 and holds Db2 admin certifcation for db2 11 for both LUW and Z/OS. Kevin has very deep knowledge and skills for mission critical , high availability, very large multi-hundreds... Read More →

Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Roswell

Technical Session, Db2 Features Improvements and Tips LUW

Audience All
Subject LUW

2:00pm EDT

D12 | Db2 12.1 – Ready for the Deployments and Workloads of the Future

Wednesday June 11, 2025 2:00pm - 3:00pm EDT

Techwood

In this session we will walk through the many investments Db2 has made to ensure Db2 is ready for modern workloads and deployments. Modern workloads includes capabilities such as mixed workloads, multi–model capabilities, NoSQL capabilities, enabling columar to handle all types of analytic workloads, AI/ML capabilities and more. Modern deployments includes our SaaS capabilities, containerization investments, capabilities to integrate Db2 12.1 into a Lakehouse environment to be ready for AI projects and deployment options and more. This is a good session for all Db2 users who are working to take modernization steps in their environments.

Speakers

Les King

Principal, Learning Content Development, IBM

Les King has impacted the vision for IBM’s Hybrid Data Management strategies, which includes Big Data, Analytics, Database and Cloud Data Services by acting as a trusted advisor both to clients and within IBM. This role is now inclusive of how the world of AI and Quantum computing... Read More →

Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Techwood

Technical Session, Database Practices

Audience All
Subject LUW

2:00pm EDT

F12 | V12 Db2 SQL Extensions: Tenant, Vectors, Lakehouse and More

Wednesday June 11, 2025 2:00pm - 3:00pm EDT

University

A look at the new SQL capabilites added to Db2 v12 as well as a look back at some of the lesser known additions in 11.1 and 11.5 mod packs. A deep dive into new namespace isolation capabilities provided via the TENANT concept. A peek into the Vector store extensions coming to Db2 and a look at how Db2 can integrate into a lakehouse strategy.

Speakers

Mike Springgay

Db2 Architect, IBM

Wednesday June 11, 2025 2:00pm - 3:00pm EDT
University

Technical Session, Cloud Warehouse and Data Lakes

Audience Intermediate
Subject LUW

2:00pm EDT

Badging at IDUG

Wednesday June 11, 2025 2:00pm - 3:30pm EDT

Fairlie

Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information:

First & Last Name:
Email Address:
Exam Choice:
Day & Time Choice:

Exam choices include:

Db2 11.5 Foundations Exam
Db2 11.5 Administration Exam
Db2 11.5 Advanced Database Resilience Exam
Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
Db2 12.1 Foundations Exam * NEW *
Db2 12.1 Administration Exam * NEW *

Wednesday June 11, 2025 2:00pm - 3:30pm EDT
Fairlie

Badging & Certification

Subject LUW

4:00pm EDT

Badging at IDUG

Wednesday June 11, 2025 4:00pm - 5:30pm EDT

Fairlie

Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information:

First & Last Name:
Email Address:
Exam Choice:
Day & Time Choice:

Exam choices include:

Db2 11.5 Foundations Exam
Db2 11.5 Administration Exam
Db2 11.5 Advanced Database Resilience Exam
Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
Db2 12.1 Foundations Exam * NEW *
Db2 12.1 Administration Exam * NEW *

Wednesday June 11, 2025 4:00pm - 5:30pm EDT
Fairlie

Badging & Certification

Subject LUW

4:30pm EDT

B13 | Real Life Access Plan Tuning – 2025 Edition

Wednesday June 11, 2025 4:30pm - 5:30pm EDT

Roswell

Optimal access plans are critical for query performance, and it is the Db2 optimizer's job to choose the best one. The optimizer is very sophisticated and considers many factors while costing an access plan, but sometimes it makes mistakes, and you need to fix it quickly. This session will show you how to apply access plan tuning techniques based on queries from real Db2 customer systems. This 2025 edition of the session will cover brand new examples compared to the 2024 edition. A variety of query types will be covered, including OLTP and analytics, running on single or multiple data base partitions. You will also learn how to use the explain facility to understand how access plans work. Attend this session to learn some techniques to address a variety of access plan problems and to gain some insight into query optimization.

Speakers

John Hornibrook

Senior Technical Staff Member, IBM

Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Roswell

Technical Session, Db2 Features Improvements and Tips LUW

Audience Intermediate
Subject LUW

4:30pm EDT

C13 | Automated Db2 Restores with Ansible Playbooks

Wednesday June 11, 2025 4:30pm - 5:30pm EDT

Spring

Learn how to use ansible playbooks to backup, restore Db2 databases locally or cross–node and automate all post–restore checks and validations.

Speakers

Mohan Saraswatipura

Aish Khare

Infra Admin Engineer, Pru

Aish is the member of the CPC and IBM Champion.

Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Spring

Technical Session, Operations & Automation

Audience Intermediate
Subject LUW

4:30pm EDT

D13 | DB2 Always on Architecture

Wednesday June 11, 2025 4:30pm - 5:30pm EDT

Techwood

In this presentation we will discuss what is required to build an "always on" architecture. This is not limited to Db2 LUW, but rather spans the entire software and hardware stack. Systems are only as reliable as thier weakest point, so how to we work around this limitation? Technology is the easiest part of an Always On architecture, so what makes it so difficult to implement? There are many aspects that need to examined such as:
Can the "CAP" theorem be disproved? Stop by this presentation and find out for yourself.

Speakers

Dale McInnis

Principal Data Technical Specialiust, IBM

Dale McInnis is a Principal Data & AI Technical Specialist from the IBM Toronto Canada Lab. He has a B.Sc.(CS) from the University of New Brunswick and a Masters of Engineering(M.Eng) from the University of Toronto and is currently pursuing his PhD in computer science. Dale joined... Read More →

Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Techwood

Technical Session, Database Practices

Audience All
Subject LUW

4:30pm EDT

E13 | Tuning SQL Stored Procedures (LUW Edition)

Wednesday June 11, 2025 4:30pm - 5:30pm EDT

Inman

(IDUG EMEA 2024 BEST USER SPEAKER)
SQL stored procedures are a very common method of delivering Db2 functionality to applications. But when they need performance tuning how do you achieve this. In this presentation we will explore the components behind SQL stored procedures and how to tune the individual elements.

Speakers

Philip Nelson

Senior Database Software Engineer, Lloyds Banking Group / ScotDB Limited

Philip Nelson has worked with Db2 for z/OS since 1989 and with Db2 (LUW) since the beginning. He is an IBM Champion and a frequent presenter at IDUG and other conferences. He particularly focuses on exploring Db2 with new technologies and improving the application development... Read More →

Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Inman

Technical Session, SQL App Dev and Modernization

Audience All
Subject z/OS, LUW

4:30pm EDT

F13 | Getting the Most out of Amazon RDS for Db2

Wednesday June 11, 2025 4:30pm - 5:30pm EDT

University

Amazon RDS for Db2 provides a managed Database on AWS. While this makes the solution really easy to get started with, there is a lot of things under the covers that can help you better use the system. This session will go over some of the technical details under the covers of RDS for Db2 and also provide a series of Tips and Tricks when using RDS. It will go over some money saving strategies you can use as well as give an introduction on how you can migrate workloads to Amazon RDS for Db2.

Speakers

Andrew Hilden

Chief Architect Db2 SaaS, IBM

Wednesday June 11, 2025 4:30pm - 5:30pm EDT
University

Technical Session, Cloud Warehouse and Data Lakes

Audience All
Subject LUW

8:30am EDT

IDUG Db2 for LUW Essentials Course

Thursday June 12, 2025 8:30am - 12:00pm EDT

Edgewood

Thursday June 12, 2025 8:30am - 12:00pm EDT
Edgewood

IDUG Essentials

Subject LUW

9:00am EDT

C14 | Db2 SaaS Modernization on Azure and BYOC

Thursday June 12, 2025 9:00am - 10:00am EDT

Spring

If you are interested in Db2 Managed Services on the Cloud this is a great session to attend to get the very latest information. This session will review some of the recent updates to our Db2 managed services and in particular it will dive deeper into our upcoming managed Db2 cloud services on Azure. It will go over features, but also review the technical architecture behind a new SaaS deployment model which allows you to get the benefits of a managed service while hosting the infrastructure in your own cloud account.

Speakers

Andrew Hilden

Chief Architect Db2 SaaS, IBM

Thursday June 12, 2025 9:00am - 10:00am EDT
Spring

Technical Session, Operations & Automation

Audience All
Subject LUW

9:00am EDT

D14 | DB2 Universal Translator between z/OS and LUW

Thursday June 12, 2025 9:00am - 10:00am EDT

Techwood

The intent of this presentation is to allow DBAs with either Db2 z/OS or Db2 LUW skills apply thier knowledge to the other Db2 platform. There is a lot of commonality between these versions of Db2, however there are some huge differences. Deployment models, differences in functionality and how each is structured will be explained in detail.

Speakers

Dale McInnis

Principal Data Technical Specialiust, IBM

Jerome Gilbert

IBM

Thursday June 12, 2025 9:00am - 10:00am EDT
Techwood

Technical Session, AI Data Mining and ML

Audience All
Subject LUW

10:10am EDT

A15 | Unlocking Recovery – The Key to Solving Everyday Problems

Thursday June 12, 2025 10:10am - 11:10am EDT

Piedmont

Thinking about your availability and recovery strategy shouldn't give you sleepless nights. When issues do come up, you want to make sure you have the tools needed to solve problems and ensure you get the most out of your investment in Db2. This presentation will give you some context and insight into the top questions we see from our customers the most in the areas of backup, restore, crash recovery, locking, logging, transaction management and high availability and disaster recovery. The questions and answers discussed here could save you when an unexpected outage arises and/or better prepare you to avoid an outage in the future.

Speakers

Michael Roecken

Software Developer, IBM Canada

Thursday June 12, 2025 10:10am - 11:10am EDT
Piedmont

Technical Session, Backup Recovery & Data Movement

Audience Beginner
Subject LUW

10:10am EDT

D15 | Vector Support in IBM Db2: Empowering the Development of Modern LLM Applications

Thursday June 12, 2025 10:10am - 11:10am EDT

Techwood

Large language models (LLMs) have revolutionized AI by enabling a new category of applications called language apps. Enterprises have widely started using these apps for various purposes such as chatbots, document summarization, question–answering, and information retrieval. This has sparked renewed interest in AI in recent years. A crucial aspect of language apps is the generation of vector embeddings using language models. This process converts unstructured content, like PDFs, into AI–readable representations. These embeddings are used for vector similarity search, which offers more precise semantic search compared to traditional methods. However, vectors have high dimensionality, so they need cost–effective and secure storage, as well as efficient search methods. Db2 is introducing its first phase of vector support, which includes in–database vector storage, vector similarity search, and various vector operations. In this presentation, the Speaker will discuss Db2’s upcoming vector support features and how they can be utilized to develop modern LLM applications with Db2.

Speakers

Shaikh Quader

AI Architect, IBM Db2, IBM

Mike Springgay

Db2 Architect, IBM

Thursday June 12, 2025 10:10am - 11:10am EDT
Techwood

Technical Session, AI Data Mining and ML

Audience All
Subject LUW

10:30am EDT

Badging at IDUG

Thursday June 12, 2025 10:30am - 12:00pm EDT

Fairlie

Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information:

First & Last Name:
Email Address:
Exam Choice:
Day & Time Choice:

Exam choices include:

Db2 11.5 Foundations Exam
Db2 11.5 Administration Exam
Db2 11.5 Advanced Database Resilience Exam
Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
Db2 12.1 Foundations Exam * NEW *
Db2 12.1 Administration Exam * NEW *

Thursday June 12, 2025 10:30am - 12:00pm EDT
Fairlie

Badging & Certification

Subject LUW

11:20am EDT

B16 | Digging into HADR Performance on AWS

Thursday June 12, 2025 11:20am - 12:20pm EDT

Roswell

Db2 HADR is a widely deployed Highly–Available configuration, providing excellent reliability and capacity, with Reads–on–Standby and multiple auxillaries. This session takes a look at the performance of HADR solutions, including

how to successfully configure and monitor HADR operation
best practices and troubleshooting
Configuring and using virtual IP
examining performance data from AWS HADR pairs for different sync modes

Speakers

Toby Haynes

Senior Software Developer, IBM Canada

Thursday June 12, 2025 11:20am - 12:20pm EDT
Roswell

Technical Session, Database Practices

Audience Intermediate
Subject LUW

11:20am EDT

F16 | Advanced Performance Diagnostics for SQL

Thursday June 12, 2025 11:20am - 12:20pm EDT

University

The Db2 family of products including Db2, Db2 Warehouse, and BigSQL 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

David Kalmuk

Distinguished Engineer, Analytic Databases, Data & AI, IBM

David is a distinguished engineer at IBM, working on IBM's analytic database products.

Thursday June 12, 2025 11:20am - 12:20pm EDT
University

Technical Session, Performance Monitoring and Troubleshooting

Audience All
Subject z/OS, LUW

1:00pm EDT

A203 | Db2 – Console and AI Assistant Hands–on Lab

Thursday June 12, 2025 1:00pm - 4:30pm EDT

Piedmont

This hands–on lab introduces participants to a new AI–powered console designed to simplify and enhance Db2 database management. Through guided exercises, participants will learn how to use the console's features to monitor database performance, troubleshoot common issues, and apply optimization recommendations.
Key tasks will include setting up and customizing dashboards, diagnosing performance bottlenecks using real–time monitoring tools, and leveraging AI–driven recommendations for query tuning and resource management. Participants will also explore natural language interactions for querying data and step–by–step troubleshooting.
This lab is designed for database administrators and IT professionals who want practical experience using an intelligent, streamlined tool for managing Db2 environments. By the end of the session, attendees will have a better understanding of how to integrate these capabilities into their day–to–day workflows to improve efficiency and system reliability.

Speakers

Sahej Thapar

Product Manager, IBM

Sahej is an experienced product manager on the Db2 team. He has contributed to all facets of the Db2 portfolio including go-to-market strategy, customer migrations and user experience initiatives for Db2 SaaS as well as Db2 on Prem.

Aniruddha Joshi

Product Manager, IBM

Ani is a product manager at IBM, working on AI products for IBM's data management portfolio.

Thursday June 12, 2025 1:00pm - 4:30pm EDT
Piedmont

Hands–On Lab

Audience All
Subject LUW

1:00pm EDT

B203 | Hands–On: Building AI Systems with IBM Db2

Thursday June 12, 2025 1:00pm - 4:30pm EDT

Roswell

IBM Db2 offers a wide range of AI features, both built–in and external tools, for creating AI systems and solutions. These include over 200 built–in AI stored procedures and tools that work seamlessly with open–source AI ecosystems. In this workshop, participants will explore Db2’s AI support and use a selection of these features to implement practical AI models. The workshop consists of two parts. In the first module, participants will learn how to develop a supervised AI model using Db2’s built–in AI stored procedures. The entire model development and usage will be done using SQL within the database. In the second module, participants will learn how to create a Python model using popular Python packages outside of the database, and then deploy that model back into a Db2 database. By the end of the workshop, participants will have gained fundamental skills and hands–on experience in utilizing these AI capabilities. They will be able to apply these skills to their future AI projects. This workshop is designed to be beginner–friendly and does not require participants to have extensive knowledge in AI. Basic SQL skills and some Python programming skills are sufficient for attending and benefiting from this workshop.

Speakers

Shaikh Quader

AI Architect, IBM Db2, IBM

Thursday June 12, 2025 1:00pm - 4:30pm EDT
Roswell

Hands–On Lab

Audience All
Subject LUW

1:00pm EDT

F203 | The Db2 First Responder Workshop

Thursday June 12, 2025 1:00pm - 4:30pm EDT

University

The Db2 community constantly welcomes new database administrators or application developers that access Db2. One of the reasons – Db2 is known as a robust and reliable database management system and a perfect match for private and public cloud environments.
However, sometimes you might face database related issues. The session will cover the first steps in the process of problem determination and problem source identification (PD/PSI). The session gives hands–on examples and practical examples for the strategy and process to encircle and find the problem by asking the right questions and will share best practices for the first occurrence data capture (FODC) tools available for the DBA.

Speakers

Thomas Rech

Senior IT Architect - DB2 SAP Development, IBM

Zahidul Khan

Technical Support Professional, IBM Canada

Zahidul Khan has been working at IBM Toronto Software Lab as software developer since 2000. He started working as DB2 Support Analyst and assisting customers with problem analysis and troubleshooting in all areas of DB2 LUW. For the last 14 years he is working in SAP DB2 Integration... Read More →

Thursday June 12, 2025 1:00pm - 4:30pm EDT
University

Workshop

Audience Beginner
Subject LUW