Loading…
Sunday, June 8
 

7:00am EDT

Breakfast On Your Own
Sunday June 8, 2025 7:00am - 9:00am EDT
Sunday June 8, 2025 7:00am - 9:00am EDT
  Breakfast

8:00am EDT

Registration Available
Sunday June 8, 2025 8:00am - 5:00pm EDT
International Tower Lobby
Sunday June 8, 2025 8:00am - 5:00pm EDT
International Tower Lobby
  Registration

9:00am EDT

B201 | Infusing Db2 for z/OS with AI: Hands–on Lab with IBM Db2 AI 1.6 for z/OS
Sunday June 8, 2025 9:00am - 12:30pm EDT
Roswell
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.
Speakers
avatar for Martin Dinh

Martin Dinh

Software engineer, IBM
I am a dedicated and passionate software engineer specializing in Db2ZAI. As an integral member of the team, I focuses on the overall architecture of Db2ZAI, ensuring its robustness and scalability. With a strong commitment to innovation, I play a key role in developing and delivering... Read More →
avatar for John Goodyear

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 →
Sunday June 8, 2025 9:00am - 12:30pm EDT
Roswell
  Hands–On Lab

9:00am EDT

C201 | Hands–on SSL/TLS Deployment for Db2 LUW Clients and Servers
Sunday June 8, 2025 9:00am - 12:30pm EDT
Spring
This half–day hands–on workshop is designed to provide you with all the details you need to know for a successful SSL/TLS deployment for Db2 LUW and on–going certificate maintenance.  Encrypting network communications is essential in today’s security conscious world and is a complex task with many moving parts.  That complexity is confirmed by the number of cases Db2 support and development see asking for help configuring TLS.  This workshop builds on those years of experience to give you the knowledge you need to set things up correctly and securely.  The workshop will start with the very basics of asymmetric cryptography, which form the foundation of certificates and turn the discussion to trust and the role it plays.  From there, we will turn to hands on exercises configuring the Db2 server, followed by Db2 clients/drivers allowing encrypted client/server communication.  Topics such as certificate creation, keystore management, and hostname validation will be discussed and practiced.  The steps required for certificate renewal will be demonstrated.  Advanced topics such as TLS with HADR will be discussed, showing how the practiced knowledge of setting up client/server TLS will follow through to HADR.  While not necessary to attend the workshop and learn something, the hands on–portions will require you to bring your own laptop and be able to establish an SSH connection to the public IBM Cloud.
Speakers
avatar for Greg Stager

Greg Stager

Db2 Security Architect, IBM
Greg Stager is the security architect for Db2 LUW at the IBM Toronto Lab. Greg has been a member of the Db2 security development team since 2000, where he has worked on all aspects of security within Db2, including authentication, authorization, auditing and encryption.
Sunday June 8, 2025 9:00am - 12:30pm EDT
Spring
  Workshop

9:00am EDT

D201 | The HADR with Pacemaker for Cloud Deployments Workshop
Sunday June 8, 2025 9:00am - 12:30pm EDT
Techwood
Db2 databases support the High Availability needs of many customers today. Db2 v11.5.5.0 saw the general availability of High Availability with Pacemaker on the Linux platform, providing a newer, Cloud–ready alternative to the TSA implementation. Newer releases have added support for AWS, Azure, Google Cloud and IBM Cloud environments, and many other refinements. This workshop will give you hands–on experience for managing a Db2 HADR with Pacemaker Cluster on the AWS, Microsoft Azure, Google Cloud or IBM Cloud. The session will cover the Cloud specific Implementation of Fencing and virtual IP Addresses. It will help you understand the information provided by the cluster utilities, across basic operations, diagnostics, and best practices from the IBM Labs This workshop will also demonstrate basic problem scenarios, troubleshooting and collection of essential support data to accelerate problem resolution in emergency cases. 
Speakers
avatar for Toby Haynes

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 →
avatar for Thomas Rech

Thomas Rech

Senior IT Architect - DB2 SAP Development, IBM
Thomas has been working in the Db2 area since 1996. Starting as a Db2 course instructor, he soon moved to the SAP on Db2 environment in 1997. He joined the SAP/IBM Db2 Development Team, followed by a role as technical sales consultant. He led several lighthouse projects like the first... Read More →
Sunday June 8, 2025 9:00am - 12:30pm EDT
Techwood
  Workshop

9:00am EDT

E201 | The Tortoise or the Hare: Unlock the Full Potential And Speed of Your Database
Sunday June 8, 2025 9:00am - 12:30pm EDT
Inman
Are your DB2 queries slowing down your applications? Are you struggling to meet performance SLAs? It's time to take control of your database performance with expert query tuning techniques.
This session will delve into the essential principles and best practices for optimizing DB2 queries. You'll learn how to:
 * Identify Performance Bottlenecks: Discover powerful tools and techniques to pinpoint the root causes of query slowdowns.
 * Leverage Explain Plans: Understand the execution plan of your queries to identify inefficiencies and opportunities for optimization.
 * Optimize Query Structure: Learn how to rewrite queries to improve their performance, including techniques like indexing, partitioning, and query hints.
 * Utilize DB2 Performance Tools: Explore the suite of DB2 performance monitoring and tuning tools to gain valuable insights into your database behavior.
 * Implement Effective Monitoring Strategies: Establish a robust monitoring framework to proactively identify and address performance issues.
By attending this session, you'll gain the skills and knowledge to significantly improve the performance of your DB2 queries, leading to faster response times, reduced system load, and enhanced overall database efficiency.
Speakers
avatar for Carlos Davis

Carlos Davis

Solutions Advisor, Rocket Software
Carlos is a seasoned IT professional with over 20 years of experience in database administration, specializing in DB2. As a Solutions Advisor at Rocket Software, he leverages deep technical expertise and a strong understanding of industry trends to deliver innovative solutions that... Read More →
Sunday June 8, 2025 9:00am - 12:30pm EDT
Inman
  Workshop

9:00am EDT

A201/202 | Unlock Modernization: Installing Zowe API ML and Elevating the Db2 for z/OS Experience
Sunday June 8, 2025 9:00am - 5:00pm EDT
Piedmont
New to getting Open Mainframe Project Zowe up and running? Bring your laptop and join us for an informative workshop designed to guide you through the essential steps of installing and configuring Zowe's API ML, the open–source framework that facilitates mainframe services accessibility for both application developers and database administrators. This workshop will be divided into two main segments.
In the first part, we’ll dive into the critical Zowe configuration aspects, covering three key focus areas:1. YAML Edits – Learn how to customize configurations efficiently to suit your environment.2. Certificates Configuration – Understand the importance of security and how to set up certificates for seamless connectivity.3. Networking – Explore networking configurations that ensure Zowe communicates effectively across applications and your mainframe.
In the second part, we will shift our focus to how Zowe enhances the Db2 development and administration experience for users of Broadcom’s Db2 Suites. Discover how Zowe integration streamlines workflows and improves productivity. Whether you're a seasoned mainframe developer or new to the ecosystem, this workshop will equip you with the knowledge to leverage Zowe and transform how you interact with Db2 for z/OS.
Speakers
avatar for Mark Daubman

Mark Daubman

Client Services Consultant, Broadcom
Mark Daubman is a Client Services Consultant at Broadcom responsible for Database Management for Db2 for z/OS and Database Management Suite for IMS for z/OS solutions. He is also a member of the Zowe API Mediation Layer Swat team providing customers with the expertise in the installation... Read More →
Sunday June 8, 2025 9:00am - 5:00pm EDT
Piedmont
  Workshop

12:30pm EDT

Mid-Day Break
Sunday June 8, 2025 12:30pm - 1:30pm EDT
Lunch will be available for attendees who have pre-registered for Sunday Workshops & Hands-On Labs. Pick up your Lunch Tickets at registration when you check in! 
Sunday June 8, 2025 12:30pm - 1:30pm EDT
  Break

1:30pm EDT

D202 | Using Db2 and RAG Generation with LLMs
Sunday June 8, 2025 1:30pm - 5:00pm EDT
Techwood
Have you ever tried to use an LLM? How exactly can they be used in a business environment? And how can Db2 help with the accuracy of what an LLM produces?
This lab will take you through the various components that are used to create a system that generates a RAG (Retrieval–Augmented Generation) for an LLM to use to answer a question. You will get a chance to experiment with a system that provides a environment where you can try out different prompts and settings to see how an LLM will respond to your question. 
You will also get to see how Db2 fits into this picture and what vector calculations (and Vector databases) do when generating a RAG prompt.
 
 
Speakers
avatar for George Baklarz

George Baklarz

Technical Specialist, IBM
George Baklarz, B. Math, M. Sc, Ph.D. Eng., has spent many years in IBM working on various aspects of database technology. In 1991, George was part of the team that introduced the Db2 distributed product to the market. He has written 14 books on Db2 and has a patent for the process... Read More →
Sunday June 8, 2025 1:30pm - 5:00pm EDT
Techwood
  Hands–On Lab

1:30pm EDT

E202 | IBM Db2 Query Monitor – Hands on Lab for the Web Client Interface
Sunday June 8, 2025 1:30pm - 5:00pm EDT
Inman
IBM Db2 Query Monitor for z/OS, V3.4 offers current and historical views of query activity throughout Db2 subsystems. It gives you the ability to efficiently customize and tune your SQL workload and Db2 objects to validate the effectiveness of your Db2 subsystems and improve overall performance. It also offers you extensive choices so you can determine what monitoring information you will gather, and when.
DB2 Query Monitor for z/OS enables you to identify problem SQL activity and applications, allowing you to focus your efforts on improvement. DB2 Query Monitor enables you to do the following:  – Proactively manage DB2 resources  – React quickly and effectively to supply and demand–related DB2 problems (such as those resulting from inefficient SQL or inadequate object structures)  – Identify SQL requests that prevent critical requests from completing on schedule
Db2 Query Monitor comes with two interfaces, ISPF and a Web Client.  This hands on lab will take the user through the Web Client interface.   From your web browser, you can review query activity in Db2 Query Monitor, the SQL/CA, Db2 Commands, view alerts, and configure actions and responses. 
Speakers
avatar for Tom Glaser

Tom Glaser

Sr. Solutions Advisor, Rocket Software
Tom Glaser has worked in the mainframe environment for the past 40 years, andwith Db2 on z/OS since Version 1.3.  Tom has written numerous articles on Db2,developed tools, and has presented at past IDUG, Db2 Tech, IOD, Insight andTechXchange conferences in the US, as well as Europe... Read More →
Sunday June 8, 2025 1:30pm - 5:00pm EDT
Inman
  Hands–On Lab

1:30pm EDT

B202 | BYOD Hands-on Lab: IBM Db2 z/OS Data in an Open Lakehouse
Sunday June 8, 2025 1:30pm - 5:00pm EDT
Roswell
As the Data Lakehouse model revolutionizes data stores, it has become crucial to integrate vital IBM Z data within them. Experience how easy it can be to synchronize your vital IBM Db2 z/OS and VSAM data directly into Iceberg tables in Cloud Object Storage. With Data Gate for watsonx, get the power of the Open Lakehouse leveraging the most important data in your enterprise! 
Make sure to bring your own device to complete the lab exercises, and pre–create an IBM ID.
Speakers
avatar for Artem Minin

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 →
avatar for John Goodyear

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 →
Sunday June 8, 2025 1:30pm - 5:00pm EDT
Roswell
  Workshop

1:30pm EDT

C202 | MaaS – Db2 Monitoring as a Service in AWS, Azure, GC and IBM Cloud
Sunday June 8, 2025 1:30pm - 5:00pm EDT
Spring
A cloud native resource without monitoring (or with a very complex monitoring setup) is like driving a car without a dashboard – you wouldn't know if you are speeding or low on fuel! Db2 needs a concise and simplified monitoring solution that gives a bird eye's view on the performance metrics and Db2 diagnostics. We present here a solution that is available in AWS, Azure, Google Cloud and IBM Cloud while running Db2 with a Infrastructure as a Service model.
The speaker will cover her experience of collaboration with all cloud vendors, Db2 development and customers like SAP. The session will share the findings from that reserach and development project and it is based on the cloud native monitoing solutions currently available. The solution consists of a smart combination of Db2 monitoring capabilities, Operating System scheduling and Cloud logging functionality resulting in an out–of–the–box Db2 monitoing solution.
The solution has the following features:

Displays the most important metrics (based on customer data) of a database instance namely, Bufferpool quality, Activities per second, Activity wait time and Logging performance.
Information regarding Db2 Diagnostics by providing the count of increasing errors that can be easily extended for a comprehensive diagnostic analysis. 
Whether or not the database is alive.

This solution introduces the Monitoring as a Service infrastructure and ables you to build your own cloud native monitoring solution with a few fingertips.
Speakers
avatar for Thomas Rech

Thomas Rech

Senior IT Architect - DB2 SAP Development, IBM
Thomas has been working in the Db2 area since 1996. Starting as a Db2 course instructor, he soon moved to the SAP on Db2 environment in 1997. He joined the SAP/IBM Db2 Development Team, followed by a role as technical sales consultant. He led several lighthouse projects like the first... Read More →
Sunday June 8, 2025 1:30pm - 5:00pm EDT
Spring
  Workshop

1:30pm EDT

F202 | Amazon RDS for Db2 Workshop
Sunday June 8, 2025 1:30pm - 5:00pm EDT
University
This workshop will give you the education and information you need to use existing and new features of Amazon RDS for Db2. Some of the topics covered during this workshop will include provisioning, scaling, backup, monitoring, migration and beyond.  Each module will be introduced and presented and then participants will be provided an environment they can use and go through a series of instructor led exercises to practice what they have learned and explore.  This will be a joint workship between the IBM and AWS RDS teams.
Speakers
avatar for Andrew Hilden

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 →
avatar for Javeed Mohammed

Javeed Mohammed

Database Solutions Architect, Amazon
Sunday June 8, 2025 1:30pm - 5:00pm EDT
University
  Workshop
 
Monday, June 9
 

7:00am EDT

Breakfast On Your Own
Monday June 9, 2025 7:00am - 8:30am EDT
Monday June 9, 2025 7:00am - 8:30am EDT
  Breakfast

7:30am EDT

Registration Available
Monday June 9, 2025 7:30am - 5:00pm EDT
International Tower Lobby
Monday June 9, 2025 7:30am - 5:00pm EDT
International Tower Lobby
  Registration

8:30am EDT

