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.

Fast copies of Db2 for z/OS tables are increasingly difficult as newer features add structural complexity. Table versioning, partition growth and rotation, XML and LOB data, temporal and archive relationships, and deferred VSAM creation can prevent direct dataset-level copies and force slower fallback methods. This webinar explains the key challenges and what they mean for copy speed and reliability.

Event streaming is essential for modern applications and AI agents that need real-time access to mainframe data. This session explores change data capture patterns for Db2 z/OS using Debezium and Kafka, covering both initial snapshot and continuous replication. Learn how event streaming benefits agent architectures, implementation with Confluent Platform running on-premises on the mainframe, and achieving minimal operational impact with high-performance data synchronization. Real-world use case examples demonstrate practical applications.

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.

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

As Transport Layer Security (TLS) becomes mandatory across enterprise environments, Db2 professionals increasingly play a pivotal role in protecting data in transit—both on the client and server sides. While this session briefly reviews core TLS fundamentals such as trust models and server authentication, its primary focus is on mutual (client) certificate authentication for Db2 for z/OS. Attendees will be guided through the complete configuration workflow, including certificate management, RACF keyring setup, AT TLS policies, DDF configuration, and identity mapping for client certificates.

This session provides an in-depth look at the latest enhancements to SQL syntax, semantics, and application management in Db2 13 for z/OS. Introduced through recent function levels, these enhancements are driven by customer requirements to deliver greater application flexibility and performance, while empowering DBAs with more efficient and effective capabilities for managing applications and database objects.
You’ll also hear feedback on several of these features and use cases from an experienced Db2 user.

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

This updated 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.

As AI capabilities expand on IBM Z, database operations are evolving from manual, expertise-driven practices to more automated, simpler, and faster management. This hands-on lab session provides experience with Database Assistant capabilities which transform Db2 administration through agent-assisted intelligence.
Experience how the solution combines AI-driven system insights, context-aware dashboards, and AI agents to enable:

Faster understanding of system behavior
Accelerated troubleshooting
Clearer assessments of operational impact
More confident decision-making

The benefit is reduced manual effort, improved consistency, faster issue resolution, and enhanced operational efficiency across complex enterprise environments.
Make sure to bring your laptop!

Since 2012, the ADMIN_MOVE_TABLE stored procedure has stood for versatility. Whether you're facing extraordinary challenges or handling everyday tasks, ADMIN_MOVE_TABLE has you covered as a DBA. ADMIN_MOVE_TABLE, or AMT for short, has been continually expanded and new application areas have been added. Today, it's important to understand the architecture and design principles of AMT to understand the best use cases and avoid pitfalls. This workshop will guide you through the AMT functionality, starting with the initial intended use cases, and the most used scenarios. But even more importantly, the instructors will discuss and show pitfalls and will guide trough the problem analysis process for AMT.