IDUG NA 2025

IDUG NA 2025

7:00am EDT

Breakfast On Your Own

8:00am EDT

Registration Available International Tower Lobby

9:00am EDT

B201 | Infusing Db2 for z/OS with AI: Hands–on Lab with IBM Db2 AI 1.6 for z/OS RoswellMartin Dinh • John Goodyear C201 | Hands–on SSL/TLS Deployment for Db2 LUW Clients and Servers SpringGreg Stager D201 | The HADR with Pacemaker for Cloud Deployments Workshop TechwoodToby Haynes • Thomas Rech E201 | The Tortoise or the Hare: Unlock the Full Potential And Speed of Your Database InmanCarlos Davis A201/202 | Unlock Modernization: Installing Zowe API ML and Elevating the Db2 for z/OS Experience PiedmontMark Daubman

12:30pm EDT

1:30pm EDT

D202 | Using Db2 and RAG Generation with LLMs TechwoodGeorge Baklarz E202 | IBM Db2 Query Monitor – Hands on Lab for the Web Client Interface InmanTom Glaser B202 | BYOD Hands-on Lab: IBM Db2 z/OS Data in an Open Lakehouse RoswellArtem Minin • John Goodyear C202 | MaaS – Db2 Monitoring as a Service in AWS, Azure, GC and IBM Cloud SpringThomas Rech F202 | Amazon RDS for Db2 Workshop UniversityAndrew Hilden • Javeed Mohammed

7:00am EDT

Breakfast On Your Own

7:30am EDT

Registration Available International Tower Lobby

8:30am EDT

IDUG Opening Comments International Ballroom IDUG Db2 for LUW Essentials Course Edgewood IDUG Db2 for z/OS Essentials Course Auburn

9:00am EDT

K1 | What's next in Data Strategy and what does it mean for Db2, Presented by IBM International BallroomSkyla Loomis • Priya Srinivasan

10:00am EDT

Networking & Coffee Break International Ballroom

10:20am EDT

A1 | Db2 for z/OS Spotlight: Trends and Directions from the Lab Embassy B/CHaakon Roberts B1 | Db2 LUW Spotlight Session Embassy D/ESatya Krishnaswamy • Wesley Gyure

11:30am EDT

A2 | Key Performance Updates, zSynergy and Best Practices for Db2 for z/OS PiedmontAkiko Hoshikawa B2 | Db2 Latest from the Lab RoswellMike Springgay C2 | Basics of Shell Scripting for the Db2 DBA SpringSebastian Zok D2 | How to Recover When Recovery Seems Impossible TechwoodChad Reiber E2 | Db2 DDF and DBATs and Connections Re–Explained from a User Perspective InmanBrian Laube F2 | Integrating Db2 for z/OS in Cloud Environments UniversityToine Michielse

12:30pm EDT

Lunch International Ballroom

2:00pm EDT

A3 | Db2, IDAA and Safeguarded Copy Resiliency Evolution and Integration PiedmontAnthony Ciabattoni • Cuneyt Goksu B3 | Introducing the IBM Database AI Assistant for Db2 RoswellDavid Kalmuk C3 | RUNSTATS Master – Reloaded SpringRoy Boxwell D3 | Index Modernization in Db2 for z/OS: Because Things Have Changed the Past 20 Years! TechwoodCraig Mullins E3 | Evolution of Database Infrastructure: Performance & Monitoring Considerations when Migrating Large–Scale COBOL Application in Banking from Db2 z/OS to Db2 LUW InmanJakub Rosiak F3 | Db2 – Mission Critical High Volume Highly Complex Cross Platform Migration to Cloud – Next Steps UniversityNemi Agrawal

3:00pm EDT

Networking & Coffee Break International Ballroom

3:20pm EDT

A4 | All about Db2 for z/OS Package Management PiedmontKeziah Knopp • Mark Rader B4 | Db2 12.1: Advances in Operational Resiliency for Mission–Critical Workloads RoswellChristian Garcia–Arellano • Francis Wong C4 | Personal Experience: 40 Years of Battle Scars from Managing Db2 for z/OS SpringSteen Rasmussen D4 | SQL Joins – In Depth TechwoodTony Andrews E4 | Using db2mon and R for Deep Insights into your Database Activity InmanToby Haynes F4 | How to Access Db2 for z/OS (and other Z oriented) Data in the Cloud UniversityCuneyt Goksu

4:30pm EDT

A5 | The Greatest and the Latest Db2 13 Online Schema and Application Performance enhancement PiedmontFrances Villafuerte B5 | Db2 LUW V12: New Security Features and Changes RoswellGreg Stager C5 | Mastering Db2 for z/OS Application Performance: Strategies for Success SpringToine Michielse D5 | 10 Things I Wish I'd Known Before I Move to Developer Extension from Data Studio TechwoodKe Chen E5 | Don’t have an SQL Monitor? You Might Need a Bigger Shovel InmanTom Glaser F5 | Db2 On–prem to Cloud Transformation Journey UniversityMohankumar Saraswatipura