IDUG Opening Comments
Monday June 9, 2025 8:30am - 9:00am EDT
International Ballroom
Monday June 9, 2025 8:30am - 9:00am EDT
International Ballroom
  Main Stage Event

8:30am EDT

IDUG Db2 for LUW Essentials Course
Monday June 9, 2025 8:30am - 5:00pm EDT
Edgewood
This 3.5-day foundational course introduces the essentials of Db2 12.1 for relational DBAs, covering architecture, installation, configuration, and basic database management. It then builds on these core essentials with topics such as data movement, backup and recovery, and routine maintenance to ensure performance and integrity.  Designed for new and transitioning DBAs, the course emphasizes hands-on learning with minimal prerequisites beyond basic SQL and database knowledge.

Note: There is no certification for the foundational course, but students can take a proctored quiz after the class to obtain the badge.

Monday June 9, 2025 8:30am - 5:00pm EDT
Edgewood
  IDUG Essentials

8:30am EDT

IDUG Db2 for z/OS Essentials Course
Monday June 9, 2025 8:30am - 5:00pm EDT
Auburn
This 3-day course will expose the beginning z/OS DBAs (Database Administrators) to the essentials of Database Administration for a Db2 13 for z/OS. This course will teach the students how to physically implement a logical database design using DDL and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

Note: This course does not prepare the novice to pass the exam.

Monday June 9, 2025 8:30am - 5:00pm EDT
Auburn
  IDUG Essentials

9:00am EDT

K1 | What's next in Data Strategy and what does it mean for Db2, Presented by IBM
Monday June 9, 2025 9:00am - 10:00am EDT
International Ballroom
Join Skyla Loomis and Priya Srinivasan for an exclusive keynote session on technology trends in the market and how you can accelerate the impact of AI in your organization. The success of AI in business hinges on high-quality, secure data. Enterprises that double their ROI from AI have invested in trustworthy, governed data. Yet, data is rapidly expanding in volume and variety, challenging organizations to effectively manage and utilize diverse, unstructured, and structured data sources in their AI. In this session, look closer to the Data Strategy in IBM, learn about the latest innovations in Db2 and how clients have achieved data-driven transformation within their organization.

Speakers
avatar for Skyla Loomis

Skyla Loomis

General Manager, IBM Z Software, IBM
Skyla leads product management, development, design, and content development for the IBM Z Software business, focusing on delighting clients across our IBM Z Transaction Processing platform. This includes our core z/OS application and data management products such as IMS, CICS, Db2... Read More →
avatar for Priya Srinivasan

Priya Srinivasan

Vice President, IBM Core Software Products, Software Support & SRE, IBM
Priya Srinivasan is Vice President, of IBM Core Software Products, IBM Software Support & SRE.Priya has over 2 decades of experience leading Global support, development and professionalservices organizations across various IBM Software technologies. She has worked in various IBM DataManagement... Read More →
Monday June 9, 2025 9:00am - 10:00am EDT
International Ballroom
  Main Stage Event

10:00am EDT

Networking & Coffee Break
Monday June 9, 2025 10:00am - 10:20am EDT
International Ballroom
Monday June 9, 2025 10:00am - 10:20am EDT
International Ballroom
  Coffee Break

10:20am EDT

A1 | Db2 for z/OS Spotlight: Trends and Directions from the Lab
Monday June 9, 2025 10:20am - 11:20am EDT
Embassy B/C
This session from Db2 for z/OS development leadership provides essential insight into Db2 strategy and technical direction. It will provide an overview of recent enhancements and the value that they provide. Just as importantly, it will place them in the broader context of where Db2 is headed. This will enable you to make important decisions now to position your business for the future of IBM's flagship database.
Speakers
avatar for Haakon Roberts

Haakon Roberts

Director, CTO, DE Db2 for z/OS & Tools development, IBM
Haakon Roberts is an IBM Distinguished Engineer based at the Silicon Valley Laboratory in San Jose, California. He is the Director of the Db2 for z/OS and Tools organization and CTO of IBM z Data & AI. He holds several patents and is a leading expert in database management, data integrity... Read More →
Monday June 9, 2025 10:20am - 11:20am EDT
Embassy B/C
  Spotlight

10:20am EDT

B1 | Db2 LUW Spotlight Session
Monday June 9, 2025 10:20am - 11:20am EDT
Embassy D/E
Hear from the lab leadership on recently shipped / announced Db2 content, and our perspective and vision for the future.
Speakers
avatar for Satya Krishnaswamy

Satya Krishnaswamy

Director, Hybrid Data Management Development, IBM, IBM
Satya Krishnaswamy is the Director of Product Development for Hybrid Data Management at IBM which includes the Db2 family of products.
avatar for Wesley Gyure
Monday June 9, 2025 10:20am - 11:20am EDT
Embassy D/E
  Spotlight

11:30am EDT

A2 | Key Performance Updates, zSynergy and Best Practices for Db2 for z/OS
Monday June 9, 2025 11:30am - 12:30pm EDT
Piedmont
Db2 for z/OS continues to deliver significant advancements in performance optimization and monitoring capabilities. This session will explore 

The latest performance enhancements as well as instrumentation updates in Db2 13 for z/OS  
The synergy with IBM Z hardware and software
Performance tuning guidelines derived from customer experiences to mitigate performance challenges and boost efficiency.  

Attendees will gain insights into key updates for Db2 performance and monitoring, and the latest recommendations.   
Speakers
avatar for Akiko Hoshikawa

Akiko Hoshikawa

Software developer, IBM
Akiko Hoshikawa is a Distinguished Engineer at IBM Silicon Valley Laboratory in San Jose. As a Db2 for z/OS architect she has overall responsibility for the performance and strategic integration of AI capability within IBM Db2 for z/OS, including the Db2 AI for z/OS product.
Monday June 9, 2025 11:30am - 12:30pm EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

11:30am EDT

B2 | Db2 Latest from the Lab
Monday June 9, 2025 11:30am - 12:30pm EDT
Roswell
Both an overview and a deep dive of recently shipped / announced Db2 content, and then a look into what is coming soon.
Speakers
avatar for Mike Springgay

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.
Monday June 9, 2025 11:30am - 12:30pm EDT
Roswell
  Technical Session, Db2 Features Improvements and Tips LUW

11:30am EDT

C2 | Basics of Shell Scripting for the Db2 DBA
Monday June 9, 2025 11:30am - 12:30pm EDT
Spring
For work I try to stick to a rule: "Never do something three times!". I do it once, the second time I'm annoyed and for the third time I try to automate it.As I'm currently managing around 40 RHEL servers with nearly 700DBs on it, automation, conventions and rules are key.
In this session I want to show the audience general commands and constructs within shell programming. Givng a method at hand how to fast develop shell scripts and oneliners and some tricks to get around some possible pitfalls on the way.
Speakers
avatar for Sebastian Zok

Sebastian Zok

Senior Database Administrator, Cancom Managed Services GmbH
Sebastian got a diploma in IT in 2007 and started first in software development. He worked on Db2 performance monitoring and switched to Db2 consultancy shortly after. He is working with Db2 LUW since version 7. Currently Sebastian is working for an IT provider as Senior Db2 DBA administering... Read More →
Monday June 9, 2025 11:30am - 12:30pm EDT
Spring
  Technical Session, Database Practices

11:30am EDT

D2 | How to Recover When Recovery Seems Impossible
Monday June 9, 2025 11:30am - 12:30pm EDT
Techwood
Db2 professionals spend a significant amount of time preparing for the worst–case scenarios. How many image copies do you take daily? How much space do these image copies occupy?
The primary reason for taking backups is to facilitate recovery. However, there are times when we face recovery situations and find that we cannot perform the recovery as outlined in our training or manuals.
This presentation will explore alternatives to typical Db2 recovery methods, with the top priority being the recovery of broken, invalid, or compromised Db2 objects. We will discuss various redirected recovery techniques and their applications.
Over the years, Db2 releases have enhanced recovery capabilities to address data availability and retention. This presentation will explain how these changes can impact recovery strategies.
Attendees will leave with new insights and methods for accessing and recovering Db2 data.
Speakers
avatar for Chad Reiber

Chad Reiber

Software Consultant, BMC Software
In 1983 Chad Reiber started in IT with AT&T as a developer of data generator software. From there he moved into the database arena as a database administrator for IMS, IDMS, and Db2. Chad has been working with Db2 since 1987.  Chad began working for BMC Software in 1997 as a Software... Read More →
Monday June 9, 2025 11:30am - 12:30pm EDT
Techwood
  Technical Session, SQL App Dev and Modernization

11:30am EDT

E2 | Db2 DDF and DBATs and Connections Re–Explained from a User Perspective
Monday June 9, 2025 11:30am - 12:30pm EDT
Inman
Distributed client applications (from a server) are the most important and common of new workload using Db2 Z.  
There are many concepts and terms thrown around which we often too often gloss over without a complete understanding.
This presentation will re–explain basic terms from my user perspective plus share some experiences learned (the hard way?) over recent years.
 
This presentation covers THREADS and DBATS and CONNECTION.   
Db2 command DISPLAY DDF DETAIL will show valuable information about current DBAT usage (in–use and disconnected).  
Db2 command DISPLAY THREAD LOCATION(*) will show information about all the in–use DBAT (active, disconnecting or connecting).
Db2 itself monitors current in–use DBATS and spits out interesting message DSNL077I when in–use DBAT reaches 85% of MAXDBAT.  This is an important clue that something is probably going wrong!
Db2 statistics tell us all the same meta data about DBAT info.  Reviewing Db2 statistics, via a good Db2 performance database, can provide reports and trends on DBAT usage over time along with CPU consumption by DDF
The presentation will end with my user experience of an application issue of hitting max in–use DBAT and understanding what was going on!
Speakers
avatar for Brian Laube

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 →
Monday June 9, 2025 11:30am - 12:30pm EDT
Inman
  Technical Session, Performance Monitoring and Troubleshooting

11:30am EDT

F2 | Integrating Db2 for z/OS in Cloud Environments
Monday June 9, 2025 11:30am - 12:30pm EDT
University
Are you eager to explore the various ways to integrate Db2 for z/OS within your cloud–inclusive infrastructure? Join this session for a comprehensive overview from multiple roles and perspectives. We will discuss how developers and DBAs can effectively interact with Db2 for z/OS, as well as the different techniques applications can use to access and utilize Db2 for z/OS data.
Speakers
avatar for Toine Michielse

Toine Michielse

Manager, Client Services Consultants, Broadcom
I have been working with Db2 for z/OS ever since V1. In my career I have worked as COBOL/IMS/DB2 programmer, IMS/DB2 DBA and DB2 system engineer. I have also worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide.  Before joining Broadcom I worked at SwissRe... Read More →
Monday June 9, 2025 11:30am - 12:30pm EDT
University
  Technical Session, Cloud Warehouse and Data Lakes

12:30pm EDT

Lunch
Monday June 9, 2025 12:30pm - 2:00pm EDT
International Ballroom
Monday June 9, 2025 12:30pm - 2:00pm EDT
International Ballroom
  Lunch

2:00pm EDT

A3 | Db2, IDAA and Safeguarded Copy Resiliency Evolution and Integration
Monday June 9, 2025 2:00pm - 3:00pm EDT
Piedmont
Ransomware and cyber attacks are increasing each and every day and prove to be extremely disruptive and expensive. Customers are often not prepared for attacks and even if prepared the major loss of data is inevitable. This session will concentrate on how to plan, prepare and test for attacks and discuss what is available now and what integration is coming in the future.
Speakers
avatar for Anthony Ciabattoni

Anthony Ciabattoni

Db2 for z/OS SWAT Team Leader, IBM
Anthony Ciabattoni is an IBM Certified Executive IT specialist and the leader of the Db2 for z/OS World-Wide SWAT team based out of the Silicon Valley Lab with over 32 years of working directly with Db2 for z/OS. His experience includes being a customer lead Db2 architect as well... Read More →
avatar for Cuneyt Goksu

Cuneyt Goksu

Executive IT Specialist, IBM
Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, bachelor’s degree and PhD in Computer Science. He has been working with Db2 for z/OS and IBM Z... Read More →
Monday June 9, 2025 2:00pm - 3:00pm EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

2:00pm EDT

B3 | Introducing the IBM Database AI Assistant for Db2
Monday June 9, 2025 2:00pm - 3:00pm EDT
Roswell
This session will introduce you to the new IBM Database AI assistant, a new AI powered tool designed for DBAs that provides insights and smart recommendations through a natural language chat interface. Leveraging Large Language Models (LLMs) in combination with a wide knowledge base and telemetry from your database fleet, the assistant acts as a copilot that can streamline information retrieval and help you to quickly answer questions and troubleshoot problems on your database systems.
Speakers
avatar for David Kalmuk

David Kalmuk

Distinguished Engineer, Analytic Databases, Data & AI, IBM
David is a distinguished engineer at IBM, working on IBM's analytic database products.
Monday June 9, 2025 2:00pm - 3:00pm EDT
Roswell
  Technical Session, Db2 Features Improvements and Tips LUW

2:00pm EDT

C3 | RUNSTATS Master – Reloaded
Monday June 9, 2025 2:00pm - 3:00pm EDT
Spring
Waaaaay back in 2006 I first held a RUNSTATS Master class where everything that RUNSTATS does to help, and hinder(!), us is explained. After 18 years it has now become an adult and has been updated right up until the last RUNSTATS change in Db2 13 FL500 with all the changes that have happened since 2006.
This session will show you how RUNSTATS works, when to, and not to, use it and how to use it as good as you can.
Speakers
avatar for Roy Boxwell

Roy Boxwell

Senior Software Architect, Software Engineering GmbH
Roy Boxwell is an IBM Champion with more than 38 years of experience in MVS, OS/390, and z/OS environments – 37 of those in Db2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real-time database... Read More →
Monday June 9, 2025 2:00pm - 3:00pm EDT
Spring
  Technical Session, Database Practices

2:00pm EDT

