IDUG NA 2026

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.

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.

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.