IDUG NA 2026

A look at new SQL Extensions delivered in releases leading up to 12.1 along with what is new in 12.1 itself. We will take a dive into how Db2 is being extended with AI capabilities including ability to access external AI models through SQL. Learn how Db2 is being extended with vector store capabilities and integrating with both open data formats and open table formats through data lake table extensions.

The folks at the Db2 Lab provide us with a great tool to monitor Db2. It's free and already installed with Db2. This session will show you how db2mon works and how to use it. Then, we'll discuss how to run it in different ways for different use cases. Next, we'll present a way to run db2mon for historical data gathering and trend analysis. Finally, we'll show examples of the data db2mon provides and what to look for in various performance scenarios.

In this presentation we will examine in detail the backup and recovery options available to DBAs for their Db2 environments. How to tune these utilities will be discussed and results will be reviewed from numerous tests. We will see what is the “art of the possible” from using local files, COS, Storage based copies, etc. … We will take a close look at the new version enhancements and how they can improve your backup and recovery experience.

Many Db2 environments rely on Tivoli System Automation (TSA) to manage High Availability Disaster Recovery (HADR) clusters. While TSA has long provided reliable automation for Db2 failover, modern Linux clustering standards and DevOps practices are increasingly shifting organizations toward Pacemaker-based cluster management and infrastructure automation.
This session presents a real-world migration approach for transitioning Db2 HADR environments from TSA to Pacemaker, while leveraging Ansible automation to standardize cluster deployment, configuration, and operational management.
Attendees will learn how to design a repeatable DevOps-driven framework that automates the provisioning of Pacemaker clusters, integrates Db2 HADR resources, and validates failover behavior across environments. The presentation will demonstrate how Ansible playbooks can be used to automate cluster setup, resource configuration, fencing policies, and operational testing, enabling consistent and scalable deployments.
The session will also highlight common challenges encountered during TSA-to-Pacemaker migrations, including cluster configuration pitfalls, resource dependencies, and operational considerations for maintaining availability during the transition.
By the end of the session, participants will gain practical guidance, automation patterns, and lessons learned for modernizing Db2 high-availability environments using Pacemaker and DevOps practices.

Db2 containerization makes Db2 more flexible, scalable, and cloud-native by running it in containers managed by Kubernetes. As Kubernetes is constantly evolving, so does Db2U, our Db2 Universal Container. Come and learn the great deal of innovative work coming your way, in terms of the next-gen capabilities of Db2U.

Technical details to Db2 LUW usage and optimization of queries
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.This session was presented at IDUG NA 2025 in Atlanta. It was in the Top10 of the user sessions. I will update the material to version 12.1 and preferrably include details regaring AI optimizer

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.This workshop will give you hands-on experience for managing a Db2 HADR with Pacemaker Cluster on AWS, Microsoft Azure, Google Cloud, or IBM Cloud. The session will cover the Cloud-specific implementation of Fencing mechanisms and Virtual IP (VIP) addresses across different cloud platforms. Key topics include: Implementation of Route 53 for DNS-based VIP management, Setup of Disk Fencing, Qdevice (Quorum Device) for enhanced split-brain prevention.