IDUG NA 2025: Full Schedule

arrow_back View All Dates

9:00am EDT

A14 | Db2Z and Redirected Recovery – User Experiences

Thursday June 12, 2025 9:00am - 10:00am EDT

Db2 Z Redirected Recovery is a powerful V12 capability of IBM RECOVER utility. It allows one to recover a Db2 object into another object without impacting the original. This presentation will review the details of WHAT is redirected recovery, WHY it can be useful, and the scenarios where it might be used. JCL steps will be detailed along with along with caveats, lessons learned, and some user experiences.

Speakers

Brian Laube

Db2 DBA, Manulife Financial

Brian Laube is an appliction Db2 Z DBA for Manulife Financial in Canada (known as John Hancock in USA). Brian has been a DBA for over 20 years. Brian has presented at IDUG conferences several times since 2016 in both NA and EMEA and his local Db2 user group. Brian is currently... Read More →

Thursday June 12, 2025 9:00am - 10:00am EDT
Piedmont

Technical Session, Backup Recovery & Data Movement

Audience All
Subject z/OS

9:00am EDT

B14 | Easy Space Allocation

Thursday June 12, 2025 9:00am - 10:00am EDT

Roswell

We were in a situation that some parts from a old/huge Partition range table are full and PAGENUM was ABSOLUTE, and we are not able to manage space locally in each part , So was Decided to ADD some parts between existing parts ! In this journey we needed to tackle some issues Like finding partitions range value for brand new parts, learning about concept of physical and Logical parts, and understanding how Db2 manages them. Moreover how utilities like Load and Reorg handle the added Parts! Many details discussed and shared.

Speakers

Leila Hosseini

Senior DBA, OPS

Working with DB2 since 2001, World wide speaker of DB2.

Thursday June 12, 2025 9:00am - 10:00am EDT
Roswell

Technical Session, Database Practices

Audience Intermediate
Subject z/OS

9:00am EDT

C14 | Db2 SaaS Modernization on Azure and BYOC

Thursday June 12, 2025 9:00am - 10:00am EDT

Spring

If you are interested in Db2 Managed Services on the Cloud this is a great session to attend to get the very latest information. This session will review some of the recent updates to our Db2 managed services and in particular it will dive deeper into our upcoming managed Db2 cloud services on Azure. It will go over features, but also review the technical architecture behind a new SaaS deployment model which allows you to get the benefits of a managed service while hosting the infrastructure in your own cloud account.

Speakers

Andrew Hilden

Chief Architect Db2 SaaS, IBM

Andrew Hilden is the Chief Architect of Db2 SaaS. He is involved extensively in the development and architecture of several data-oriented cloud services in IBM. In the past 25 years he has worked in development, architectural and leadership roles in Db2 from SaaS to areas like appliances... Read More →

Thursday June 12, 2025 9:00am - 10:00am EDT
Spring

Technical Session, Operations & Automation

Audience All
Subject LUW

9:00am EDT

D14 | DB2 Universal Translator between z/OS and LUW

Thursday June 12, 2025 9:00am - 10:00am EDT

Techwood

The intent of this presentation is to allow DBAs with either Db2 z/OS or Db2 LUW skills apply thier knowledge to the other Db2 platform. There is a lot of commonality between these versions of Db2, however there are some huge differences. Deployment models, differences in functionality and how each is structured will be explained in detail.

Speakers

Dale McInnis

Principal Data Technical Specialiust, IBM

Dale McInnis is a Principal Data & AI Technical Specialist from the IBM Toronto Canada Lab. He has a B.Sc.(CS) from the University of New Brunswick and a Masters of Engineering(M.Eng) from the University of Toronto and is currently pursuing his PhD in computer science. Dale joined... Read More →

Jerome Gilbert

IBM

Thursday June 12, 2025 9:00am - 10:00am EDT
Techwood

Technical Session, AI Data Mining and ML

Audience All
Subject LUW

9:00am EDT

E14 | Fun with SQL – Table Expressions

Thursday June 12, 2025 9:00am - 10:00am EDT

Inman

Join the IDUG Content Committee for this fun interactive session where you will deepen your knowledge of SQL. This session will focus on the use of table expressions. We will have a short presentation and there will be an opportunity to sharpen your skills with others dojo style.

Speakers

David Simpson

DBA, IDUG Content Committee

The IDUG Content Committe is made up of volunteers who solicit, develop and curate content for the IDUG website. At most conferences we conduct the Fun With SQL Workshop to contribute to attendee's skills and develop relationships with and within the Db2 community.

Thursday June 12, 2025 9:00am - 10:00am EDT
Inman

Technical Session, SQL App Dev and Modernization

Audience All
Subject z/OS, Cross Platform

9:00am EDT

F14 | Build a Lightweight Monitor to Identify SQL Workload Tuning Potential