D3 | Index Modernization in Db2 for z/OS: Because Things Have Changed the Past 20 Years!
Monday June 9, 2025 2:00pm - 3:00pm EDT
Techwood
As technology evolves and data volumes surge, the same indexing strategies that worked well 20 years ago are probably no longer optimal. This presentation exposes the critical need for index modernization in Db2 for z/OS applications.
We’ll start by reviewing the critical role of indexes and their history in Db2 for z/OS to set the stage. Then we’ll take a look at the many innovations IBM has applied to indexes in Db2 for z/OS over the past few releases including things like index compression, Fast Traverse Blocks (FTBs), and index features like include columns and indexing on expressions.
With a sound foundation of the recent index capabilities under our belts, we’ll discuss changing data patterns and their impact on indexing. Topics we’ll discuss include big data and analytics, the impact of data growth, and the surge in dynamic SQL.
And we’ll also show how to capture SQL usage (both static and dynamic) to design optimal indexes based on actual usage and access patterns.
By understanding these factors and adopting modern indexing techniques, organizations can significantly enhance the performance, scalability, and overall efficiency of their Db2 for z/OS applications and systems.
Speakers
avatar for Craig Mullins

Craig Mullins

President & Principal Consultant, Mullins Consulting, Inc.
Craig is president & principal consultant of Mullins Consulting, Inc. and an in-demand analyst, author and speaker. He has over three decades of experience in all facets of database systems development. Craig has worked with Db2 on the mainframe since Version 1 and has experience... Read More →
Monday June 9, 2025 2:00pm - 3:00pm EDT
Techwood
  Technical Session, SQL App Dev and Modernization

2:00pm EDT

E3 | Evolution of Database Infrastructure: Performance & Monitoring Considerations when Migrating Large–Scale COBOL Application in Banking from Db2 z/OS to Db2 LUW
Monday June 9, 2025 2:00pm - 3:00pm EDT
Inman
This presentation examines a complex strategic migration of a mission–critical COBOL banking application from Db2 z/OS hosted on IBM mainframe to Db2 LUW on Power Linux, drawing from a Polish banking institution's transformation initiative serving 12 million customers. We explore our comprehensive approach to database performance monitoring and capacity planning while migrating a 30+ TB database to a distributed architecture. The discussion focuses on practical methodologies for performance testing, benchmarking, and risk mitigation, highlighting key differences between Db2 z/OS and Db2 LUW environments. We will share our experience in addressing platform–specific considerations and architectural adaptations required for successful migration. Through real–world scenarios and lessons learned, attendees will gain actionable insights into our approach for designing monitoring frameworks and implementing effective migration strategies for similar large–scale database modernization projects.
Speakers
JR
Monday June 9, 2025 2:00pm - 3:00pm EDT
Inman
  Technical Session, Performance Monitoring and Troubleshooting

2:00pm EDT

F3 | Db2 – Mission Critical High Volume Highly Complex Cross Platform Migration to Cloud – Next Steps
Monday June 9, 2025 2:00pm - 3:00pm EDT
University
This is my preferred presentation for IDUG–2025.This was presented at IBM TechXChange and IDUG – 2024.This is updated presentation with all enhancement for Cross platform migration for AIX to AWS/RDS/Db2.
Description
DB2 – High Volume Highly Complex cross platform migration to Cloud – Next Step–       Mission Critical database–       Volume more than 125,000 per seconds–       From AIX to AWS/RDS/Db2–       Feathering HADR, Federation, Multi–partition tables, CDC–       Encrypted databases with high volume of transaction logs–       Optimized Power system with compression at every level–       Specially Project help from AWS beta and POC–       AIX to RDS via S3 without Linux/EC2 requirements
 
Speakers
avatar for Nemi Agrawal

Nemi Agrawal

CEO & Director, DataStorm Inc
Nemi AgrawalTechnical Program Manager | Speaker | Tech Influencer | IBM Champion (2023-24)   With over 30 years of experience spanning global organizations like the Department of Homeland Security/Customs and Border Protection, Citibank, IBM, Deutsche Bank, and Deutsche Telekom... Read More →
Monday June 9, 2025 2:00pm - 3:00pm EDT
University
  Technical Session, Cloud Warehouse and Data Lakes

2:00pm EDT

Badging at IDUG
Monday June 9, 2025 2:00pm - 3:30pm EDT
Fairlie
Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information: 
  • First & Last Name: 
  • Email Address: 
  • Exam Choice: 
  • Day & Time Choice: 
Exam choices include: 
  • Db2 11.5 Foundations Exam 
  • Db2 11.5 Administration Exam 
  • Db2 11.5 Advanced Database Resilience Exam 
  • Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
  • Db2 12.1 Foundations Exam * NEW * 
  • Db2 12.1 Administration Exam * NEW * 

IMPORTANT NOTES: No walk-ins. You must book in advance and you will receive  a confirmation once you are officially booked. This is a Bring Your Own Device  exam. Photo ID will be required at exam time. 
Monday June 9, 2025 2:00pm - 3:30pm EDT
Fairlie
  Badging & Certification

3:00pm EDT

Networking & Coffee Break
Monday June 9, 2025 3:00pm - 3:20pm EDT
International Ballroom
Monday June 9, 2025 3:00pm - 3:20pm EDT
International Ballroom
  Coffee Break

3:20pm EDT

A4 | All about Db2 for z/OS Package Management
Monday June 9, 2025 3:20pm - 4:20pm EDT
Piedmont
Db2 for z/OS packages – the compiled and executable form of static SQL, and the structural enablers of dynamic SQL – have been around for a LONG time. That said, effective management of packages has become more important in recent years, thanks to things like newer bind options (e.g., APPLCOMPAT, CONCENTRATESTMT), newer availability and concurrency enhancements (e.g., rebind phase–in, autobind phase–in) and newer mechanisms for controlling and enabling package behavior (especially the Db2 profile tables). Learn about all this, and more, in this session.
Speakers
avatar for Keziah Knopp

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 →
avatar for Mark Rader

Mark Rader

Db2 for z/OS Specialist, IBM
Mark Rader is a Db2 for z/OS specialist in the IBM Z Washington Systems Center.  Mark has applied his Db2 for z/OS experience with clients across a wide variety of projects, with emphasis on availability, performance and Db2 for z/OS data sharing. He is a frequent speaker at conferences... Read More →
Monday June 9, 2025 3:20pm - 4:20pm EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

3:20pm EDT

B4 | Db2 12.1: Advances in Operational Resiliency for Mission–Critical Workloads
Monday June 9, 2025 3:20pm - 4:20pm EDT
Roswell
Db2 offers a wide range of operational resilient deployment patterns, and for each management features that maintain the database online. With the release 12.1, Db2 continues to make progress in delivering improvements in the operational resilience functionality to ensure your most demanding environments maintain the highest availability that the 24x7 world demands. In this session we will cover the features that allow Db2 to scale resources up or down to meet changing workload demands efficiently. We will also discuss how a Db2 database system can maintain its critical functions and operations in the face of disruptions or challenges.
Speakers
CG
avatar for Francis Wong

Francis Wong

Program Director - Db2 Development, IBM
Francis Wong is a technical leader in data management software development. He is the Program Director of Db2 Development. He led the development of several hybrid data management cloud services. He launched watsonx.data cloud service, a fit-for-purpose open data lakehouse service... Read More →
Monday June 9, 2025 3:20pm - 4:20pm EDT
Roswell
  Technical Session, Db2 Features Improvements and Tips LUW

3:20pm EDT

C4 | Personal Experience: 40 Years of Battle Scars from Managing Db2 for z/OS
Monday June 9, 2025 3:20pm - 4:20pm EDT
Spring
Having been a DBA from 1985 to 1995, followed by working in the field with Db2 customers around the world for 30 years, I have come face–to–face with many trials and tribulations. Join this session to experience some of the most interesting battles and learn how partner solutions can augment and complement native Db2 features. You will leave inspired with new ideas to apply in your environment.
Speakers
avatar for Steen Rasmussen

Steen Rasmussen

Customer Services Consultant, Broadcom
Steen Rasmussen is a Principal Engineering Services Architect currently instrumental in the ongoing development and support of the Broadcom Db2 tools. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark working with all aspects of DB2 - like tuning, application... Read More →
Monday June 9, 2025 3:20pm - 4:20pm EDT
Spring
  Technical Session, Database Practices

3:20pm EDT

D4 | SQL Joins – In Depth
Monday June 9, 2025 3:20pm - 4:20pm EDT
Techwood
The joining of two or more tables in SQL is a great feature of the SQL language.  So often we need to combine data from more than one table into the same row output.  Depending on your logic needed, the language provides us with different types of joins.  This presentation starts off basic and builds into more in–depth logic and performance when having the need to process more than one table in a query. The different types of joins presented are: 
Inner Joins (Inner join vs comma delimited syntax) 
Left Outer Joins
Right Outer Joins
Full Outer Joins
Outer Joins with 'On clause Extensions'
Self Joins (Same table in FROM clause more than once)
This presentation will:

Take you deeper into SQL join logic
Help udertstand when specific joins are needed 
Understand the performance of joins
Understand 'On Clause Extensions' and when to use them
Understand the need for the same table in FROM clause more than once *Self Joins)

Speakers
avatar for Tony Andrews

Tony Andrews

Mainframe Developer/Trainer, P+T Solutions, Inc.
Tony Andrews has more than 30 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs... Read More →
Monday June 9, 2025 3:20pm - 4:20pm EDT
Techwood
  Technical Session, SQL App Dev and Modernization

3:20pm EDT

E4 | Using db2mon and R for Deep Insights into your Database Activity
Monday June 9, 2025 3:20pm - 4:20pm EDT
Inman
Db2 offers many rich data monitoring sources to collect, but how do you decide what is important or useful to collect? This session looks at regular db2mon data collection with  a focus on extracting insights from the data, both from a single db2mon report and also from multiple data collections over time.
This session will cover many performance metrics including
– system basics – activity, utilization– bottleneck checks – waiting on disk, network, locks, etc.– bufferpool activity and effectiveness– insights over time – looking at metrics from multiple reports and charting important trends
R provides a rich and repeatable set of data manipulations that provide a flexible and composable set of tools to dig into and chart the db2mon data. This is supplemented by custom Db2–developed tooling that is now open–sourced to convert multiple db2mon reports into data files grouped by report types for deeper insights on database behaviour.
Speakers
avatar for Toby Haynes

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 →
Monday June 9, 2025 3:20pm - 4:20pm EDT
Inman
  Technical Session, Performance Monitoring and Troubleshooting

3:20pm EDT

F4 | How to Access Db2 for z/OS (and other Z oriented) Data in the Cloud
Monday June 9, 2025 3:20pm - 4:20pm EDT
University
Every enterprise, with Db2 for z/OS as core database, have application modernization modernization plans in the context of Db2 for z/OS. Topics like, hybrid cloud, data fabric, data lakehouse are all bringing architecture and product level topics in front of the Db2 DBA. 
In this presentation following topics will be presented with technical details to prepare a Db2 for z/OS DBA for

Modernizing direct access to Db2 for z/OS data from the cloud via ODBC, JDBC, Rest
Architectural alternatives to provide Db2 z/OS data into the cloud native applications world
Virtualization options to access mainframe data including Db2 for z/OS
How to provision a copy of Db2 for z/OS data in the cloud for high–volume query and/or analytics use cases.
Technical details of Integrated Synchronization which is the core replication protocol from Db2 for z/OS to the cloud in the context of Db2 DBA 

Technical and business use cases will be part of the presentation so that Db2 for z/OS  DBA will be aware and contribute to the decision making process
Speakers
avatar for Cuneyt Goksu

Cuneyt Goksu

Executive IT Specialist, IBM
Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, bachelor’s degree and PhD in Computer Science. He has been working with Db2 for z/OS and IBM Z... Read More →
Monday June 9, 2025 3:20pm - 4:20pm EDT
University
  Technical Session, Cloud Warehouse and Data Lakes

4:00pm EDT

Badging at IDUG
Monday June 9, 2025 4:00pm - 5:30pm EDT
Fairlie
Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information: 
  • First & Last Name: 
  • Email Address: 
  • Exam Choice: 
  • Day & Time Choice: 
Exam choices include: 
  • Db2 11.5 Foundations Exam 
  • Db2 11.5 Administration Exam 
  • Db2 11.5 Advanced Database Resilience Exam 
  • Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
  • Db2 12.1 Foundations Exam * NEW * 
  • Db2 12.1 Administration Exam * NEW * 

IMPORTANT NOTES: No walk-ins. You must book in advance and you will receive  a confirmation once you are officially booked. This is a Bring Your Own Device  exam. Photo ID will be required at exam time. 
Monday June 9, 2025 4:00pm - 5:30pm EDT
Fairlie
  Badging & Certification

4:30pm EDT

A5 | The Greatest and the Latest Db2 13 Online Schema and Application Performance enhancement
Monday June 9, 2025 4:30pm - 5:30pm EDT
Piedmont
The session will focus on Db2 13 the invaluable features of the online schema enhancements that can assist DBAs managing their database objects.  Each feature will be explored and discussed in detail on what customer pain point is being addressed, best practices when implementing the features, real life customer experiences.
Speakers
avatar for Frances Villafuerte

Frances Villafuerte

Senior Technical Staff Member, IBM
Frances is a Senior Technical Staff Member with IBM Silicon Valley Lab, where she leads the data manager development team for Db2 for z/OS. She joined Db2 for z/OS development in year 2000 and has been leading several critical core functional areas within the product such as Online... Read More →
Monday June 9, 2025 4:30pm - 5:30pm EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

4:30pm EDT

B5 | Db2 LUW V12: New Security Features and Changes
Monday June 9, 2025 4:30pm - 5:30pm EDT
Roswell
Db2 LUW V12 has a plethora of changes in the area of security and this session will highlight everything new and changed.  This includes features such as enhancements to trusted context, tablespace administration, fenced stored procedure lockdown, and minor authentication improvements.   A focus has been made on cleaning up less than secure defaults and features.  These have direct impact to many daily operations, be sure to attend to learn about all of these changes.
Speakers
avatar for Greg Stager

Greg Stager

Db2 Security Architect, IBM
Greg Stager is the security architect for Db2 LUW at the IBM Toronto Lab. Greg has been a member of the Db2 security development team since 2000, where he has worked on all aspects of security within Db2, including authentication, authorization, auditing and encryption.
Monday June 9, 2025 4:30pm - 5:30pm EDT
Roswell
  Technical Session, Db2 Features Improvements and Tips LUW

4:30pm EDT

C5 | Mastering Db2 for z/OS Application Performance: Strategies for Success
Monday June 9, 2025 4:30pm - 5:30pm EDT
Spring
Are you revising, enhancing, or establishing an effective Db2 application performance management strategy? Join this session to benefit from over 30 years of experience in the field. We will discuss key processes, important factors to consider, and essential data to collect for successful performance management.
Speakers
avatar for Toine Michielse

