Workshops & Hands-On Labs

IDUG LATAM Brazil 2025 Db2 Tech Conference | Sao Paulo

W01 | Infusing Db2 for z/OS with AI: Hands-on lab with IBM Db2 AI 1.6 for z/OS

Presented by: Sueli Almeida, IBM in Portuguese
z/OS
10:00 - 14:10

Modern hybrid cloud infrastructures are becoming too complex for humans to manage efficiently and effectively. Shortage of experienced Db2 for z/OS professionals is further exacerbating the situation. This warrants a need for embracing AI and automation to augment human intervention to ensure the highest achievable availability and performance for Db2® for z/OS® systems. IBM Db2® AI for z/OS® ("Db2ZAI") provides three key features.
1. SQL Optimization - This empowers the optimizer in your Db2 for z/OS engine to determine the best-performing query access paths with performance validation based on your workload characteristics.
2. System Assessment - This detects Db2 system performance exceptions and provides recommended actions for tuning which are based on your environment.
3. Distributed Connection Control (DCC) - This provides protection for Db2 for z/OS from unintentional disruptions and intrusions that can originate from remote applications.

This Hands-on Lab covers these main features provided by Db2ZAI.

W02 | Performance Monitoring and Tuning Workshop

Presented by: Michal Bialecki, Chris Crone and Antonio Couto, Broadcom in English and Portuguese
z/OS

This workshop is covering following below areas, with in-depth explanations, rules of thumbs, recommendations, and Grafana dashboard examples.
Db2 subsystem performance monitoring and tuning
- Db2 address space time analysis
- EDM pools and dynamic statement cache
- Buffer pools monitoring
- ESCA and RIDPOOL memory monitoring
- Datasets open/close, logging and locking
Application performance monitoring and tuning
- Accounting time overview
- In-Db2 CPU time analysis
- Explain highlights
- Wait time analysis

W03 | Hands-on-Lab: AI Application Development with Db2

Presented by: Shaikh Quadar, IBM in English
LUW
10:00 - 13:10

This hands-on workshop introduces the tools and workflows for building AI applications with Db2. Participants will explore how to develop and deploy AI solutions using Db2’s built-in capabilities and its integrations with external frameworks. Topics may include model training, inference, semantic search, and application integration—depending on the selected exercises. Through guided, practical modules, attendees will gain experience applying AI techniques to real-world scenarios, and learn how Db2 supports a range of AI use cases across different data types. No prior experience with Db2’s AI features is required.

W04 | Hands-on-Lab: Db2 SaaS Update on Amazon and Azurele

Presented by: Andrew Hilden, IBM in English
LUW
13:10 - 15:20

Description Coming Soon

W05 | Hands-on Lab: Db2 12.1.3 Intelligence Center with AI Assistant

Presented by: Sheshnarayan Agrawal, IBM in English
LUW
15:40 - 17:50

This hands–on lab introduces participants to a new AI–powered console designed to simplify and enhance Db2 database management. Through guided exercises, participants will learn how to use the console's features to monitor database performance, troubleshoot common issues, and apply optimization recommendations. Key tasks will include setting up and customizing dashboards, diagnosing performance bottlenecks using real–time monitoring tools, and leveraging AI–driven recommendations for query tuning and resource management. Participants will also explore natural language interactions for querying data and step–by–step troubleshooting. This lab is designed for database administrators and IT professionals who want practical experience using an intelligent, streamlined tool for managing Db2 environments. By the end of the session, attendees will have a better understanding of how to integrate these capabilities into their day–to–day workflows to improve efficiency and system reliability.