IDUG Brazil 2026

High Performance DBATs (HP DBATS) is a very important performance feature of Db2 10 for DDF workloads. If applied and used intelligently this feature can generate significant savings in CPU resource consumption. This session will cover the following topics: what is a connection?; What is a DBAT (THREAD)?; thread (DBAT) pooling and DRDA inactive connections; what are High Performance DBATs; good candidate application workloads for High Performance DBATs; gerneral guidance for configuring High Performance DBATs; performance metrics and monitoring; WLM and High Performance DBATs; Issues, Summary.

Db2 enables developers to write Procedures, Functions, and Triggers using SQL PL (SQL Procedure Language). While IBM does provide a debugger that can be used to debug SQL PL, users may not want to run a debugger in production. This session will explore alternatives to using the Unified Debugger. At the end of this session, you should be able to use the techniques discussed in this presentation to Debug an SQL PL application (Procedure, Function, or Trigger).

The mainframe, it’s just different…scalable, reliable, securable. But many in IT leadership roles think that “difference” is a barrier to success. It doesn’t have to be. The mainframe software has been evolving for years to be more and more manageable via user interfaces and commands that are similar or familiar to people using non-mainframe systems. The barrier to entry has been greatly reduced to enable simplified mainframe operation, monitoring, and performance management.  In this session, we show how IBM Db2 Tools can help to visualize Db2 for z/OS metrics, log information, real time statistics, and more in modern dashboards such as Grafana, IBM Instana or Elastic. This enables Db2 administrators and SMEs to detect anomalies, performance trends, and dependencies without need to navigate between multiple traditional user interfaces. Get to know new insights into your Db2 for z/OS systems with modern, state-of-the-art, and customizable user interfaces.

The AI-driven economy requires quicker responses to market changes, especially for high-demand mainframe Db2 applications, which are seeing increased usage to meet key business needs. To ensure smooth operations of critical workloads, businesses are turning to AI/ML to tackle Db2 performance issues. This enables System Db2 DBAs to predict bottlenecks and minimize business impact.

Discover how LinuxONE redefines the modern data platform. We explore how its architecture consolidates massive databases with minimal latency, extreme security, and high availability. Learn about vertical scalability, drastic software licensing savings, and how LinuxONE’s sustainability drives ROI, transforming your data center into an agile, resilient innovation engine designed for mission-critical workloads.

The main objective of the session is go to show all the available technical items and metrics that are being captured by relatively newer SMF 102 IFCID 365 records. The supplies a great deal of information and that can be drivers for monitoring, exceptions, alerts, trend analysis and much more. The IFCID 365 records are statistics records, and the session will show how you can join the data with Db2 accounting data to driver even more insight and knowledge. Also in the session it will be discussed how best to identify out of support drivers, where they are being initiated from and who the user of the driver is to be able to quickly know who to contact to address the out of support driver. Lastly, distributed workload transaction annotation will be discussed on the great value and the many ways the information can be exploited.