Toine Michielse

Manager, Client Services Consultants, Broadcom
I have been working with Db2 for z/OS ever since V1. In my career I have worked as COBOL/IMS/DB2 programmer, IMS/DB2 DBA and DB2 system engineer. I have also worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide.  Before joining Broadcom I worked at SwissRe... Read More →
Monday June 9, 2025 4:30pm - 5:30pm EDT
Spring
  Technical Session, Database Practices

4:30pm EDT

D5 | 10 Things I Wish I'd Known Before I Move to Developer Extension from Data Studio
Monday June 9, 2025 4:30pm - 5:30pm EDT
Techwood
IBM has announced the withdrawal of IBM Data Studio support for IBM Db2 for z/OS effective on March 31, 2025. The key Data Studio capabilities that support Db2 for z/OS application developers are now available, in IBM Db2 for z/OS Developer Extension. 
This session aims to ease the migration from Data Studio to Developer Extension. It will introduce best practices and tips that would help users in the migration process. eg. How easy is it to transfer data, projects, or workflows to the new tool?
User scenarios will be introduced to demostrate how to work in the new tool in a comparable way with Data Studio. eg. How to develop a Java Stored Procedure?
From the session, users would learn IBM Db2 for z/OS Developer Extension is a light weighted and modern tool with better performance. They would gain more confidence to migrate to the new tool.
Speakers
avatar for Ke Chen

Ke Chen

Technical Lead, IBM
I have worked on Db2 tools development for more than 16 years. I have developed Db2 tools from generation to generation, from Data Studio to DSM, from DSM to DMC. I was the developer lead and owner of Data Studio. And I'm the technical lead of IBM Db2 for z/OS Developer Extension... Read More →
Monday June 9, 2025 4:30pm - 5:30pm EDT
Techwood
  Technical Session, SQL App Dev and Modernization

4:30pm EDT

E5 | Don’t have an SQL Monitor? You Might Need a Bigger Shovel
Monday June 9, 2025 4:30pm - 5:30pm EDT
Inman
Running Db2 on z/OS without a monitor is like driving a car without a speedometer or gas gauge; it’s something you need.   While monitoring at the subsystem level is important, you may ask yourself, do I really need a method of monitoring SQL?  You can try to export the Dynamic Statement Cache, or start an expensive SQL trace within your subsystem monitoring tool, but when there’s a problem, you need a quick and easy way to monitor the SQL statements.  You don’t want to recreate the issue; you want to go back in time to find out what happened.  The key software vendors for Db2 have a tool that monitors SQL.  
If you're new to Db2, just purchased a monitoring tool or maybe you don't have a tool at all, come listen to this session.  As a Db2 DBA most of my life, I'll go over the key reasons why you need to monitor your SQL.  Without an SQL monitoring tool:

Can you quickly determine the most expensive SQL statement on your subsystem?
Are you able to list all SQL statements within a package, sorted by most expensive in terms of getpages, CPU or elapsed times?
Do you receive alerts and email notes telling you there’s a resource unavailable condition or that a package failed?
Can you see who stopped your tablespace in production?

Monitoring an SQL statement is different than monitoring a Db2 thread in your subsystem monitor.  In this presentation, I’ll show you key metrics I look for.  Should you look at total getpage activity per query or the average number of getpages?  What are the delays telling me?  Are there certain SQL codes we should be monitoring?
Would extracting the host variables help in resolving SQL Code 100 return codes where no records are found?  While I will be using the IBM Db2 Query Monitor tool for screen shots, I hope to cover SQL accounting data used by all vendor tools.
Speakers
avatar for Tom Glaser

Tom Glaser

Sr. Solutions Advisor, Rocket Software
Tom Glaser has worked in the mainframe environment for the past 40 years, andwith Db2 on z/OS since Version 1.3.  Tom has written numerous articles on Db2,developed tools, and has presented at past IDUG, Db2 Tech, IOD, Insight andTechXchange conferences in the US, as well as Europe... Read More →
Monday June 9, 2025 4:30pm - 5:30pm EDT
Inman
  Technical Session, Performance Monitoring and Troubleshooting

4:30pm EDT

F5 | Db2 On–prem to Cloud Transformation Journey
Monday June 9, 2025 4:30pm - 5:30pm EDT
University
This presentation explores the process of moving Db2 databases from on–premises environments to the cloud, focusing on AWS, Azure, and GCP. For AWS, both EC2 and RDS solutions are discussed. This presentation even covers HA and DR solutions on–cloud.
Speakers
avatar for Mohankumar Saraswatipura

Mohankumar Saraswatipura

Senior Consultant - Data and AI, DBA Automation
Mohankumar (Mohan) Saraswatipura works as a Senior Consultant - Data and AI at DBA Automation Corp., focusing on IBM Db2, Linux, UNIX, and Windows, Data Replication (Q Rep, CDC, HVR, Qlik, and Golden Gate) solutions. Prior to his current position, he worked as a Database Solutions... Read More →
Monday June 9, 2025 4:30pm - 5:30pm EDT
University
  Technical Session, Cloud Warehouse and Data Lakes

5:30pm EDT

IDUG Expo Grand Opening & Welcome Reception
Monday June 9, 2025 5:30pm - 7:00pm EDT
Monday June 9, 2025 5:30pm - 7:00pm EDT
  IDUG Reception
 
Tuesday, June 10
 

7:00am EDT

Breakfast On Your Own
Tuesday June 10, 2025 7:00am - 9:00am EDT
Tuesday June 10, 2025 7:00am - 9:00am EDT
  Breakfast

8:00am EDT

Registration Available
Tuesday June 10, 2025 8:00am - 5:00pm EDT
International Tower Lobby
Tuesday June 10, 2025 8:00am - 5:00pm EDT
International Tower Lobby
  Registration

8:30am EDT

IDUG Db2 for LUW Essentials Course
Tuesday June 10, 2025 8:30am - 5:00pm EDT
Edgewood
This 3.5-day foundational course introduces the essentials of Db2 12.1 for relational DBAs, covering architecture, installation, configuration, and basic database management. It then builds on these core essentials with topics such as data movement, backup and recovery, and routine maintenance to ensure performance and integrity.  Designed for new and transitioning DBAs, the course emphasizes hands-on learning with minimal prerequisites beyond basic SQL and database knowledge.

Note: There is no certification for the foundational course, but students can take a proctored quiz after the class to obtain the badge.

Tuesday June 10, 2025 8:30am - 5:00pm EDT
Edgewood
  IDUG Essentials

8:30am EDT

IDUG Db2 for z/OS Essentials Course
Tuesday June 10, 2025 8:30am - 5:00pm EDT
Auburn
This 3-day course will expose the beginning z/OS DBAs (Database Administrators) to the essentials of Database Administration for a Db2 13 for z/OS. This course will teach the students how to physically implement a logical database design using DDL and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

Note: This course does not prepare the novice to pass the exam.

Tuesday June 10, 2025 8:30am - 5:00pm EDT
Auburn
  IDUG Essentials

9:00am EDT

K2 | Unveil Db2's Hidden Treasures, Presented by Broadcom
Tuesday June 10, 2025 9:00am - 10:00am EDT
International Ballroom
Embark on an extraordinary expedition to uncover the hidden treasures of Db2! Join DBAs, developers, system programmers, architects, and Db2 enthusiasts as we explore the essential knowledge and skills needed to empower the next generation of mainframe users. Together, we'll reveal the secrets to enhancing platform success and bridging the experience gap. Prepare to inspire and equip future adventurers in the world of Db2, ensuring that its treasures are preserved for generations to come!

Speakers
avatar for Greg Lotko

Greg Lotko

Senior Vice President and General Manager, Broadcom Mainframe Software Division
Greg Lotko is SVP and General Manager for Broadcom’s Mainframe business unit. A passionate leader, Greg’s customer-first approach has helped countless organizations drive business and technical success resulting in lasting customer relationships. Currently, Greg is responsible... Read More →
Tuesday June 10, 2025 9:00am - 10:00am EDT
International Ballroom
  Main Stage Event

10:00am EDT

Networking & Coffee Break
Tuesday June 10, 2025 10:00am - 10:20am EDT
International Ballroom
Tuesday June 10, 2025 10:00am - 10:20am EDT
International Ballroom
  Coffee Break

10:20am EDT

A6 | Pedal to The Metal – This is Not your Daddy's Accelerator!
Tuesday June 10, 2025 10:20am - 11:20am EDT
Piedmont
The IBM Db2 Analytics Accelerator for z/OS(IDAA) has evolved enormously over the last 14 years since its introduction to the DB2 for z/OS world with the result that the IDAA of 2025 is a completely different proposition to customers compared to when it was originally presented to the market back in 2011.
As with many new functions and features of Db2 introduced over the years, it was not love at first with the IDAA, however, it is no longer a stand–alone Netezza appliance with periodic refreshes, limited SQL compatibility and limited use cases.  It is in fact a completely different hardware and software solution with multiple deployment options from IFLs on Z, a z/Linux One machine or even in cloud and it is also a completely new software based on the columnar DB2 BLU DW engine.
What this means for customers is that the IDAA of 2025 with lots more functionality and flexibility has become an extremely interesting and feasible solution to the many challenges that customers are facing from classical Analytical applications to Batch processing and OLTP transactions requiring analytical queries on real–time data.
This presentation will provide a brief overview of the changes to IDAA since its introduction explaining what and how these changes make the IDAA a completely different proposition for customers in 2025.
More importantly, the presentation will provide a technical explanation of how you can perform an assessment of your environment to be able to evaluate the potential benefits of IDAA in your shop, or, if you already have an IDAA, how you can identify new candidates for IDAA processing.
Finally, the presentation will provide tips and insights from real–world use cases highlighting not only the benefits but also the errors to avoid and the potential problems that you may encounter when offloading work to IDAA.
Speakers
avatar for Adrian Collett

Adrian Collett

Consultant, Expertise4it s.r.l.
Adrian is a partner and Senior DB2 Specialist for Expertise4IT S.r.l. based in Milan, Italy.  Although specialising in System and Application Performance Tuning, Adrian has been involved in all aspects of DB2 for z/OS: from Systems Analysis, Data Modelling and Database Design to... Read More →
Tuesday June 10, 2025 10:20am - 11:20am EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

10:20am EDT

B6 | Unlocking Insights: Leveraging IBM DB2 and AWS SageMaker for Machine Learning
Tuesday June 10, 2025 10:20am - 11:20am EDT
Roswell
In today's data–driven world, the integration of robust database management systems with advanced machine learning platforms is crucial for deriving actionable insights and driving innovation. This presentation explores the synergy between IBM DB2 and AWS SageMaker, highlighting how this powerful combination can enhance data analytics and machine learning workflows.
IBM DB2, a highly scalable and reliable relational database management system, offers comprehensive data management capabilities. When integrated with AWS SageMaker, a fully managed service that provides every developer and data scientist with the ability to build, train, and deploy machine learning models quickly, the potential for data–driven decision–making is significantly amplified.
This session will cover:
The architecture and key features of IBM DB2 and AWS SageMaker.
Best practices for integrating DB2 with SageMaker to streamline data preprocessing, model training, and deployment.
Real–world use cases demonstrating the benefits of this integration in various industries.
Attendees will gain a comprehensive understanding of how to leverage the strengths of both DB2 and SageMaker to enhance their data analytics and machine learning capabilities, ultimately driving more informed and strategic business decisions.
Speakers
DM
Tuesday June 10, 2025 10:20am - 11:20am EDT
Roswell
  Technical Session, AI Data Mining and ML

10:20am EDT

C6 | DB2 LUW PureScale – Custom Disaster Recovery Configuration
Tuesday June 10, 2025 10:20am - 11:20am EDT
Spring
IBM provides us number of solution to achieve multisite HA/DR for PureScale clusters. Those include technologies like HADR Replication for PureScale Clusters, Geographically Dispersed PureScale Clusters, GPFS replication for PureScale Clusters, Q Replication for PureScale Clusters.
 In the presentation we will describe alternative approach, where replication across 2 sites is provided by Storage Array Layer, which allows us to achieve additional benefits like consistency groups going beyond single GPFS filesystem used by the PureScale, optimized network utilization where Storage Array replication happens on SAN Fiber, additional HA layer where filesystem can be cross mounted across sites which gives additional redundancy layer for storage availability.
  
 We implement solution by deploying Synchronic Storage Replication across 2 sites, where SAN fabric provides us NSD multi path connections from each side. This way on each side we have collection of NSD disks that are local to given side, and also connection to remote NSD disks from DR side. On both sites we install standalone PureScale clusters, independent from each, therefore failure of any of those clusters does not impact other side counterpart. Having 2 clusters we designate one as primary by creating PureScale managed GPFS on top of Storage Array Layer, and on top of that create Database with its' associated paths. Next we use gpfssync capabilities to export primary GPFS filesystem , and next mount the same on DR site. This allows us to mimic primary cluster on DR site, and next attach those synchronized mount points to TSAMP cluster on secondary site. Later on, we just move application connection to DR site, which can handle further ongoing workloads.
  
 Proposed solution is active–passive deployment, when at any given time only one cluster has connection to synchronized storage array. We achieve this by protections on each layer (NSD disks active on one site only, GPFS mounts online on one site only, database cataloging on one site only). This is crucial to ensure only one side has active writes to the cluster, so that we prevent any corruption of the data. In the presentation we provide procedures to setup such deployment, along with failover procedures where we move storage attachment from primary to secondary, and reverse. We also provide testing results where we verify solution, by forcing failover and more failure scenarios while processing application workload.
Speakers
avatar for Mateusz Ksiazek

Mateusz Ksiazek

IT Expert, PKO BP
Technical Leader in mainframe modernization project - Cross platform monitoring design & performance analysis(mainframe/distributed) - Application migration to distributed env - Dr architecture for cross platform env - TroubleshootingDB2 system AdministratorDB2 performance monitoring... Read More →
MB

Marcin Baster

Senior Manager, IBM Software Support - Db2, IBM
Tuesday June 10, 2025 10:20am - 11:20am EDT
Spring
  Technical Session, Backup Recovery & Data Movement

10:20am EDT

D6 | A 50–Cent Tour of Db2
Tuesday June 10, 2025 10:20am - 11:20am EDT
Techwood
With fewer schools teaching DB2 for z/OS, it often falls on the DBAs to provide instruction for the programming staff. This is a very basic introduction to DB2 concepts and vocabulary, aimed at the novice user of DB2, or anyone who must train novice users.
Speakers
MM

