IDUG NA 2026

In this session we'll take a look at the capabilities that have been added to Db2 over the past years to prepare Db2 to meet client demands of today and the future. This will include modern deployment options such as cloud and containerized deployments - but - we'll spend more time on modern workloads such as data virtualization, multi-model support, NoSQL support, how to handle mixed workloads and, of course, AI. Many clients are using Db2 for traditional OLTP, operational and analytic workloads - but - are you getting the full value of your Db2 investment and footprint ? All these high value capabilities are there and included in your current license base. Lets unpack what they are.

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.

IBM System Z and Db2 for z/OS applications are essential to the successful operations and business workflows for major companies. Join our discussion on OpenTelemetry and its powerful impact on observability across your entire business environment. Whether you're a System Reliability Engineer or an Application Developer, this session is for you!Here's what you'll learn:

An overview of the OpenTelemetry observability framework and how it helps generate, process, and distribute telemetry data.
How Db2 for z/OS supports OpenTelemetry and how you can leverage it for your applications.
How OpenTelemetry support aligns with the broader platform, i.e. IBM System Z and Db2 for z/OS, to enhance your operations.

Don’t miss out on this opportunity to enhance your understanding and implementation of OpenTelemetry within Db2 for z/OS and its futures.
Don’t miss out on this opportunity to enhance your understanding and implementation of OpenTelemetry within Db2 for z/OS and its futures.

Db2 delivers a wide range of tools for problem determination. Those tools range from the new Log Analysis Capability in IBM Db2 Genius Hub to classical tools that can and should be used for deeper analysis. As the Db2 community constantly welcomes new database administrators and application developers, an effecient tooling and its use is required for those new community mambers. The session will share tools and best practices for the first occurrence data capture (FODC) tools available for DBAs and developers. This session will cover the first steps in the process of problem determination and problem source identification (PD/PSI). It provides hands-on and practical examples for the strategy and process to encircle and find problems by asking the right questions.

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.