Thursday June 12, 2025 9:00am - 10:00am EDT

University

In this session, you will learn how to capture SQL statistics from Db2’s dynamic statement cache and how to combine them with the information from your EXPLAIN tables. The code that we use will be available for download after the session. Discover how to identify the queries that will benefit most from tuning, allowing you to focus your valuable time on those that matter. We start with simple metrics like RID list errors and work our way up to other performance metrics like top consumers, I/O statistics, lock contention, and more. You will learn how to track the performance and resource consumption of a given SQL statement over time, which makes it possible to spot trends. Finally, we will show how to detect access path changes in dynamic SQL workload. This is a common problem in environments with heavy dynamic workload. Something as simple as a single RUNSTATS execution on one of the involved tables can causeunexpected changes to the access path that Db2 chooses. Using historic explain information, these changes become visible, and you can take immediate action.

Speakers

Kai Stroh

Mainframe Siftware Developer, UBS Hainer

Kai Stroh earned a Computer Science degree from the University of Darmstadt and is a mainframe software developer specializing in DB2 utilities for z/OS. He designs and builds innovative DB2 applications and utilities often working onsite or remotely with UBS Hainer’s international... Read More →

Thursday June 12, 2025 9:00am - 10:00am EDT
University

Technical Session, Performance Monitoring and Troubleshooting

Audience Intermediate
Subject z/OS

10:10am EDT

A15 | Unlocking Recovery – The Key to Solving Everyday Problems

Thursday June 12, 2025 10:10am - 11:10am EDT

Piedmont

Thinking about your availability and recovery strategy shouldn't give you sleepless nights. When issues do come up, you want to make sure you have the tools needed to solve problems and ensure you get the most out of your investment in Db2. This presentation will give you some context and insight into the top questions we see from our customers the most in the areas of backup, restore, crash recovery, locking, logging, transaction management and high availability and disaster recovery. The questions and answers discussed here could save you when an unexpected outage arises and/or better prepare you to avoid an outage in the future.

Speakers

Michael Roecken

Software Developer, IBM Canada

Michael Roecken is a senior software developer with Db2 for Linux, UNIX, and Windows platforms at the IBM Toronto Lab. Michael has worked since 2000 designing, implementing and supporting various features and capabilities in the areas of: backup/restore, crash/rollforward recovery... Read More →

Thursday June 12, 2025 10:10am - 11:10am EDT
Piedmont

Technical Session, Backup Recovery & Data Movement

Audience Beginner
Subject LUW

10:10am EDT

B15 | Understand, Manage and Love Certificates in z/OS and USS

Thursday June 12, 2025 10:10am - 11:10am EDT

Roswell

Understand, manage and love certificates in z/OS and USS, will address distributed Db2 access. You can communicate with z/OS, USS, Db2, or any other server or service via “postcards”, or “sealed envelopes”. Even within a trusted network, unencrypted postcard communication isn’t state of the art and may compromise information you don’t intend to share.
Web–based solutions, like ZOWE, UMS, ADF,… require secure connections, but the setup can be frustrating. Setting up and using encrypted channels isn’t rocket science, but they’re all based on certificates that some people find difficult to manage.This session sheds light on secure communication and their implementation in z/OS and USS services. I’ll explain how secure communication is set up, established and managed, as well as understanding difficulties that may arise.

Speakers

Ulf Heinrich

Director Solutions Delivery, SEGUS Inc

Ulf Heinrich specialized in Db2 recovery and operations, managing cost reduction and 24×7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under... Read More →

Thursday June 12, 2025 10:10am - 11:10am EDT
Roswell

Technical Session, Database Practices

Audience All
Subject z/OS

10:10am EDT

C15 | Strategies for Making Db2 Data Accessible with APIs

Thursday June 12, 2025 10:10am - 11:10am EDT

Spring

This session will explore multiple strategies for enabling API access to your Db2 data. We will examine both direct API connections to Db2 and alternative mechanisms for accessing Db2 data through z/OS–enabled APIs. Attendees will gain insights into optimizing data accessibility and enhancing integration capabilities, empowering their applications to interact seamlessly with Db2 resources. Join us to explore practical approaches and best practices for leveraging APIs effectively in your Db2 environment.

Speakers

Chris Crone

Distinguished Engineer - Database Technologies, Broadcom

Chris is a Distinguished Engineer for Database Technology and a lead architectfor the Data Management portfolio within the Mainframe Division of BroadcomSoftware Group. He oversees strategy and architecture decisions for theBroadcom database products IDMS and Datacom, as well as for... Read More →

Thursday June 12, 2025 10:10am - 11:10am EDT
Spring

Technical Session, Operations & Automation

Audience All
Subject z/OS

10:10am EDT