Mark McNary

DBA 3, UMB Bank n. a.
Mark McNary has been using DB2 since 1989 as a programmer and later as a DBA. He is currently the lead DB2 DBA for UMB Bank in Kansas City MO. This company is currently in the process of converting many of their legacy systems from VSAM to DB2, and getting the existing staff up to... Read More →
Tuesday June 10, 2025 10:20am - 11:20am EDT
Techwood
  Technical Session, Database Practices

10:20am EDT

E6 | Db2 for z/OS Utilities – Best Practices for Maximizing Availability and Performance
Tuesday June 10, 2025 10:20am - 11:20am EDT
Inman
This session provides an indepth overview of the best practices in running Db2 for z/OS Utiliites.  We will discuss various tips and recommendations on how to minimize application impacts and optimizing utility performance for each of the core utilities, using the latest functionalities delivered in Db2 13 up to level FL506.
Speakers
avatar for Ka Chun Ng

Ka Chun Ng

Db2 for z/OS Development, IBM
Ka Chun Ng is a Senior Technical Staff Member in Db2 for z/OS based at the IBM Silicon Valley Laboratory in San Jose, California.  He is the technical lead for Db2 Utilities and has over 20 years of experience in the design, development and service work in Db2 for z/OS, focusing... Read More →
Tuesday June 10, 2025 10:20am - 11:20am EDT
Inman
  Technical Session, Db2 Solutions Utilities and Tools

10:20am EDT

F6 | So Your Auditors Really Want to Know What is Happening In a Database
Tuesday June 10, 2025 10:20am - 11:20am EDT
University
In these days of heightened security, it is likely that you will be asked about Db2’s audit facility, db2audit. This tool has the ability to collect a number of types of security information and this presentation will show how to configure and use db2audit. dbaudit can collect massive amounts of data but there are ways to limit the data and those techniques will be shown in the presentation.
Speakers
avatar for Paul Turpin

Paul Turpin

Group Technology Manager, Truist
Paul Turpin manages a database engineering team for a financial services company. He specializes in Db2 for LUW on large systems, along with other DBMS like PostgreSQL, Neo4j and MongoDB. He enjoys exploring new features and functionality in Db2. He has spoken at IDUG North America... Read More →
Tuesday June 10, 2025 10:20am - 11:20am EDT
University
  Technical Session, Security Compliance and Governance

10:30am EDT

Badging at IDUG
Tuesday June 10, 2025 10:30am - 12:00pm EDT
Fairlie
Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information: 
  • First & Last Name: 
  • Email Address: 
  • Exam Choice: 
  • Day & Time Choice: 
Exam choices include: 
  • Db2 11.5 Foundations Exam 
  • Db2 11.5 Administration Exam 
  • Db2 11.5 Advanced Database Resilience Exam 
  • Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
  • Db2 12.1 Foundations Exam * NEW * 
  • Db2 12.1 Administration Exam * NEW * 

IMPORTANT NOTES: No walk-ins. You must book in advance and you will receive  a confirmation once you are officially booked. This is a Bring Your Own Device  exam. Photo ID will be required at exam time. 
Tuesday June 10, 2025 10:30am - 12:00pm EDT
Fairlie
  Badging & Certification

11:30am EDT

A7 | Db2 13 Utilities History – What is It and How to Use
Tuesday June 10, 2025 11:30am - 12:30pm EDT
Piedmont
Db2 13 introduced the ability to track execution of IBM Db2 utilities allowing users to gain insight into the performance of the utilities. In this session you will hear how it has been implemented, what information is recorded and when, and some ideas of how the feature can be used to improve your utility processing.
Speakers
avatar for Tom Crocker

Tom Crocker

Senior Solution Advisor, Rocket Software
Tom Crocker is a Senior Solution advisor working with IBM Db2 Tools for z/OS, and has been working with Db2 since v1.2. He specialises in Db2 administration and mainframe modernisation, working with customers across the globe to provide solutions and to enable them to get the best... Read More →
Tuesday June 10, 2025 11:30am - 12:30pm EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

11:30am EDT

B7 | Diamonds are Forever – Real–World SQL Data Insight Experiences
Tuesday June 10, 2025 11:30am - 12:30pm EDT
Roswell
Join me on a journey through our first year of deploying SQL Data Insights (SDI) into production. Discover how SDI impacted our business processes, changed stakeholder perceptions of the mainframe, and enhanced our approach to data analysis.
We will start with a review of our first use case and discuss the resources consumed for training and scoring, as well as the impact SDI had on our business processes. 
SDI's most evident benefit is its ability to analyze data where it sits without having to export, transfer and reload it, and with minimal data science dependency. But how does it compare to more traditional approaches? To answer that, we'll compare SDI with other machine learning algorithms by applying them to a frequently used dataset for predicting diamond prices. We'll delve into the accuracy of the algorithms and see how SDI stacks up against data scientists' most loved algorithms.
Following that, we'll explore a brand–new use case that applies the new commonality–function in Db2 FL504. We'll discuss its usefulness, resource requirements, and potential impact on business processes, providing more practical insights into the power of SDI.
And finally, I'll share a use case that demonstrates how to identify outliers using SDI with Db2 monitoring data, ready to be applied in your own shop. 
Don't miss this opportunity to gain practical insights into the power of SDI and how it can transform your data analysis!
Speakers
avatar for Thomas Baumann

Thomas Baumann

Data Evangelist, Swiss Mobiliar
Computer scientist by training, data scientist by practice, query tuner by spirit. Thomas is a fast learner with lots of curiosity, passionate about investigating mechanisms, causes and outcomes.  Currently, his position is Data Evangelist at Swiss Mobiliar in Bern, Switzerland... Read More →
Tuesday June 10, 2025 11:30am - 12:30pm EDT
Roswell
  Technical Session, AI Data Mining and ML

11:30am EDT

C7 | Db2 Advanced Log Space Management – Unleashed
Tuesday June 10, 2025 11:30am - 12:30pm EDT
Spring
Trying to figure out the ins and outs of Db2 Log Space Management?  Spent too much time trying to figure out what settings are best for your environment?  With the introduction of Advanced Log Space Management the time has come to unleash it's potential.  Fully supported, the journey has begun in making log space management more autonomic.  This presentation will introduce you to some of the concepts and principles behind it all.  We will do a deep dive into the technology and transformation behind making log space management more hands off, which in the end will make life simple for you and your organization.
Speakers
avatar for Michael Roecken

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 →
Tuesday June 10, 2025 11:30am - 12:30pm EDT
Spring
  Technical Session, Backup Recovery & Data Movement

11:30am EDT

D7 | DIY Db2 z/OS Administration Solutions
Tuesday June 10, 2025 11:30am - 12:30pm EDT
Techwood
This presentation will review DBA solutions that have been developed and implemented to enhance the administration of Db2 Z/OS systems.  These solutions have been implemented   at Navy Federal Credit Union with Db2 V12 and V13 mission critical applications.  Db2 features such as SQL to review object usage, real–time statistics, utility history, package binds, Db2 health, dynamic query management and utility template generation will be discussed.
Speakers
avatar for Steven Loesch
Tuesday June 10, 2025 11:30am - 12:30pm EDT
Techwood
  Technical Session, Database Practices

11:30am EDT

E7 | Explain EXPLAIN
Tuesday June 10, 2025 11:30am - 12:30pm EDT
Inman
There are many sessions about the EXPLAIN facility in Db2 LUW, but they all lack the concise statements to find the right SQL queries, set everything up, do the EXPLAIN and draw the right conclusions by examples and working statements to copy–and–paste.
This is a back–to–basics session, enhanced with experiences from real situations and best practices.
The material was used for internal training of colleagues.
Speakers
avatar for Roland Schock

Roland Schock

Principal, tasdevil Consulting
Roland is installing, using and tuning Db2 on distributed since 1993 or Version 2.1 for OS/2. After working for 25+ years for ARS Computer und Consulting GmbH as a Db2 expert he is now an independent consultant.His expertise and engagement for the community allowed him to become IBM... Read More →
Tuesday June 10, 2025 11:30am - 12:30pm EDT
Inman
  Technical Session, Db2 Solutions Utilities and Tools

11:30am EDT

F7 | How to Hack Db2 for z/OS – Lessons Learned from Mainframe Hackers
Tuesday June 10, 2025 11:30am - 12:30pm EDT
University
Mainframe is often perceived as the most secure platform in the world. However, the reality is that it is as secure as you make it. A group of well–known mainframe hackers shared their experience and lessons learned from the field. Specifically, they publicly showed the most common attack vectors for the mainframe. In this presentation, we will review their findings and see how these techniques can apply to Db2 for z/OS.
Speakers
avatar for Emil Kotrc

Emil Kotrc

Software architect, Broadcom
Emil is an experienced Principal Software Architect with a demonstrated history of working in the computer software industry. Skilled in IBM Db2, Agile Methodologies, Databases, and IBM Mainframe. Strong engineering professional with a Ph.D. focused in Mathematical engineering from... Read More →
Tuesday June 10, 2025 11:30am - 12:30pm EDT
University
  Technical Session, Security Compliance and Governance

12:30pm EDT

Lunch
Tuesday June 10, 2025 12:30pm - 2:00pm EDT
International Ballroom
Tuesday June 10, 2025 12:30pm - 2:00pm EDT
International Ballroom
  Lunch

2:00pm EDT

A8 | IBM z Hardware Synergy with Db2 for z/OS Performance Improvement
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Piedmont
The IBM z platform synergizes with Db2 for z/OS to deliver numerous performance improvements. This session explores key enhancements that optimize system efficiency and reliability when migrating from z14 to z16. It will highlight areas such as CPU Improvement through enhanced memory and zIIP processor utilization, System Recovery Boost, focusing on Middleware Region Start/Restart, and IBM Integrated Accelerator for Z Sort . This session will also cover tools and best practices for monitoring memory usage and zIIP processor performance.
Speakers
LP

Lethika Panicker

IT Architect Consultant, FIS
Over 20 years of experience in Db2 for z/OS systems programmer which includes installation, maintenance, capacity planning, performance and tuning of Db2 for z/OS through version 13 in a high availability data sharing environment. Expert level skills in Db2 systems programming, capacity... Read More →
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

2:00pm EDT

B8 | IBM Db2 for AI: Building AI Systems with Db2
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Roswell
Relational databases serve as the primary data source for enterprise AI projects. Traditionally, when an AI project requires data from a relational database, engineers duplicate the data onto a separate system for model development and inference. However, this duplication process presents various challenges, including network latency, complex data governance, and the need for multiple APIs. These challenges often impede the successful implementation of AI models in production for many enterprise projects. To address these obstacles, IBM Db2 offers in–database AI capabilities and external tools. With Db2, ML practitioners can create and deploy AI models directly within their databases, significantly simplifying the complexities of AI pipelines. By leveraging in–db AI features, enterprises can safeguard sensitive data, expedite inferencing processes, and seamlessly integrate AI models with downstream business applications. In this talk, I will present the AI capabilities and tools provided by Db2. I will showcase how these capabilities can be effectively utilized in upcoming AI projects, demonstrating their potential to transform enterprise AI implementations.
Speakers
avatar for Shaikh Quader

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 →
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Roswell
  Technical Session, AI Data Mining and ML

2:00pm EDT

C8 | Supercharge Db2 Utilities: Uncover More Features
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Spring
Join this session to gain insights on best proactices for using Broadcom Db2 utilities and explore traditional and emerging use cases, such as intelligent housekeeping, DevOps, test data management, and recovery compliance. You will learn how to get the most value out of the technology you have in your hands.
Speakers
avatar for Denis Tronin

Denis Tronin

Product manager, Broadcom
Denis Tronin is an experienced IT professional and product manager, skilled in mainframe technologies (Db2 for z/OS, system performance, workload automation), API management (Zowe API Mediation Layer), and DevOps. He is an IBM Champion and a frequent speaker at major industry con... Read More →
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Spring
  Technical Session, Backup Recovery & Data Movement

2:00pm EDT

D8 | My All–Time Db2 Top Ten Lists
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Techwood
Over the years I have written about and presented various Top 10 lists related to Db2, database performance, and database administration. Each Top 10 list stands on its own about a specific topic. This presentation will deliver my all–time favorite Top 10 lists. The lists have been honed and modified over time –– and I will even have a few brand new lists to present for the first time ever.
Whether you are new to Db2, or a long–time practitioner, there will be something here for you!
Speakers
avatar for Craig Mullins

Craig Mullins

President & Principal Consultant, Mullins Consulting, Inc.
Craig is president & principal consultant of Mullins Consulting, Inc. and an in-demand analyst, author and speaker. He has over three decades of experience in all facets of database systems development. Craig has worked with Db2 on the mainframe since Version 1 and has experience... Read More →
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Techwood
  Technical Session, Database Practices

2:00pm EDT

E8 | BMC Db2 AMI Utilities To The Rescue – What's New !!
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Inman
Quickly and Easily solve your most demanding Db2 utility challenges using the latest capabilites available in the BMC AMI Db2 utilities. This presentation covers the latest enhnacements in the BMC utilities for Db2 zOS. Come learn how BMC customers solve their hardest operational problems every day using the Db2 utilities from BMC. Gain deep insights on the advanced performance, useability and automation features available today in the BMC Db2 Utilities that set us apart from the competion.
Speakers
avatar for Michael Cotignola

Michael Cotignola

Db2 Solution Engineer, BMC Software
Michael Cotignola is a Principal Software Consultant supporting BMC's DB2 Mainframe Solutions.  In this role, he helps his clients maximize the value they receive from BMC's DB2 products.  Michael has worked in IT since 1975 in numerous IT disciplines, including operations, application... Read More →
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Inman
  Technical Session, Db2 Solutions Utilities and Tools

2:00pm EDT

F8 | Db2 Audit and Audit Exceptions with SAP
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
University
Prior to Db2 12.1, with Db2 audit enabled for the database using the db2audit facility, an unsustainably large amount of audit data is generated which has an impact on the general database performance, I/O, and space. This is especially true for the “execute” category of Db2 auditing. Almost all the data is generated by the SAP application and the SAP database connect user. Unfortunately, the db2audit facility provides very little in terms of application context that comes from the SAP system such as SAP logon user, reports, and so on.
On the other hand, there are SAP–level auditing functions and auditing within the SAP system which can provide application–related details.
However, auditing on SAP application level has its limits: You cannot audit statements that execute directly against the database and that come from outside the local ABAP stack.With Db2 12.1, the Db2 audit facility has been enhanced to overcome the above–mentioned limitation. Generally, the database data should only be accessed in a trusted way from the SAP application through the SAP database connect user, and all other connections to the database should be audited.
As of Db2 12.1, you can exclude auditing for connections originating from the local SAP application by the SAP connect user. This reduces the amount of audit data generated by the Db2 audit facility to something more manageable.
Speakers
DV
avatar for Thomas Rech

