IDUG NA 2025

Jennifer Pharr Davis, a record-breaking adventurer, author, and small business owner, has drawn invaluable lessons from her 2,200-mile journey along the Appalachian Trail. These lessons—centered on adaptability, innovation, and resilience—have not only empowered her to shatter trail records but also to thrive in business. Jennifer will share her inspiring trail experiences and business insights to motivate fellow Trailblazers to persevere and achieve new heights.

The Db2 for z/OS profile tables have long been helpful for managing a DDF workload in a granular (e.g., application–specific) way, regarding matters such as connection, thread, and idle thread timeout limits. Some fairly recent Db2 13 APARs have extended profile table functionality to include monitoring and enforcement of security requirements for DDF–using applications. This new capability can be leveraged to greatly reduce the risk of application disruption related to implementation of a new DDF application security requirement, such as a requirement for certificate–based (versus password–based) client authentication, or a requirement for use of AT/TLS encryption (commonly known as SSL encryption). In this session, you'll get a quick refresher on Db2 profile table functionality, and you'll learn about the enhancements provided by the aforementioned Db2 13 APARs. We'll explore some scenarios for advantageous exploitation of the new profile table functionality, and we will highlight a real–world example of putting profile table security functionality to work.

This is a back–to–basics session that will cover the fundamentals of Db2 Large Objects (LOBs), their structure, different LOB types, how they are implemented, considerations for daily management and how it is possible to Improve application performance transforming standard lobs to Inline Lobs.
Db2 LOBs enable you to store large amounts of data in a single column. The data can be structured in nature, but more often contain unstructured data such as images or audio data. LOB implementation requires auxiliary objects to be created, which increases the complexity of object administration, space utilization, and utility processing.
This session provides an overview of Db2 LOBs, things to watch out for, and tips for tuning and space allocation.
Objectives:1.    Provide an overview of LOB types, and how they are structured and implemented.2.    Provide tips for performance tuning and space utilization using the Inline Lobs.3.    How to avoid LOB data corruption scenarios and ensure data integrity.

The increased regulatory requirements following the banking crisis in 2007 required Finanz Informatik (the IT service provider of the Sparkassen–Finanzgruppe which contains all 353 German savings banks) to make some changes to its data warehouses:In addition to being able to generate reports for any point in time in the past, it was also necessary to support the requirement for ad–hoc reports. Finanz Informatik decided to address these challenges by using Db2 on AIX with BLU Acceleration and bitemporal tables.This presentation will discuss the experiences and lessons learned which Finanz Informatik gained during this project with these technologies.

Managing distributed connections to Db2 and preventing rogue threads from causing issues has become a significant challenge for DBAs. Join this session to learn how to use profile tables to effectively monitor distributed threads and take proactive measures to mitigate the impact of potential threats. We will explore an innovative customer application of profiles that controls JDBC connections and redirects specific connections to the appropriate Db2 for z/OS release.

An engaging exploration of the hot topic sweeping through the tech world, with a particular focus on mainframe modernization.
This interactive session will demystify the concepts surrounding modernization, including rehosting, refactoring, replatforming, repurchasing, retiring, and retaining.
Through a fun game of Buzzword Bingo, attendees will gain insights into how modernization, concepts and all things new, can elevate their skills and keep their organizations competitive in the digital age. The presentation will highlight the importance of embracing modernization while also appreciating the enduring value of legacy ... legendary systems.
Don't be left behind – join us to understand why modernization is more than just a trend and how it can shape the future of your career and industry.

Want to allow real–time representations of your Db2 for z/OS, Db2 for LUW or even db2 Warehouse on Cloud data to be leveraged as Data Lake, Event Streaming, Cloud Database, and more destinations?  Want to be free to create tables, alter them, apply data and have these changes seamlessly represented in a multitude of data formats and destinations? 
The IBM Data Replication Cartridge is a brand–new cloud architected solution leveraging cloud native convenience while leveraging more than 20 years’ experience with the definitive data replication product, IBM’s IIDR CDC. 
Learn the convenience, robustness, simplicity, and performance that the new cloud native architecture provides.  
We’ll highlight:
1)        Sate of the art functionality:  Never before seen replication functionalities, such as seamless DDL replication and intuitive intention–based user semantics.
2)        The Key to Performance: Highlights of the product architecture that simultaneously parallelizes workload applies Kafka while adaptively applying OLTP changes to aggregate apply preferring WatsonX Data Lake destinations.
3)        Demonstration of data replication showing ease of use and robustness of a cloud based replication architecture.
4)        Customer use cases highlighting the best patterns for using replication to perform real–time event streaming and contrasting WatsonX Data Lake Analytics scenarios.