5:30pm EDT

IDUG Expo Grand Opening & Welcome Reception

7:00am EDT

Breakfast On Your Own

8:00am EDT

Registration Available International Tower Lobby

8:30am EDT

IDUG Db2 for LUW Essentials Course Edgewood IDUG Db2 for z/OS Essentials Course Auburn

9:00am EDT

K2 | Unveil Db2's Hidden Treasures, Presented by Broadcom International BallroomGreg Lotko

10:00am EDT

Networking & Coffee Break International Ballroom

10:20am EDT

A6 | Pedal to The Metal – This is Not your Daddy's Accelerator! PiedmontAdrian Collett B6 | Unlocking Insights: Leveraging IBM DB2 and AWS SageMaker for Machine Learning RoswellDavid Morris C6 | DB2 LUW PureScale – Custom Disaster Recovery Configuration SpringMateusz Ksiazek • Marcin Baster D6 | A 50–Cent Tour of Db2 TechwoodMark McNary E6 | Db2 for z/OS Utilities – Best Practices for Maximizing Availability and Performance InmanKa Chun Ng F6 | So Your Auditors Really Want to Know What is Happening In a Database UniversityPaul Turpin

11:30am EDT

A7 | Db2 13 Utilities History – What is It and How to Use PiedmontTom Crocker B7 | Diamonds are Forever – Real–World SQL Data Insight Experiences RoswellThomas Baumann C7 | Db2 Advanced Log Space Management – Unleashed SpringMichael Roecken D7 | DIY Db2 z/OS Administration Solutions TechwoodSteven Loesch E7 | Explain EXPLAIN InmanRoland Schock F7 | How to Hack Db2 for z/OS – Lessons Learned from Mainframe Hackers UniversityEmil Kotrc

12:30pm EDT

Lunch International Ballroom

2:00pm EDT

A8 | IBM z Hardware Synergy with Db2 for z/OS Performance Improvement PiedmontLethika Panicker B8 | IBM Db2 for AI: Building AI Systems with Db2 RoswellShaikh Quader C8 | Supercharge Db2 Utilities: Uncover More Features SpringDenis Tronin D8 | My All–Time Db2 Top Ten Lists TechwoodCraig Mullins E8 | BMC Db2 AMI Utilities To The Rescue – What's New !! InmanMichael Cotignola F8 | Db2 Audit and Audit Exceptions with SAP UniversityDonald Vorhees • Thomas Rech

3:00pm EDT

Networking & Coffee Break International Ballroom

3:20pm EDT

PSP1 | Db2 Strategy & Business Update PiedmontMiran Badzak PSP2 | Db2 Analytics Accelerator V8 – What is new with the new release and z17 RoswellCuneyt Goksu PSP3 | Db2 Treasure Hunt: Unearthing Essential Maintenance Tips for DBAs SpringTony Andrews • Steen Rasmussen

4:30pm EDT

A9 | Db2 for z/OS all new "2025 SWAT Tales" PiedmontAnthony Ciabattoni B9 | Bridging the Db2 for z/OS Skill Gap with Generative AI RoswellYan (Catherine) Wu C9 | HADR – How and Where to Start SpringSebastian Zok D9 | Mastering Access Path Management in Db2 for z/OS: Simplify, Optimize, Succeed TechwoodDenis Tronin E9 | Db2 Automatic Statistics Deep Dive InmanJohn Hornibrook F9 | Modernizing your Security Posture around Db2 z/OS Data UniversityGreg DeBo • Gayathiri Chandran

5:30pm EDT

IDUG Evening Reception

7:30pm EDT

A Night Out with Broadcom | Details coming soon!

7:00am EDT

Breakfast On Your Own

8:00am EDT

Registration Available International Tower Lobby

8:30am EDT

IDUG Db2 for LUW Essentials Course Edgewood IDUG Db2 for z/OS Essentials Course Auburn

9:00am EDT

K3 | IDUG WIT | The Trailblazer: Harnessing the Power of Adaptability, Innovation, and Resilience, Sponsored by Broadcom International BallroomJennifer Pharr Davis

10:00am EDT

Networking & Coffee Break International Ballroom

10:20am EDT

A10 | Preparing to Pass Your Db2 for z/OS Administrator Certification Exams PiedmontEmil Kotrc B10 | Db2 pureScale v12.1 on Azure RoswellChristian Garcia–Arellano • Andrew Hilden C10 | Automatic Fast DB Size Reduction, NO DELETE, NO REORG, NO System Down SpringFarid Hosseini D10 | Db2 13 for z/OS: Using the Profile Tables to Monitor and Enforce Security Requirements for DDF Applications TechwoodScott Walker • Gayathiri Chandran E10 | “A LOB for friend. Know me a little better “ InmanRoberto Cason F10 | Experiences with BLU in a Banking Environment UniversityKlaus Zentarra