Thomas Rech

Senior IT Architect - DB2 SAP Development, IBM
Thomas has been working in the Db2 area since 1996. Starting as a Db2 course instructor, he soon moved to the SAP on Db2 environment in 1997. He joined the SAP/IBM Db2 Development Team, followed by a role as technical sales consultant. He led several lighthouse projects like the first... Read More →
Tuesday June 10, 2025 2:00pm - 3:00pm EDT
University
  Technical Session, Security Compliance and Governance

2:00pm EDT

Badging at IDUG
Tuesday June 10, 2025 2:00pm - 3:30pm EDT
Fairlie
Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information: 
  • First & Last Name: 
  • Email Address: 
  • Exam Choice: 
  • Day & Time Choice: 
Exam choices include: 
  • Db2 11.5 Foundations Exam 
  • Db2 11.5 Administration Exam 
  • Db2 11.5 Advanced Database Resilience Exam 
  • Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
  • Db2 12.1 Foundations Exam * NEW * 
  • Db2 12.1 Administration Exam * NEW * 

IMPORTANT NOTES: No walk-ins. You must book in advance and you will receive  a confirmation once you are officially booked. This is a Bring Your Own Device  exam. Photo ID will be required at exam time. 
Tuesday June 10, 2025 2:00pm - 3:30pm EDT
Fairlie
  Badging & Certification

3:00pm EDT

Networking & Coffee Break
Tuesday June 10, 2025 3:00pm - 3:20pm EDT
International Ballroom
Tuesday June 10, 2025 3:00pm - 3:20pm EDT
International Ballroom
  Coffee Break

3:20pm EDT

PSP1 | Db2 Strategy & Business Update
Tuesday June 10, 2025 3:20pm - 4:20pm EDT
Piedmont
Join the product management leadership to get an update on the Db2 business and the overall investment strategy we have in place for Db2 as we now deliver our first big new version in 5 years with Db2 12.1
Speakers
avatar for Miran Badzak

Miran Badzak

Program Director, Databases, IBM
Miran Badzak is the Program Director running the IBM Db2, Db2 Warehouse and Informix portfolio of businesses. His mission is simple: establish and maintain IBM’s dominance in the databases market. Miran has held various roles since joining IBM in 2007, launching several cloud services... Read More →
Tuesday June 10, 2025 3:20pm - 4:20pm EDT
Piedmont
  Partner-Sponsored Presentation

3:20pm EDT

PSP2 | Db2 Analytics Accelerator V8 – What is new with the new release and z17
Tuesday June 10, 2025 3:20pm - 4:20pm EDT
Roswell
Join the product management to get an update on the new version of Db2 Analytics Accelerator V8 in detail. Learn about Accelerator-to-Accelerator Copy, New Performance Warehouse and more. Learn about new and latest member of IBM Z family, z17 & LinuxONE. How it makes a difference with Db2 Analytics Accelerator.
Speakers
avatar for Cuneyt Goksu

Cuneyt Goksu

Executive IT Specialist, IBM
Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, bachelor’s degree and PhD in Computer Science. He has been working with Db2 for z/OS and IBM Z... Read More →
Tuesday June 10, 2025 3:20pm - 4:20pm EDT
Roswell
  Partner-Sponsored Presentation

3:20pm EDT

PSP3 | Db2 Treasure Hunt: Unearthing Essential Maintenance Tips for DBAs
Tuesday June 10, 2025 3:20pm - 4:20pm EDT
Spring
Join our treasure hunt to uncover vital tips and tricks for maximizing your investment in Broadcom tools! In this session, discover effective strategies for managing deprecated objects, navigating UTS conversions, and ensuring recovery compliance. Equip yourself with practical tools to tackle immediate challenges and enhance your Db2 subsystem performance. With real-world case studies to guide you, you'll leave with actionable insights ready for immediate implementation. Don’t miss this opportunity to elevate your Db2 maintenance approach!
Speakers
avatar for Tony Andrews

Tony Andrews

Mainframe Developer/Trainer, P+T Solutions, Inc.
Tony Andrews has more than 30 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs... Read More →
avatar for Steen Rasmussen

Steen Rasmussen

Customer Services Consultant, Broadcom
Steen Rasmussen is a Principal Engineering Services Architect currently instrumental in the ongoing development and support of the Broadcom Db2 tools. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark working with all aspects of DB2 - like tuning, application... Read More →
Tuesday June 10, 2025 3:20pm - 4:20pm EDT
Spring
  Partner-Sponsored Presentation

4:00pm EDT

Badging at IDUG
Tuesday June 10, 2025 4:00pm - 5:30pm EDT
Fairlie
Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information: 
  • First & Last Name: 
  • Email Address: 
  • Exam Choice: 
  • Day & Time Choice: 
Exam choices include: 
  • Db2 11.5 Foundations Exam 
  • Db2 11.5 Administration Exam 
  • Db2 11.5 Advanced Database Resilience Exam 
  • Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
  • Db2 12.1 Foundations Exam * NEW * 
  • Db2 12.1 Administration Exam * NEW * 

IMPORTANT NOTES: No walk-ins. You must book in advance and you will receive  a confirmation once you are officially booked. This is a Bring Your Own Device  exam. Photo ID will be required at exam time. 
Tuesday June 10, 2025 4:00pm - 5:30pm EDT
Fairlie
  Badging & Certification

4:30pm EDT

A9 | Db2 for z/OS all new "2025 SWAT Tales"
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Piedmont
The session will concentrate on new SWAT team experiences. Various unexpected outcomes and behaviors will be discussed as well has hot technical items customers are exploiting as well as technologies that have been challenging for customers. The complete session will be focused on customer experiences and sharing real life outcomes.
 
The hot topcis and customer interested are new subjects, topics and technologies that are experienced by the Db2 SWAT team updated for last 12 months of hot topics
Speakers
avatar for Anthony Ciabattoni

Anthony Ciabattoni

Db2 for z/OS SWAT Team Leader, IBM
Anthony Ciabattoni is an IBM Certified Executive IT specialist and the leader of the Db2 for z/OS World-Wide SWAT team based out of the Silicon Valley Lab with over 32 years of working directly with Db2 for z/OS. His experience includes being a customer lead Db2 architect as well... Read More →
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

4:30pm EDT

B9 | Bridging the Db2 for z/OS Skill Gap with Generative AI
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Roswell
Generative AI presents a transformative opportunity to address the knowledge and skill gap in mainframe environments, particularly for Db2 for z/OS. By leveraging large language models (LLM) and Retrieval–Augmented Generation (RAG) patterns, organizations can create intelligent systems that make mainframe expertise more accessible and actionable. When integrated with automation frameworks, these solutions not only simplify complex workflows for early tenure DBAs —reducing the steep learning curve—but also enable experienced DBAs to focus on strategic, high–value tasks. This session explores how generative AI can be applied to enhance mainframe productivity, preserve institutional knowledge, and create a scalable foundation for skills development across diverse user groups.
Speakers
YC
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Roswell
  Technical Session, AI Data Mining and ML

4:30pm EDT

C9 | HADR – How and Where to Start
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Spring
This session is meant to be a HADR beginners session (101. back to basics, however you want to call it). Showing what HADR is, how it works in general and how you get it started. Additionally I'll explain the most common configuration parameters, their purpose and possible trip wires on the way to a running HA cluster.
This session will NOT cover any cluster autmation like TSA or Pacemaker.
Speakers
avatar for Sebastian Zok

Sebastian Zok

Senior Database Administrator, Cancom Managed Services GmbH
Sebastian got a diploma in IT in 2007 and started first in software development. He worked on Db2 performance monitoring and switched to Db2 consultancy shortly after. He is working with Db2 LUW since version 7. Currently Sebastian is working for an IT provider as Senior Db2 DBA administering... Read More →
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Spring
  Technical Session, Backup Recovery & Data Movement

4:30pm EDT

D9 | Mastering Access Path Management in Db2 for z/OS: Simplify, Optimize, Succeed
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Techwood
The access path chosen by Db2 has a major impact on SQL performance and overall application efficiency. This session offers a quick refresher on access path fundamentals and focuses on best practices for managing access paths across the application lifecycle to ensure stable workload performance. Discover key strategies to keep your applications running smoothly and efficiently.
Speakers
avatar for Denis Tronin

Denis Tronin

Product manager, Broadcom
Denis Tronin is an experienced IT professional and product manager, skilled in mainframe technologies (Db2 for z/OS, system performance, workload automation), API management (Zowe API Mediation Layer), and DevOps. He is an IBM Champion and a frequent speaker at major industry con... Read More →
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Techwood
  Technical Session, Database Practices

4:30pm EDT

E9 | Db2 Automatic Statistics Deep Dive
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Inman
Accurate catalog statistics are the lifeblood of the Db2 query optimizer. Db2 has had automatics statistics support since version 8.2 and real–time statistics were introduced in version 9.5. Automatic statistics collection is enabled by default for new databases and is the recommend best practice. So if you are still hesitant to use them, attend this session to gain a deeper understanding of how they work and why you can trust them to simplify your DB administration and improve overall query performance. In addition to providing details on the automatic statistics architecture, this presentation will provide details on ways to monitor and control automatic statistics collection so that it works well for any type of Db2 system.
Speakers
avatar for John Hornibrook

John Hornibrook

Senior Technical Staff Member, IBM
John is a Senior Technical Staff Member responsible for relational database query optimization on IBM's distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator... Read More →
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Inman
  Technical Session, Db2 Solutions Utilities and Tools

4:30pm EDT

F9 | Modernizing your Security Posture around Db2 z/OS Data
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
University
When we talk about Mainframe Modernization, we usually discuss DevOps, Zowe, APIs, Java, Python, etc, but how often does anyone talk about how your security posture needs to be modernized?  Many of these systems were built 30–40 years ago when it was just batch, IMS and CICS.  Now we have traffic coming in from everywhere, whether it is via APIs, distributed Db2, or other means, you need to make sure you are prepared to monitor that traffic to prevent DDoS attacks, and make sure nobody is getting at your most sensitive data.  I will discuss some of the core Db2 Security features that companies should consider using along with Data Access Monitors like Guardium.
Speakers
avatar for Greg DeBo

Greg DeBo

Principal Consultant, Team SWAMI
Greg is an experienced Database Specialist with a demonstrated history of working on Mainframe technology for 34 years in one of the largest mainframe shops in the United States. During his career his roles included Application Programming in COBOL and PL/1, IMS DBA, Db2 DBA, as well... Read More →
GC

Gayathiri Chandran

Technical Lead, IBM
Gayathiri Chandran is a Senior Software Engineer in Db2 for z/OS development at IBM Silicon Valley Laboratory. She is the technical lead for Db2 for z/OS Security and drives the strategy, design and development of security functions. She speaks on the Db2 security topics at various... Read More →
Tuesday June 10, 2025 4:30pm - 5:30pm EDT
University
  Technical Session, Security Compliance and Governance

5:30pm EDT

IDUG Evening Reception
Tuesday June 10, 2025 5:30pm - 7:00pm EDT
Tuesday June 10, 2025 5:30pm - 7:00pm EDT
  IDUG Reception

7:30pm EDT

A Night Out with Broadcom | Details coming soon!
Tuesday June 10, 2025 7:30pm - 10:00pm EDT
Tuesday June 10, 2025 7:30pm - 10:00pm EDT
  Evening Event
 
Wednesday, June 11
 

7:00am EDT

Breakfast On Your Own
Wednesday June 11, 2025 7:00am - 9:00am EDT
Wednesday June 11, 2025 7:00am - 9:00am EDT
  Breakfast

8:00am EDT

Registration Available
Wednesday June 11, 2025 8:00am - 5:00pm EDT
International Tower Lobby
Wednesday June 11, 2025 8:00am - 5:00pm EDT
International Tower Lobby
  Registration

8:30am EDT

IDUG Db2 for LUW Essentials Course
Wednesday June 11, 2025 8:30am - 5:00pm EDT
Edgewood
This 3.5-day foundational course introduces the essentials of Db2 12.1 for relational DBAs, covering architecture, installation, configuration, and basic database management. It then builds on these core essentials with topics such as data movement, backup and recovery, and routine maintenance to ensure performance and integrity.  Designed for new and transitioning DBAs, the course emphasizes hands-on learning with minimal prerequisites beyond basic SQL and database knowledge.

Note: There is no certification for the foundational course, but students can take a proctored quiz after the class to obtain the badge.

Wednesday June 11, 2025 8:30am - 5:00pm EDT
Edgewood
  IDUG Essentials

8:30am EDT

IDUG Db2 for z/OS Essentials Course
Wednesday June 11, 2025 8:30am - 5:00pm EDT
Auburn
This 3-day course will expose the beginning z/OS DBAs (Database Administrators) to the essentials of Database Administration for a Db2 13 for z/OS. This course will teach the students how to physically implement a logical database design using DDL and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

Note: This course does not prepare the novice to pass the exam.

Wednesday June 11, 2025 8:30am - 5:00pm EDT
Auburn
  IDUG Essentials

9:00am EDT

K3 | IDUG WIT | The Trailblazer: Harnessing the Power of Adaptability, Innovation, and Resilience, Sponsored by Broadcom
Wednesday June 11, 2025 9:00am - 10:00am EDT
International Ballroom
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.
Speakers
avatar for Jennifer Pharr Davis

Jennifer Pharr Davis

Jennifer Pharr Davis is an internationally recognized speaker, author of Becoming Odyssa, and award-winning entrepreneur. She has covered more than 14,000 miles of trails across six continents. In 2011, Jennifer set the overall fastest known time on the Appalachian Trail, completing... Read More →
Wednesday June 11, 2025 9:00am - 10:00am EDT
International Ballroom
  Main Stage Event

10:00am EDT

Networking & Coffee Break
Wednesday June 11, 2025 10:00am - 10:20am EDT
International Ballroom
Wednesday June 11, 2025 10:00am - 10:20am EDT
International Ballroom
  Coffee Break