In today's modern applications, workload is increasingly shifting from traditional CICS or IMS transactions to Java workload. As a result, analyzing dynamic queries has become more important than ever before. 
In this presentation, I will demonstrate how to systematically analyze dynamic queries using the Global Dynamic Statement Cache, and how to identify queries that require immediate attention. We will develop a tool that allows SQL developers to analyze dynamic queries in their shop from day one after the conference. This tool is designed to be easily accessible and user–friendly, without requiring access to the mainframe. With it, developers can answer typical questions such as "Which queries performed better or worse within the last 30 days?", "Which of my queries were running at a given time and how did they perform?", and "Which of my queries are getting slower over time?" in a self–service mode. Additionally, we will explore how to translate query tuning results to cash savings, demonstrating the financial benefits of query optimization. By the end of this presentation, you will have a clear understanding of how to uncover and monetize hidden insights by analyzing the Global Dynamic Statement Cache.

We will share about 10 items/issues we ecncountered in past few years regarding availablity, performance we learned from our day to day work.
These topics including:
   – Julies' Scenario
  – locks
  – SQL execution time
   – quick gain with manipulating statistics 
   – HADR and infinite logging
   – Play with rid
  – impact of AIC
  – performance impact with password check daemon , etc.

In the DevOps era, managing database schema as code is essential for agility and scalability. A key requirement is a streamlined method for provisioning Db2 schema with Ansible®, utilizing RESTful Db2 DevOps APIs for automation in CI/CD pipelines. By adopting this approach, organizations can modernize database operations and improve collaboration between developers and database administrators. In this session, you will learn to configure and execute an Ansible playbook to automate the deployment of Db2 schemas.

In this session we will walk through the many investments Db2 has made to ensure Db2 is ready for modern workloads and deployments.  Modern workloads includes capabilities such as mixed workloads, multi–model capabilities, NoSQL capabilities, enabling columar to handle all types of analytic workloads, AI/ML capabilities and more.  Modern deployments includes our SaaS capabilities, containerization investments, capabilities to integrate Db2 12.1 into a Lakehouse environment to be ready for AI projects and deployment options and more.  This is a good session for all Db2 users who are working to take modernization steps in their environments.

We will illustrate how applications developers can easily use the self–service facilities to make changes, test, commit, push, automate deployment with automated CI/CD pipeline. Such changes can only be done within pre–established rules set by DBA and other administrators.
During this session we will show you the steps administrators would take to set the framework followed by the steps a developer would take to modify an application including database changes and additional objects.

Db2 Family Tools Update
In this Db2 family topic we will delve into two key areas of tooling for Db2 LUW including the new and exciting Db2 AI Assistant, leveraging GenAI to bring value to DBAs – and – a common, simplified Db2 data movement tool called Db2 Bridge which will help manage all the different ways in which data can be moved around the Db2 ecosystem.

SQLDI and Db2zAI Update
In this topic two key AI capabilities of Db2 for z/OS will be provided in detail.

Step inside Broadcom’s Db2 lab for an exclusive glimpse into our innovative developments! Discover how we’re transforming the way next-gen mainframe operators can interact with Db2. This session offers a unique opportunity to participate in a design thinking workshop, where your insights and challenges will help us shape the future direction for new Db2 experiences. Join us to share your ideas, collaborate with your peers, and be a part of this exciting evolution!

Session faciliators: Mauricio Silva, Samantha Buhler

In this presentation we will discuss what is required to build an "always on" architecture.  This is not limited to Db2 LUW, but rather spans the entire software and hardware stack.  Systems are only as reliable as thier weakest point, so how to we work around this limitation? Technology is the easiest part of an Always On architecture, so what makes it so difficult to implement?  There are many aspects that need to examined such as:
Can the "CAP" theorem be disproved?  Stop by this presentation and find out for yourself.

(IDUG EMEA 2024 BEST USER SPEAKER)
SQL stored procedures are a very common method of delivering Db2 functionality to applications.  But when they need performance tuning how do you achieve this.   In this presentation we will explore the components behind SQL stored procedures and how to tune the individual elements.

Amazon RDS for Db2 provides a managed Database on AWS. While this makes the solution really easy to get started with, there is a lot of things under the covers that can help you better use the system.  This session will go over some of the technical details under the covers of RDS for Db2 and also provide a series of Tips and Tricks when using RDS. It will go over some money saving strategies you can use as well as give an introduction on how you can migrate workloads to Amazon RDS for Db2.