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

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

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

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

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

1:00pm EDT

C203 | BYOD Hands–On–Lab: Performing AI Queries with Db2 13 for z/OS

Thursday June 12, 2025 1:00pm - 4:30pm EDT

Spring

See how IBM SQL Data Insights combines unsupervised deep learning with traditional SQL queries to allow you to run similarity, dis–similarity, cluster, analogy, and commonality queries on your Db2 z/OS data. You can easily uncover the hidden relationships across tables and views in your Db2 data, quickly gain actionable insights for solving your business problems as they arise, and confidently arrive at better business decisions. We will explore tables containing mutual funds financial data, home insurance underwriting data, and food nutrition data. You will experience how AI SQL queries can be applied to industry specific domains to find similarities, segment customers, and find outliers among relational data.
Make sure to bring your own device, and pre–create an IBM ID!

Speakers

Artem Minin

Techincal Specialist, IBM

Artem is currently a Technical Specialist in IBM’s Washington Systems Center, a team of Subject Matter Experts that provide leading edge technical sales assistance for the design, implementation, and support of solutions that leverage IBM Z. Specifically, Artem is responsible for... Read More →

John Goodyear

z Systems Technical Support Specialist, IBM

John Goodyear is a z Systems Technical Support specialist at the Washington Systems Center. John has a broad background in application development, systems management, and benchmarking. For the past 6 years, John has been focusing on Open Data Analytics, WMLz for z/OS, Db2 AI for... Read More →

Thursday June 12, 2025 1:00pm - 4:30pm EDT
Spring

Hands–On Lab

Audience Beginner
Subject z/OS

1:00pm EDT

D203 | The Next Generation of Services for Db2 Administration and Development Workshop

Thursday June 12, 2025 1:00pm - 4:30pm EDT

Techwood

Bring your own device to this workshop, where you will have a chance to perform a hands–on lab to experience the latest deliverables towards Db2 user transformation.

Db2 administrator personas can execute some of their daily tasks in a more intuitive way via Db2 Administration Foundation and its integration with Db2 Tuning Services, Query Workload Tuner and IDAA Administration services. Last but not least, administrators can also benefit from Db2 DevOps experience (DBaaS) to “shift–left” database operations to application developers under their rules and administrative directives.
Db2 application developer personas can develop / test and deploy application changes that also require database change in a speed that business demand. Using Db2 Developer Extension in IDE will simplify coding of SQL including native stored procedure code. Using Db2 DevOps Experience services (DBaaS), developers can, on demand, self–service database operations under the rules previously established by the Db2 administrators.

Speakers

Sueli Almeida

XuQin Zhao

Software Developer, IBM Silicon Valley Lab

XuQin Zhao is the Tech Lead for the SQL Tuning service, with over 15 years of experience in the development of SQL monitoring and optimization tools. She has played a key role in advancing technologies that enhance database performance and efficiency.

Thursday June 12, 2025 1:00pm - 4:30pm EDT
Techwood

Hands–On Lab

Audience All
Subject z/OS

1:00pm EDT

E203 | Db2 for z/OS Performance Monitoring and Tuning

Thursday June 12, 2025 1:00pm - 4:30pm EDT

Inman

Are you struggling with Db2 subsystem and application performance? Join this comprehensive workshop to enhance your skills in Db2 performance management, covering everything from foundational concepts to advanced techniques. We will examine the critical Db2 components that influence subsystem and application throughput, and learn how to identify, monitor, and optimize key health indicators. Additionally, we will share best practices for effective performance analysis and demonstrate how modern open tools can simplify these processes. You'll leave with practical knowledge to improve Db2 performance and streamline your tuning efforts.

Speakers

Andrew Badgley

Lead Product Owner, Broadcom

Andrew Badgley is the Lead Product Owner for the Database Management for Db2 for z/OS Administration, Backup & Recovery, and Utility products at Broadcom Inc. He has 25+ years of experience with these products as Developer, Support Engineer, Support Engineering Manager, Product... Read More →

Thursday June 12, 2025 1:00pm - 4:30pm EDT
Inman

Workshop

Audience All
Subject z/OS