11:30am EDT

B11 | Db2 Expert Panel – LUW Embassy B/C A11 | Db2 Backup and Recovery Basics PiedmontLaura Kunioka–Weis C11 | Fear no Threads: Secure and Monitor Db2 Connections with Profile Tables SpringToine Michielse D11 | Isn't She aDORAble? A DBAs Guide to DORA, PCI DSS V4.0.1 and How to Survive an Audit! TechwoodRoy Boxwell E11 | The M–Word: Why Everyone's Talking about Modernization InmanChris Muncan F11 | IBM Cloud Replication Cartridge – Real Time DB2 Data and DDL Changes Replicated to Data Lake, Kafka, and DB2 Cloud Destinations UniversityShawn Robertson

12:30pm EDT

Lunch & Passport to Prizes Drawing International Ballroom

2:00pm EDT

A12 | From the Statement Cache with Love PiedmontThomas Baumann B12 | Everyday DB2 Insights: Lessons from the Trenches RoswellKevin Hong C12 | Provisioning Db2 Schema as Code – Using Ansible and DevOps APIs SpringSridhar Pratik Shanmugam D12 | Db2 12.1 – Ready for the Deployments and Workloads of the Future TechwoodLes King E12 | Adopting Agile Development Practices with Db2 for z/OS InmanSueli Almeida F12 | V12 Db2 SQL Extensions: Tenant, Vectors, Lakehouse and More UniversityMike Springgay

3:00pm EDT

Networking & Coffee Break International Ballroom

3:20pm EDT

PSP7 | Db2 Family Tools Update / SQLDI and Db2zAI Update PiedmontMiran Badzak PSP8 | Behind the Curtain: Shaping the Future of Db2 Management at Broadcom RoswellChile Hidalgo • Kyle Weeks

4:30pm EDT

A13 | Db2 Expert Panel – z/OS Embassy B/C B13 | Real Life Access Plan Tuning – 2025 Edition RoswellJohn Hornibrook C13 | Automated Db2 Restores with Ansible Playbooks SpringMohan Saraswatipura • Aish Khare D13 | DB2 Always on Architecture TechwoodDale McInnis E13 | Tuning SQL Stored Procedures (LUW Edition) InmanPhilip Nelson F13 | Getting the Most out of Amazon RDS for Db2 UniversityAndrew Hilden

7:30pm EDT

A Night Out with IBM | Details coming soon!

7:00am EDT

Breakfast On Your Own

8:00am EDT

Registration Available International Tower Lobby

8:30am EDT

IDUG Db2 for LUW Essentials Course Edgewood

9:00am EDT

A14 | Db2Z and Redirected Recovery – User Experiences PiedmontBrian Laube B14 | Easy Space Allocation RoswellLeila Hosseini C14 | Db2 SaaS Modernization on Azure and BYOC SpringAndrew Hilden D14 | DB2 Universal Translator between z/OS and LUW TechwoodDale McInnis • Jerome Gilbert E14 | Fun with SQL – Table Expressions InmanDavid Simpson F14 | Build a Lightweight Monitor to Identify SQL Workload Tuning Potential UniversityKai Stroh

10:10am EDT

A15 | Unlocking Recovery – The Key to Solving Everyday Problems PiedmontMichael Roecken B15 | Understand, Manage and Love Certificates in z/OS and USS RoswellUlf Heinrich C15 | Strategies for Making Db2 Data Accessible with APIs SpringChris Crone D15 | Vector Support in IBM Db2: Empowering the Development of Modern LLM Applications TechwoodShaikh Quader • Mike Springgay E15 | Recycling Task that will Call a Database Table with Deadlock is Triggered InmanSamhita Pal F15 | “The Art of War” Against Bad SQL UniversityRamon Menendez

11:20am EDT

A16 | DDF Best Practice PiedmontDerek Tempongko B16 | Digging into HADR Performance on AWS RoswellToby Haynes C16 | Deciding which Buffer Pools to Page Fix using Automation SpringDonnell Roach 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 TechwoodThomas Beavin E16 | Db2–Pardy InmanKeziah Knopp • Victoria Felt F16 | Advanced Performance Diagnostics for SQL UniversityDavid Kalmuk

12:30pm EDT

IDUG Closing Comments

1:00pm EDT

A203 | Db2 – Console and AI Assistant Hands–on Lab PiedmontSahej Thapar • Aniruddha Joshi B203 | Hands–On: Building AI Systems with IBM Db2 RoswellShaikh Quader C203 | BYOD Hands–On–Lab: Performing AI Queries with Db2 13 for z/OS SpringArtem Minin • John Goodyear D203 | The Next Generation of Services for Db2 Administration and Development Workshop TechwoodSueli Almeida • XuQin Zhao E203 | Db2 for z/OS Performance Monitoring and Tuning InmanAndrew Badgley F203 | The Db2 First Responder Workshop UniversityThomas Rech • Zahidul Khan