D15 | Vector Support in IBM Db2: Empowering the Development of Modern LLM Applications

Thursday June 12, 2025 10:10am - 11:10am EDT

Techwood

Large language models (LLMs) have revolutionized AI by enabling a new category of applications called language apps. Enterprises have widely started using these apps for various purposes such as chatbots, document summarization, question–answering, and information retrieval. This has sparked renewed interest in AI in recent years. A crucial aspect of language apps is the generation of vector embeddings using language models. This process converts unstructured content, like PDFs, into AI–readable representations. These embeddings are used for vector similarity search, which offers more precise semantic search compared to traditional methods. However, vectors have high dimensionality, so they need cost–effective and secure storage, as well as efficient search methods. Db2 is introducing its first phase of vector support, which includes in–database vector storage, vector similarity search, and various vector operations. In this presentation, the Speaker will discuss Db2’s upcoming vector support features and how they can be utilized to develop modern LLM applications with Db2.

Speakers

Shaikh Quader

AI Architect, IBM Db2, IBM

Shaikh Quader is the AI architect of IBM Db2. He develops database features to improve database operations with ML and help users deploy ML models in the database. Shaikh manages research collaboration between IBM and a few Canadian universities. He and his team developed 5 Python... Read More →

Mike Springgay

Db2 Architect, IBM

Mike Springgay is the Db2 Architect. Prior to that he was responsible for architecting extensions to Db2’s Warehouse capabilities, SQL compatibility features, routine infrastructure and client server connectivity.

Thursday June 12, 2025 10:10am - 11:10am EDT
Techwood

Technical Session, AI Data Mining and ML

Audience All
Subject LUW

10:10am EDT

E15 | Recycling Task that will Call a Database Table with Deadlock is Triggered

Thursday June 12, 2025 10:10am - 11:10am EDT

Inman

Issue: Files are transferred between two LPARS that have a DASD as storage. Due to high volume of file transfer there is issue with CPU utilisation going high that affects the performance strategies and customers need to pay more.

Solution:In this scenario,I have added an alarm in the LPAR using utility software. The mechanism is once the CPU utilisation is going high and the task has reached a threshold limit an alarm on the LPAR will get triggered to inbox stating recycle of that task is required.

Speakers

Samhita Pal

Thursday June 12, 2025 10:10am - 11:10am EDT
Inman

Technical Session, SQL App Dev and Modernization

Audience All
Subject z/OS

10:10am EDT

F15 | “The Art of War” Against Bad SQL

Thursday June 12, 2025 10:10am - 11:10am EDT

University

‘The Art of War’ is an ancient Chinese book on military skills, strategy, and tactics. It has influenced military thinking for centuries and has been applied to many fields outside of the military, such as business tactics, legal strategy, politics, sport, and now for the first time Db2 SQL performance!
In this session, you will learn how the ‘Art of War’, principles such as planning, resources, attack and defense, timing, strength/weaknesses, weapons, and knowledge, translate perfectly into tactics to defend against and defeat bad SQL.
This is a back–to–basics session where you will learn how to use these principles to fight against bad SQL. It provides many practical examples and for additional interest is illustrated using maxims and quotes from the book.

Speakers

Ramon Menendez

Principal Solution Engineer, BMC Software

Ramon Menendez is a Principal Solution Engineer from BMC Software in Spain, specialized in the DB2 family of products. Started in IT as a QUEL developer and INGRES administrator. He worked for several years for IBM with DB2, mainly in competitive analysis, implementation and performance... Read More →

Thursday June 12, 2025 10:10am - 11:10am EDT
University

Technical Session, Performance Monitoring and Troubleshooting

Audience Intermediate
Subject z/OS

11:20am EDT

A16 | DDF Best Practice

Thursday June 12, 2025 11:20am - 12:20pm EDT

Piedmont

Db2 Distributed Data Facility (DDF) is the gateway to delivering business enterprise data in our modern world of cloud computing. DDF is widely exploited in the information technology space and this session aims to share best practices and success stories to optimize your business with DDF. Some of the topics includes, infrastructure, security, protecting data over the network, monitoring resources (threads/connections), sysplex workload balancing, and so forth. The objective of this session is provide you with practical, useful knowledge that you can take back to your work and manage DDF confidently.

Speakers

Derek Tempongko

Db2 for z/OS DDF development, IBM

Derek Tempongko is a Senior Software Engineer on the Db2 for z/OS development team at the IBM Silicon Valley Laboratory. With over 20 years of experience in Distributed Data Facility (DDF), he has authored a Redpaper on TLS/SSL and several blogs in the Db2 for z/OS community. His... Read More →

Thursday June 12, 2025 11:20am - 12:20pm EDT
Piedmont

Technical Session, Backup Recovery & Data Movement

Audience All
Subject z/OS

11:20am EDT