10:20am EDT

A10 | Preparing to Pass Your Db2 for z/OS Administrator Certification Exams
Wednesday June 11, 2025 10:20am - 11:20am EDT
Piedmont
Are you looking to become a certified Db2 for z/OS Administrator? If you’re preparing for the IBM certification exams C1000–184 (Associate) or C1000–181 (Professional), this presentation is for you. We will provide essential tips and recommendations to help you kickstart your preparation journey toward becoming an IBM Db2 for z/OS Certified Administrator.
Speakers
avatar for Emil Kotrc

Emil Kotrc

Software architect, Broadcom
Emil is an experienced Principal Software Architect with a demonstrated history of working in the computer software industry. Skilled in IBM Db2, Agile Methodologies, Databases, and IBM Mainframe. Strong engineering professional with a Ph.D. focused in Mathematical engineering from... Read More →
Wednesday June 11, 2025 10:20am - 11:20am EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

10:20am EDT

B10 | Db2 pureScale v12.1 on Azure
Wednesday June 11, 2025 10:20am - 11:20am EDT
Roswell
Db2 pureScale with Pacemaker on Azure is an exciting new chapter for Db2 pureScale on Cloud platforms! The Microsoft Azure platform has both TCP/IP and RDMA private network capabilities, allowing more scale–out and scale–up opportunities for the most demanding customer workloads.
This session– walks through the deployment of a Db2 pureScale cluster on the Azure platform– examines the performance for scale up and scale out– compares the TCP/IP and RDMA platforms for cost and performance– discusses the current capabilities and some of the next areas under development
This work builds on the existing Db2 pureScale on AWS knowledge and the session will provide comparisons between the two Cloud offerings
Speakers
CG
avatar for Andrew Hilden

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 →
Wednesday June 11, 2025 10:20am - 11:20am EDT
Roswell
  Technical Session, Db2 Features Improvements and Tips LUW

10:20am EDT

C10 | Automatic Fast DB Size Reduction, NO DELETE, NO REORG, NO System Down
Wednesday June 11, 2025 10:20am - 11:20am EDT
Spring
Databases keep growing.  Many applications do not need the older data at certain age, which could vary from a few days to a few years.  Reducing the DB size can not only save storage, but also the backup/restore time, and more importantly improves the database performance, in most cases.  But, DELETE/REORG has always been a nightmare to DBAs, specially on large databases.  This presentation demonstrates a working system which purges the older data from DB2 databases, FAST (in seconds/minutes), with NO System down, NO DELETE/REORG involvement, which is pretty much independent of the database size.  The system also provides the option of old–data–archive before purging.
Speakers
avatar for Farid Hosseini

Farid Hosseini

Tech Lead Database Engineer, Freddie Mac
Farid Hosseini is a former IBMer at DB2 Lab in late 90s and early 2000s, working as a DB2 consultant for decades with multiple mission critical organizations, resolved tough issues and currently working at Freddie Mac as a Tech lead Database Engineer.
Wednesday June 11, 2025 10:20am - 11:20am EDT
Spring
  Technical Session, Operations & Automation

10:20am EDT

D10 | Db2 13 for z/OS: Using the Profile Tables to Monitor and Enforce Security Requirements for DDF Applications
Wednesday June 11, 2025 10:20am - 11:20am EDT
Techwood
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.
Speakers
avatar for Scott Walker

Scott Walker

Database Engineer - Db2 for z/OS, Navy Federal Credit Union
I started my career as a COBOL programmer in 2004. The first Db2 version I worked with was version 7. In 2011, I took my programming and database skills into the DBA role and learned more about Db2 through the administration role. In 2013 and 2017, I moved to two other companies further... Read More →
GC

Gayathiri Chandran

Technical Lead, IBM
Gayathiri Chandran is a Senior Software Engineer in Db2 for z/OS development at IBM Silicon Valley Laboratory. She is the technical lead for Db2 for z/OS Security and drives the strategy, design and development of security functions. She speaks on the Db2 security topics at various... Read More →
Wednesday June 11, 2025 10:20am - 11:20am EDT
Techwood
  Technical Session, Database Practices

10:20am EDT

E10 | “A LOB for friend. Know me a little better “
Wednesday June 11, 2025 10:20am - 11:20am EDT
Inman
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.
Speakers
avatar for Roberto Cason

Roberto Cason

Solution Engineer, BMC
About 30 year of DB2 for z/OS experience working with customers in Italy.                           Over then 25 years of experience as System programmer and DBA in an outsourcing company for Banks and Financial Institutes where he was responsible for the design, maintenance... Read More →
Wednesday June 11, 2025 10:20am - 11:20am EDT
Inman
  Technical Session, SQL App Dev and Modernization

10:20am EDT

F10 | Experiences with BLU in a Banking Environment
Wednesday June 11, 2025 10:20am - 11:20am EDT
University
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.
Speakers
KZ

Klaus Zentarra

Datamanager, Finanz Informatik GmbH & Co. KG
Klaus Zentarra worked after studying mathematics in a market research institute. He has been working at Finanz Informatik GmbH & Co KG in Münster in the data management department for more than 25 years. He specializes in database management systems and metadata reposititories.
Wednesday June 11, 2025 10:20am - 11:20am EDT
University
  Technical Session, Cloud Warehouse and Data Lakes

10:30am EDT

Badging at IDUG
Wednesday June 11, 2025 10:30am - 12:00pm EDT
Fairlie
Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information: 
  • First & Last Name: 
  • Email Address: 
  • Exam Choice: 
  • Day & Time Choice: 
Exam choices include: 
  • Db2 11.5 Foundations Exam 
  • Db2 11.5 Administration Exam 
  • Db2 11.5 Advanced Database Resilience Exam 
  • Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
  • Db2 12.1 Foundations Exam * NEW * 
  • Db2 12.1 Administration Exam * NEW * 

IMPORTANT NOTES: No walk-ins. You must book in advance and you will receive  a confirmation once you are officially booked. This is a Bring Your Own Device  exam. Photo ID will be required at exam time. 
Wednesday June 11, 2025 10:30am - 12:00pm EDT
Fairlie
  Badging & Certification

11:30am EDT

B11 | Db2 Expert Panel – LUW
Wednesday June 11, 2025 11:30am - 12:30pm EDT
Embassy B/C
Wednesday June 11, 2025 11:30am - 12:30pm EDT
Embassy B/C
  Expert Panel

11:30am EDT

A11 | Db2 Backup and Recovery Basics
Wednesday June 11, 2025 11:30am - 12:30pm EDT
Piedmont
Creating backups of and recovering your data are essential tasks performed by the IBM Db2 utilities.  This presentation will cover the basics – the different types of backups and recovery options – for the COPY, RECOVER, REBUILD INDEX, BACKUP SYSTEM, RESTORE SYSTEM utilities, and more, including a peek at new and future enhancements.
Speakers
LK
Wednesday June 11, 2025 11:30am - 12:30pm EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

11:30am EDT

C11 | Fear no Threads: Secure and Monitor Db2 Connections with Profile Tables
Wednesday June 11, 2025 11:30am - 12:30pm EDT
Spring
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.
Speakers
avatar for Toine Michielse

Toine Michielse

Manager, Client Services Consultants, Broadcom
I have been working with Db2 for z/OS ever since V1. In my career I have worked as COBOL/IMS/DB2 programmer, IMS/DB2 DBA and DB2 system engineer. I have also worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide.  Before joining Broadcom I worked at SwissRe... Read More →
Wednesday June 11, 2025 11:30am - 12:30pm EDT
Spring
  Technical Session, Operations & Automation

11:30am EDT

D11 | Isn't She aDORAble? A DBAs Guide to DORA, PCI DSS V4.0.1 and How to Survive an Audit!
Wednesday June 11, 2025 11:30am - 12:30pm EDT
Techwood
This presentation will highlight the contents of the European Union DORA (Digital Operation Resilience Act) which came into force in Janary 2025 and the PCI DSS V4.0.1 which came into force in March 2025.
Both of these are wide reaching and truly global in range! They both contain lists of things that, especially for Financial technical service providers (FINTECH), must be done on a regular basis to show that you, as a firm, are doing "Due Diligence" in the fight against "The Black Hat Brigade" who are alwasy trying to Hack, Steal or Ransom your data!
Further, this presentation will show you how to build a basic system to protect your firm, and yourself, from any Audit requirements that are currently required by both laws and also the Centre for Internet Security (CIS) rules for Db2 13 for z/OS.
Speakers
avatar for Roy Boxwell

Roy Boxwell

Senior Software Architect, Software Engineering GmbH
Roy Boxwell is an IBM Champion with more than 38 years of experience in MVS, OS/390, and z/OS environments – 37 of those in Db2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real-time database... Read More →
Wednesday June 11, 2025 11:30am - 12:30pm EDT
Techwood
  Technical Session, Database Practices

11:30am EDT

E11 | The M–Word: Why Everyone's Talking about Modernization
Wednesday June 11, 2025 11:30am - 12:30pm EDT
Inman
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.
Speakers
avatar for Chris Muncan

Chris Muncan

Lead Mainframe DBA, Sun Life
I started my career by accident opting by saying I want to learn COBOL as a fresh college graduate. Best mistake of my life.Now nearly 20 years on the mainframe with the first 10 years as a COBOL/CICS/Db2 developer and fell in love with Db2 and worked with Db2 since V9. I am an Infrastructure... Read More →
Wednesday June 11, 2025 11:30am - 12:30pm EDT
Inman
  Technical Session, SQL App Dev and Modernization

11:30am EDT

F11 | IBM Cloud Replication Cartridge – Real Time DB2 Data and DDL Changes Replicated to Data Lake, Kafka, and DB2 Cloud Destinations
Wednesday June 11, 2025 11:30am - 12:30pm EDT
University
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.
Speakers
avatar for Shawn Robertson

Shawn Robertson

Software Architect, IBM
Shawn is passionate about data, it's transformation, integrity and power. Having been an IBM developer for over 20 years he's had the pleasure of architecting products spanning the gamut of data repository types from ACID relational to eventually consistent destinations.Shawn's relational... Read More →
Wednesday June 11, 2025 11:30am - 12:30pm EDT
University
  Technical Session, Cloud Warehouse and Data Lakes

12:30pm EDT

Lunch & Passport to Prizes Drawing
Wednesday June 11, 2025 12:30pm - 2:00pm EDT
International Ballroom
Wednesday June 11, 2025 12:30pm - 2:00pm EDT
International Ballroom
  Lunch

2:00pm EDT

A12 | From the Statement Cache with Love
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Piedmont
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.
Speakers
avatar for Thomas Baumann

Thomas Baumann

Data Evangelist, Swiss Mobiliar
Computer scientist by training, data scientist by practice, query tuner by spirit. Thomas is a fast learner with lots of curiosity, passionate about investigating mechanisms, causes and outcomes.  Currently, his position is Data Evangelist at Swiss Mobiliar in Bern, Switzerland... Read More →
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Piedmont
  Technical Session, Db2 Features Improvements and Tips z/OS

2:00pm EDT

B12 | Everyday DB2 Insights: Lessons from the Trenches
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Roswell
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.
Speakers
KH

Kevin Hong

Senior Principal Database Architect, worldPay
Kevin has been working on IBM Db2 for 30 years.  He received his first Db2 Admin certification back in 1995 and holds Db2 admin certifcation for db2 11 for both LUW and Z/OS. Kevin has very deep knowledge and skills for mission critical , high availability,  very large multi-hundreds... Read More →
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Roswell
  Technical Session, Db2 Features Improvements and Tips LUW

2:00pm EDT

C12 | Provisioning Db2 Schema as Code – Using Ansible and DevOps APIs
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Spring
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.
Speakers
avatar for Sridhar Pratik Shanmugam

Sridhar Pratik Shanmugam

Staff Software Engineer, Broadcom
Sridhar Shanmugam has over 11 years of experience in designing and building Db2 for z/OS administration products. At Broadcom, he focuses on delivering high-quality products that support mission-critical applications. His expertise lies in quality assurance, automation, and leveraging... Read More →
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Spring
  Technical Session, Operations & Automation

2:00pm EDT

D12 | Db2 12.1 – Ready for the Deployments and Workloads of the Future
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Techwood
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.
Speakers
avatar for Les King

Les King

Principal, Learning Content Development, IBM
Les King has impacted the vision for IBM’s Hybrid Data Management strategies, which includes Big Data, Analytics, Database and Cloud Data Services by acting as a trusted advisor both to clients and within IBM.  This role is now inclusive of how the world of AI and Quantum computing... Read More →
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Techwood
  Technical Session, Database Practices

2:00pm EDT

E12 | Adopting Agile Development Practices with Db2 for z/OS
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Inman
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.
Speakers
SA
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Inman
  Technical Session, SQL App Dev and Modernization

2:00pm EDT

F12 | V12 Db2 SQL Extensions: Tenant, Vectors, Lakehouse and More
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
University
A look at the new SQL capabilites added to Db2 v12 as well as a look back at some of the lesser known additions in 11.1 and 11.5 mod packs.  A deep dive into new namespace isolation capabilities provided via the TENANT concept. A peek into the Vector store extensions coming to Db2 and a look at how Db2 can integrate into a lakehouse strategy.
Speakers
avatar for Mike Springgay

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.
Wednesday June 11, 2025 2:00pm - 3:00pm EDT
University
  Technical Session, Cloud Warehouse and Data Lakes

2:00pm EDT

Badging at IDUG
Wednesday June 11, 2025 2:00pm - 3:30pm EDT
Fairlie
Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information: 
  • First & Last Name: 
  • Email Address: 
  • Exam Choice: 
  • Day & Time Choice: 
Exam choices include: 
  • Db2 11.5 Foundations Exam 
  • Db2 11.5 Administration Exam 
  • Db2 11.5 Advanced Database Resilience Exam 
  • Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
  • Db2 12.1 Foundations Exam * NEW * 
  • Db2 12.1 Administration Exam * NEW * 

IMPORTANT NOTES: No walk-ins. You must book in advance and you will receive  a confirmation once you are officially booked. This is a Bring Your Own Device  exam. Photo ID will be required at exam time. 
Wednesday June 11, 2025 2:00pm - 3:30pm EDT
Fairlie
  Badging & Certification

3:00pm EDT

Networking & Coffee Break
Wednesday June 11, 2025 3:00pm - 3:20pm EDT
International Ballroom
Wednesday June 11, 2025 3:00pm - 3:20pm EDT
International Ballroom
  Coffee Break

