IDUG NA 2026

Discover how AI coding assistants transform DB2 development. This live demonstration showcases Bob, an AI-powered tool that automates schema design, generates optimized SQL queries, debugs complex issues, and tunes performance—all through natural language. See real-time examples of migration planning, query optimization, and troubleshooting that reduce development time by 60%. Learn practical integration strategies for your DB2 workflows.

This session should be considered because it addresses a high-value challenge for Db2 customers: performing a version upgrade with little to no application outage while preserving a reliable backout path. Based on real production experience, it covers failed upgrade scenarios, post-upgrade risk, and the operational realities of switching active workloads across versions and hardware. Rather than staying conceptual, it presents a practical, repeatable approach using Q Replication and Automatic Client Reroute (ACR), along with lessons learned on synchronization, clustered cutover behavior, and risk reduction. Attendees will leave with actionable ideas they can apply in their own environments.
This session presents a practical approach for performing a no-outage Db2 version upgrade using Q Replication and Automatic Client Reroute (ACR). It explains the drivers behind the solution, including online upgrade capabilities in competing platforms, prior failed upgrade attempts, and the need for a reliable backout strategy. The session then walks through replication setup, synchronization of an active source to the target, online cutover steps, and operational challenges in clustered environments. Attendees will learn how to move from an older Db2 version to a newer one with minimal disruption and lower upgrade risk.

Most IT experts know the catchphrase “Never change a running system” very well, especially once you experience that a small change can have a significant impact. Anyway, “The only constant is change” is very true as well. Even if we don’t touch an application for enhancements, we’ll face security updates, software updates, hardware updates, configuration changes and data growth.
Before moving to a new machine, applying (Db2) APARs, changing schema, or SQL, it’s common to test in a sand-box, or development system – very good, but here come the challenges:
1st There are quite a few regulations that affect reliable testing of changes and they all have one in common – DON’T USE PRODUCTION DATA!!!
2nd Without real data, or with data masked and sanitized, we’ll very likely see different results than running one and the same query in production.
This session explains how you can reliably, and resource-friendly, simulate your entire production environment, WITHOUT production data and even on a different machine.
We’ll cover prescreening changes in the following areas:

environment changes, like upgrading to a new machine, or adding more resources
application changes, like SQL queries and schema
data changes, like amount and distribution

The capabilities introduce a whole new world of "what if" opportunities and especially protect you from testing that doesn’t focus on what counts: the resulting performance in your production environment.

This session explores the latest advancements in Db2 LUW designed to ensure continuous reliability, high availability, and disaster recovery for enterprise databases. Attendees will gain insight into new features introduced since Db2 v12.1, including integrated automated HA solutions with Pacemaker, online upgrades and maintenance with minimal disruption, and seamless backup and recovery enhancements. The presentation covers the architecture and operational principles of Db2 pureScale, demonstrating how it delivers near-linear scalability, robust transactional integrity, and rapid failover across cloud and on-prem environments. Real-world testing scenarios and enterprise-grade validation processes are highlighted to showcase how Db2 achieves platinum-level resiliency. Whether you manage mission-critical workloads or architect resilient database solutions, this session provides actionable strategies and technical guidance to maximize uptime, streamline maintenance, and future-proof your Db2 deployments

Efficient data extraction is critical for analytics, migrations, and modern application integration. Optim High Performance Unload (HPU) provides a powerful, flexible, and lightning-fast way to unload Db2 data without impacting production workloads. This session will explore how HPU can be used for faster unloading and migrating data by using direct access methods to deliver unmatched performance compared to traditional unload utilities. In addition, we will demonstrate how HPU can recover data directly from backup images in the event of table loss, ensuring business continuity and minimizing downtime. Attendees will learn best practices for optimizing unload tasks, and handling large-scale migrations to cloud or hybrid environments. Real-world case studies will highlight performance gains, reduced disk space consumption, and simplified operations. Whether you are a DBA, or architect, this session will equip you with practical strategies to maximize the value of HPU in your enterprise.

This hands-on lab will explore how Db2 integrates vector data with structured relational data to support AI-driven use cases. Through guided exercises, attendees will combine unstructured text-derived vectors with traditional data and apply similarity search across both. The lab shows queries that merge SQL filtering with vector similarity to enable semantic search, recommendations, and intelligent data retrieval.