IDUG Brazil 2026

Customers are constantly striving to perform essential DBA related tasks being drivin by application improvements and evolutions. Non-Disruptive schema changes have been a major objective for the Db2 for z/OS ecosystem. This session will go through the evolution of Universal Table Space from the beginning up to current Db2 for z/OS Function Levels, showing the innovative functionality that can be exploited to achieve the highest level of availability.

This presentation explains how Db2 profile tables are used to route queries to the Analytics Accelerator. It includes student labs to demonstrate query acceleration, discusses the impact of relevant zPARMs, and covers tracing techniques, catalog queries, and Db2 commands used to monitor and troubleshoot accelerated workloads.

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:

1. An overview of the OpenTelemetry observability framework and how it helps generate, process, and distribute telemetry data
2. How Db2 for z/OS supports OpenTelemetry and how you can leverage it for your applications
3. 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.

In today’s digital landscape, cyber resilience isn’t optional — it’s essential. This session will concentrate on a consistent repeatable Cyber Recovery process that significantly improves Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).

The IBM Z Cyber Vault solution creates immutable, point-in-time copies of your production data, stored in a secure, isolated environment on IBM Storage. This clean, protected copy becomes your safety net in the event of logical data corruption — enabling forensic, surgical, or full recovery options when you need them most. But what about Db2 for z/OS? Traditional backup recovery might leave your business hours — or even days — behind. Implementing additional steps and processes will bridge the gap between your last Safeguarded Copy backup and the point of corruption, helping you recover consistently with minimal data loss and reducing your RTO to resume business operations.

Managing distributed connections to Db2 and preventing wayward threads from spiraling have surfaced as a key challenge for DBAs. Join this session to use profile tables to effectively monitor distributed threads and take appropriate action to minimize impact from potential bad actors. We will then look at an innovative customer application of profiles to control JDBC connections and redirects select connections to the appropriate drivers.

IBM strengthens the AI‑ready value of the IBM Z platform -- bringing game-changing integration and intelligence to powerhouse Db2 solutions: Db2 Query Monitor, SQL Performance Analyzer, Log Analysis Tool, Db2 Admin Tool and OMEGAMON AI for Db2. This session dives into the latest enhancements that unify these solutions into a seamless experience—eliminating the need to jump between interfaces or reauthenticate.
We’ll explore how these tools now work together to streamline performance tuning, query analysis, and administrative tasks, creating a more efficient workflow for Db2 professionals. Learn the setup requirements, see live navigation demos, and discover how this integration accelerates problem resolution and optimizes your Db2 environment.If you’re looking to boost productivity, simplify operations, and unlock new synergies in your Db2 ecosystem, this session is your playbook for success.

Key Takeaways:
1. Seamless Integration Across Tools - Learn how IBM has unified Db2 Query Monitor, SQL Performance Analyzer, Log Analysis Tool, and the Db2 Admin Tool into a single, streamlined workflow—eliminating redundant logins and improving productivity.

2. Enhanced Navigation & Efficiency - Discover how to navigate between tools effortlessly, leveraging new features that simplify performance tuning, query analysis, and administrative tasks without leaving your current environment.

3. Setup & Best Practices for Success - Gain practical insights into configuration requirements, integration tips, and real-world strategies to maximize the value of these combined Db2 solutions in your enterprise.