IDUG NA 2025: Full Schedule

arrow_back View All Dates

8:30am EDT

IDUG Db2 for LUW Essentials Course

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

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

Subject LUW

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

Christian Garcia–Arellano

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

Audience Intermediate
Subject 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

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

Audience Advanced
Subject LUW

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

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

Audience All
Subject z/OS, LUW

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

Subject LUW

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

Audience All
Subject LUW

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

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

Audience All
Subject LUW

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

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

Audience All
Subject LUW

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

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

Audience Intermediate
Subject LUW

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 *

Wednesday June 11, 2025 2:00pm - 3:30pm EDT
Fairlie

Badging & Certification

Subject LUW

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 *

Wednesday June 11, 2025 4:00pm - 5:30pm EDT
Fairlie

Badging & Certification

Subject LUW

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

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

Audience Intermediate
Subject 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

Mohan Saraswatipura

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

Audience Intermediate
Subject LUW

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

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

Audience All
Subject LUW

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

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

Audience All
Subject z/OS, LUW

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

Andrew Hilden

Chief Architect Db2 SaaS, IBM

Wednesday June 11, 2025 4:30pm - 5:30pm EDT
University

Technical Session, Cloud Warehouse and Data Lakes

Audience All
Subject LUW