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.

Modern engineering teams move fast, but brittle tests, flaky mocks, and sluggish integration pipelines can slow even the strongest React + Node backends to a crawl. Database testing is often the first casualty—SQL tests get skipped because they require a persistent Db2 instance, complicating CI/CD and slowing development. This session presents a battle‑tested alternative: using SQLite as an ephemeral, SQL‑compatible stand‑in for Db2 to deliver fast, reliable, production‑like backend tests. You’ll learn how to spin up isolated in‑memory databases, seed realistic data, run true end‑to‑end API tests, and automate teardown without touching production infrastructure. We’ll cover schema alignment, SQL‑driven test design, and strategies for keeping tests blazing fast as your backend grows. If you want to test backend logic as it actually runs—not as mocks pretend it runs—this talk will give you the practical patterns and real‑world insights to elevate your testing strategy and ship with confidence.

Db2 for z/OS continues to advance with new capabilities that simplify development, automation, and operations across the enterprise.
Join this session to explore the latest modernization updates including Db2 auto-discovery of configuration parameters, future exploitation around Configuration as Code, new APIs to support continuous integration and continuous deployment of database schema changes, and IBM Db2 Agents.