IDUG Brazil 2026

In the world of Db2 for z/OS, "set it and forget it" is a recipe for performance degradation and wasted storage. As data volumes explode and batch windows shrink, traditional housekeeping—REORG, RUNSTATS, and IMAGE COPY—must evolve from manual chores into a streamlined, automated strategy. This deep-dive workshop (not a hands-on lab) provides a comprehensive blueprint for modern Db2 maintenance. We will move past the basics to explore how to balance object availability with optimal performance. Attendees will learn how to leverage the latest utility enhancements to reduce CPU consumption, manage multi-terabyte objects, and ensure that the optimizer always has the "ground truth" through intelligent statistics collection.

In the world of Db2 for z/OS, "set it and forget it" is a recipe for performance degradation and wasted storage. As data volumes explode and batch windows shrink, traditional housekeeping—REORG, RUNSTATS, and IMAGE COPY—must evolve from manual chores into a streamlined, automated strategy. This deep-dive workshop (not a hands-on lab) provides a comprehensive blueprint for modern Db2 maintenance. We will move past the basics to explore how to balance object availability with optimal performance. Attendees will learn how to leverage the latest utility enhancements to reduce CPU consumption, manage multi-terabyte objects, and ensure that the optimizer always has the "ground truth" through intelligent statistics collection.

In the world of Db2 for z/OS, "set it and forget it" is a recipe for performance degradation and wasted storage. As data volumes explode and batch windows shrink, traditional housekeeping—REORG, RUNSTATS, and IMAGE COPY—must evolve from manual chores into a streamlined, automated strategy. This deep-dive workshop (not a hands-on lab) provides a comprehensive blueprint for modern Db2 maintenance. We will move past the basics to explore how to balance object availability with optimal performance. Attendees will learn how to leverage the latest utility enhancements to reduce CPU consumption, manage multi-terabyte objects, and ensure that the optimizer always has the "ground truth" through intelligent statistics collection.

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.