3:20pm EDT

PSP7 | Db2 Family Tools Update / SQLDI and Db2zAI Update
Wednesday June 11, 2025 3:20pm - 4:20pm EDT
Piedmont
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.
Speakers
avatar for Miran Badzak

Miran Badzak

Program Director, Databases, IBM
Miran Badzak is the Program Director running the IBM Db2, Db2 Warehouse and Informix portfolio of businesses. His mission is simple: establish and maintain IBM’s dominance in the databases market. Miran has held various roles since joining IBM in 2007, launching several cloud services... Read More →
Wednesday June 11, 2025 3:20pm - 4:20pm EDT
Piedmont
  Partner-Sponsored Presentation

3:20pm EDT

PSP8 | Behind the Curtain: Shaping the Future of Db2 Management at Broadcom
Wednesday June 11, 2025 3:20pm - 4:20pm EDT
Roswell
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
Speakers
CH

Chile Hidalgo

Strategy and Product Management, Data Management, Broadcom
Chile has led strategy for the Mainframe Software Division for the last three years. Prior to joining Broadcom, he spent 17 years working in strategy consulting for companies around the world.
avatar for Kyle Weeks

Kyle Weeks

Product Manager, Broadcom
Wednesday June 11, 2025 3:20pm - 4:20pm EDT
Roswell
  Partner-Sponsored Presentation

4:00pm EDT

Badging at IDUG
Wednesday June 11, 2025 4:00pm - 5:30pm EDT
Fairlie
Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information: 
  • First & Last Name: 
  • Email Address: 
  • Exam Choice: 
  • Day & Time Choice: 
Exam choices include: 
  • Db2 11.5 Foundations Exam 
  • Db2 11.5 Administration Exam 
  • Db2 11.5 Advanced Database Resilience Exam 
  • Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
  • Db2 12.1 Foundations Exam * NEW * 
  • Db2 12.1 Administration Exam * NEW * 

IMPORTANT NOTES: No walk-ins. You must book in advance and you will receive  a confirmation once you are officially booked. This is a Bring Your Own Device  exam. Photo ID will be required at exam time. 
Wednesday June 11, 2025 4:00pm - 5:30pm EDT
Fairlie
  Badging & Certification

4:30pm EDT

A13 | Db2 Expert Panel – z/OS
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Embassy B/C
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Embassy B/C
  Expert Panel

4:30pm EDT

B13 | Real Life Access Plan Tuning – 2025 Edition
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Roswell
Optimal access plans are critical for query performance, and it is the Db2 optimizer's job to choose the best one. The optimizer is very sophisticated and considers many factors while costing an access plan, but sometimes it makes mistakes, and you need to fix it quickly. This session will show you how to apply access plan tuning techniques based on queries from real Db2 customer systems. This 2025 edition of the session will cover brand new examples compared to the 2024 edition. A variety of query types will be covered, including OLTP and analytics, running on single or multiple data base partitions. You will also learn how to use the explain facility to understand how access plans work. Attend this session to learn some techniques to address a variety of access plan problems and to gain some insight into query optimization.
Speakers
avatar for John Hornibrook

John Hornibrook

Senior Technical Staff Member, IBM
John is a Senior Technical Staff Member responsible for relational database query optimization on IBM's distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator... Read More →
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Roswell
  Technical Session, Db2 Features Improvements and Tips LUW

4:30pm EDT

C13 | Automated Db2 Restores with Ansible Playbooks
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Spring
Learn how to use ansible playbooks to backup, restore Db2 databases locally or cross–node and automate all post–restore checks and validations.
Speakers
MS
avatar for Aish Khare

Aish Khare

Infra Admin Engineer, Pru
Aish is the member of the CPC and IBM Champion.
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Spring
  Technical Session, Operations & Automation

4:30pm EDT

D13 | DB2 Always on Architecture
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Techwood
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.
Speakers
avatar for Dale McInnis

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 →
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Techwood
  Technical Session, Database Practices

4:30pm EDT

E13 | Tuning SQL Stored Procedures (LUW Edition)
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Inman
(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.
Speakers
avatar for Philip Nelson

Philip Nelson

Senior Database Software Engineer, Lloyds Banking Group / ScotDB Limited
Philip Nelson has worked with Db2 for z/OS since 1989 and with Db2 (LUW) since the beginning.   He is an IBM Champion and a frequent presenter at IDUG and other conferences.  He particularly focuses on exploring Db2 with new technologies and improving the application development... Read More →
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Inman
  Technical Session, SQL App Dev and Modernization

4:30pm EDT

F13 | Getting the Most out of Amazon RDS for Db2
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
University
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.
Speakers
avatar for Andrew Hilden

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 →
Wednesday June 11, 2025 4:30pm - 5:30pm EDT
University
  Technical Session, Cloud Warehouse and Data Lakes

7:30pm EDT

A Night Out with IBM | Details coming soon!
Wednesday June 11, 2025 7:30pm - 10:00pm EDT
Wednesday June 11, 2025 7:30pm - 10:00pm EDT
  Evening Event
 
Thursday, June 12
 

7:00am EDT

Breakfast On Your Own
Thursday June 12, 2025 7:00am - 9:00am EDT
Thursday June 12, 2025 7:00am - 9:00am EDT
  Breakfast

8:00am EDT

Registration Available
Thursday June 12, 2025 8:00am - 12:00pm EDT
International Tower Lobby
Thursday June 12, 2025 8:00am - 12:00pm EDT
International Tower Lobby
  Registration

8:30am EDT

IDUG Db2 for LUW Essentials Course
Thursday June 12, 2025 8:30am - 12:00pm EDT
Edgewood
This 3.5-day foundational course introduces the essentials of Db2 12.1 for relational DBAs, covering architecture, installation, configuration, and basic database management. It then builds on these core essentials with topics such as data movement, backup and recovery, and routine maintenance to ensure performance and integrity.  Designed for new and transitioning DBAs, the course emphasizes hands-on learning with minimal prerequisites beyond basic SQL and database knowledge.

Note: There is no certification for the foundational course, but students can take a proctored quiz after the class to obtain the badge.

Thursday June 12, 2025 8:30am - 12:00pm EDT
Edgewood
  IDUG Essentials

9:00am EDT

A14 | Db2Z and Redirected Recovery – User Experiences
Thursday June 12, 2025 9:00am - 10:00am EDT
Piedmont
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
avatar for Brian Laube

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

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
avatar for Leila Hosseini

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

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
avatar for Andrew Hilden

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

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
avatar for Dale McInnis

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 →
avatar for Jerome Gilbert
Thursday June 12, 2025 9:00am - 10:00am EDT
Techwood
  Technical Session, AI Data Mining and ML

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
avatar for David Simpson

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

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
avatar for Kai Stroh

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

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
avatar for Michael Roecken

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

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
UH

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

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
avatar for Chris Crone

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

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
avatar for Shaikh Quader

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 →
avatar for Mike Springgay

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

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
SP
Thursday June 12, 2025 10:10am - 11:10am EDT
Inman
  Technical Session, SQL App Dev and Modernization

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
avatar for Ramon Menendez

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

10:30am EDT

Badging at IDUG
Thursday June 12, 2025 10:30am - 12:00pm EDT
Fairlie
Db2 (LUW) Proctored Exams are FREE at IDUG NA 2025!
Please book your exam time by sending an email to badges@idug.org and provide the following information: 
  • First & Last Name: 
  • Email Address: 
  • Exam Choice: 
  • Day & Time Choice: 
Exam choices include: 
  • Db2 11.5 Foundations Exam 
  • Db2 11.5 Administration Exam 
  • Db2 11.5 Advanced Database Resilience Exam 
  • Db2 11.5 Advanced Database Design & Application Development Exam - Db2 11.5 Advanced Tuning & Debugging Exam
  • Db2 12.1 Foundations Exam * NEW * 
  • Db2 12.1 Administration Exam * NEW * 

IMPORTANT NOTES: No walk-ins. You must book in advance and you will receive  a confirmation once you are officially booked. This is a Bring Your Own Device  exam. Photo ID will be required at exam time. 
Thursday June 12, 2025 10:30am - 12:00pm EDT
Fairlie
  Badging & Certification

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
avatar for Derek Tempongko

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

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
avatar for Toby Haynes

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

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
DR
Thursday June 12, 2025 11:20am - 12:20pm EDT
Spring
  Technical Session, Operations & Automation

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
avatar for Thomas Beavin

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

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
avatar for Keziah Knopp

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 →
VF
Thursday June 12, 2025 11:20am - 12:20pm EDT
Inman
  Technical Session, SQL App Dev and Modernization

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
avatar for David Kalmuk

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

12:30pm EDT

IDUG Closing Comments
Thursday June 12, 2025 12:30pm - 12:50pm EDT
Thursday June 12, 2025 12:30pm - 12:50pm EDT
  Main Stage Event

1:00pm EDT

A203 | Db2 – Console and AI Assistant Hands–on Lab
Thursday June 12, 2025 1:00pm - 4:30pm EDT
Piedmont
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.
Speakers
avatar for Sahej Thapar

Sahej Thapar

Product Manager, IBM
Sahej is an experienced product manager on the Db2 team. He has contributed to all facets of the Db2 portfolio including go-to-market strategy, customer migrations and user experience initiatives for Db2 SaaS as well as Db2 on Prem.
avatar for Aniruddha Joshi

Aniruddha Joshi

Product Manager, IBM
Ani is a product manager at IBM, working on AI products for IBM's data management portfolio.
Thursday June 12, 2025 1:00pm - 4:30pm EDT
Piedmont
  Hands–On Lab

1:00pm EDT

B203 | Hands–On: Building AI Systems with IBM Db2
Thursday June 12, 2025 1:00pm - 4:30pm EDT
Roswell
IBM Db2 offers a wide range of AI features, both built–in and external tools, for creating AI systems and solutions. These include over 200 built–in AI stored procedures and tools that work seamlessly with open–source AI ecosystems. In this workshop, participants will explore Db2’s AI support and use a selection of these features to implement practical AI models. The workshop consists of two parts. In the first module, participants will learn how to develop a supervised AI model using Db2’s built–in AI stored procedures. The entire model development and usage will be done using SQL within the database. In the second module, participants will learn how to create a Python model using popular Python packages outside of the database, and then deploy that model back into a Db2 database. By the end of the workshop, participants will have gained fundamental skills and hands–on experience in utilizing these AI capabilities. They will be able to apply these skills to their future AI projects. This workshop is designed to be beginner–friendly and does not require participants to have extensive knowledge in AI. Basic SQL skills and some Python programming skills are sufficient for attending and benefiting from this workshop.
Speakers
avatar for Shaikh Quader

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 →
Thursday June 12, 2025 1:00pm - 4:30pm EDT
Roswell
  Hands–On Lab

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
avatar for Artem Minin

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 →
avatar for John Goodyear

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

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
SA
XZ

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

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
avatar for Andrew Badgley

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

1:00pm EDT

F203 | The Db2 First Responder Workshop
Thursday June 12, 2025 1:00pm - 4:30pm EDT
University
The Db2 community constantly welcomes new database administrators or application developers that access Db2. One of the reasons – Db2 is known as a robust and reliable database management system and a perfect match for private and public cloud environments.
However, sometimes you might face database related issues. The session will cover the first steps in the process of problem determination and problem source identification (PD/PSI). The session gives hands–on examples and practical examples for the strategy and process to encircle and find the problem by asking the right questions and will share best practices for the first occurrence data capture (FODC) tools available for the DBA.
Speakers
avatar for Thomas Rech

Thomas Rech

Senior IT Architect - DB2 SAP Development, IBM
Thomas has been working in the Db2 area since 1996. Starting as a Db2 course instructor, he soon moved to the SAP on Db2 environment in 1997. He joined the SAP/IBM Db2 Development Team, followed by a role as technical sales consultant. He led several lighthouse projects like the first... Read More →
ZK

Zahidul Khan

Technical Support Professional, IBM Canada
Zahidul Khan has been working at IBM Toronto Software Lab as software developer since 2000. He started working as DB2 Support Analyst and assisting customers with problem analysis and troubleshooting in all areas of DB2 LUW. For the last 14 years he is working in SAP DB2 Integration... Read More →
Thursday June 12, 2025 1:00pm - 4:30pm EDT
University
  Workshop
 
  • Filter By Date
    Jun 8 - 12, 2025
  • Filter By Venue
    265 Peachtree Center Avenue Northeast, Atlanta, GA, USA
    All
    Auburn
    Edgewood
    Embassy B/C
    Embassy D/E
    Fairlie
    Inman
    International Ballroom
    International Tower Lobby
    Piedmont
    Roswell
    Spring
    Techwood
    University
  • Filter By Type
    Badging & Certification
    Break
    Breakfast
    Coffee Break
    Evening Event
    Expert Panel
    Hands–On Lab
    IDUG Essentials
    IDUG Reception
    Lunch
    Main Stage Event
    Partner-Sponsored Presentation
    Registration
    Spotlight
    Technical Session
    All
    AI Data Mining and ML
    Backup Recovery & Data Movement
    Cloud Warehouse and Data Lakes
    Database Practices
    Db2 Features Improvements and Tips LUW
    Db2 Features Improvements and Tips z/OS
    Db2 Solutions Utilities and Tools
    Operations & Automation
    Performance Monitoring and Troubleshooting
    SQL App Dev and Modernization
    Security Compliance and Governance
    Workshop
  • Audience
    Advanced
    All
    Beginner
    Intermediate
  • Subject
    AI / ML
    Cross Platform
    LUW
    z/OS
  • Timezone
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Sunday, June 8
Monday, June 9
Tuesday, June 10
Wednesday, June 11
Thursday, June 12
Auburn
Edgewood
Embassy B/C
Embassy D/E
Fairlie
Inman
International Ballroom
International Tower Lobby
Piedmont
Roswell
Spring
Techwood
University
  • Badging & Certification
  • Break
  • Breakfast
  • Coffee Break
  • Evening Event
  • Expert Panel
  • Hands–On Lab
  • IDUG Essentials
  • IDUG Reception
  • Lunch
  • Main Stage Event
  • Partner-Sponsored Presentation
  • Registration
  • Spotlight
  • Technical Session
  • Workshop
  • Audience
  • Advanced
  • All
  • Beginner
  • Intermediate
  • Subject
  • AI / ML
  • Cross Platform
  • LUW
  • z/OS