B16 | Digging into HADR Performance on AWS

Thursday June 12, 2025 11:20am - 12:20pm EDT

Roswell

Db2 HADR is a widely deployed Highly–Available configuration, providing excellent reliability and capacity, with Reads–on–Standby and multiple auxillaries. This session takes a look at the performance of HADR solutions, including

how to successfully configure and monitor HADR operation
best practices and troubleshooting
Configuring and using virtual IP
examining performance data from AWS HADR pairs for different sync modes

Speakers

Toby Haynes

Senior Software Developer, IBM Canada

With a background in Observational Astronomy at the University of Cambridge, England, Toby joined IBM Canada in 1999 as a software developer in the Db2 Runtime engine. After eight years of development experience, he moved over to the Db2 Performance team to start work on what would... Read More →

Thursday June 12, 2025 11:20am - 12:20pm EDT
Roswell

Technical Session, Database Practices

Audience Intermediate
Subject LUW

11:20am EDT

C16 | Deciding which Buffer Pools to Page Fix using Automation

Thursday June 12, 2025 11:20am - 12:20pm EDT

Spring

Automated process of page fix removes the manual efforts which are required for DBA's and System programmers to determine if page fixing buffer pools is a possibility in their environment and how to most effectively use the real storage resources on the LPAR to that end.In this beginner–level session, we will see how the best candidate for page fixing is determined. How the availability of real storage on LPAR is being determined.

Speakers

Donnell Roach

BMC

Thursday June 12, 2025 11:20am - 12:20pm EDT
Spring

Technical Session, Operations & Automation

Audience Beginner
Subject z/OS

11:20am EDT

D16 | Access Path Management (with and without AI): Best Practices for influencing the Db2 for z/OS Query Optimizer and for Minimizing the Risk of Access Path Changes

Thursday June 12, 2025 11:20am - 12:20pm EDT

Techwood

Db2 for z/OS provides several features to influence the query optimizer. Learn how to leverage these features to improve query performance, and to avoid access path changes that introduce the risk of regression after a BIND, REBIND or full PREPARE. Also, should an access path regression occur, learn what your options are to quickly restore performance.The session includes how Db2ZAI works with the Db2 optimizer to improve query performance while minimizing the risk of access path regression.

Speakers

Thomas Beavin

Senior Software Engineer, IBM

Thomas Beavin joined IBM in 1986 as a Db2 developer working in the Utilities area. In 1994 he joined the Db2 query optimizer development team, where he is still currently a member. He has designed features and written code for every release of Db2 since version 1 release 2.In recent... Read More →

Thursday June 12, 2025 11:20am - 12:20pm EDT
Techwood

Technical Session, AI Data Mining and ML

Audience All
Subject z/OS

11:20am EDT

E16 | Db2–Pardy

Thursday June 12, 2025 11:20am - 12:20pm EDT

Inman

New to Db2 for z/OS? Or maybe you just need a refresher on the basics? No matter where you are on your Db2 journey, put your knowledge and what you have learned this week to the test in a session styled after the famous game show we all know and love. Welcome to Db2pardy!

Speakers

Keziah Knopp

Db2 for z/OS Specialist, IBM

Keziah Knopp is a Db2 for z/OS Specialist at the IBM Z Washington Systems Center (WSC). Prior to joining the WSC Keziah focused on z/OS Communications Server, writing papers and delivering presentations on IPv6 and IBM z Encryption Readiness Technology (zERT). She has presented... Read More →

Victoria Felt

Thursday June 12, 2025 11:20am - 12:20pm EDT
Inman

Technical Session, SQL App Dev and Modernization

Audience All
Subject z/OS

11:20am EDT

F16 | Advanced Performance Diagnostics for SQL

Thursday June 12, 2025 11:20am - 12:20pm EDT

University

The Db2 family of products including Db2, Db2 Warehouse, and BigSQL provide a number of important features for diagnosing and solving your SQL problems. Through a series of practical examples, this session will bring you up speed on the latest capabilities available for SQL diagnostics and show you how you can leverage them to solve query problems in your own environment. You will learn how to identify your most expensive SQL statements using the package cache table functions, and how to use Db2's "time spent" metrics to analyze where your problem queries are spending their time. You will also learn some new tips for monitoring sort memory metrics and query memory consumption in order to tune your analytic workloads. Finally you will learn how to use the runtime explain capabilities in conjunction with the activity event monitor to capture actual query plan cardinalities as well the per object metrics.

Speakers

David Kalmuk

Distinguished Engineer, Analytic Databases, Data & AI, IBM

David is a distinguished engineer at IBM, working on IBM's analytic database products.

Thursday June 12, 2025 11:20am - 12:20pm EDT
University

Technical Session, Performance Monitoring and Troubleshooting

Audience All
Subject z/OS, LUW