IDUG NA 2025: Full Schedule

arrow_back View All Dates

7:00am EDT

Breakfast On Your Own

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

Subject LUW

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

Brian Laube

Db2 DBA, Manulife Financial

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

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

Technical Session, Backup Recovery & Data Movement

Audience All
Subject z/OS

9:00am EDT

B14 | Easy Space Allocation

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

Roswell

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

Speakers

Leila Hosseini

Senior DBA, OPS

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

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

Technical Session, Database Practices

Audience Intermediate
Subject z/OS

9:00am EDT

C14 | Db2 SaaS Modernization on Azure and BYOC

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

Spring

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

Speakers

Andrew Hilden

Chief Architect Db2 SaaS, IBM

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

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

Technical Session, Operations & Automation

Audience All
Subject LUW

9:00am EDT

D14 | DB2 Universal Translator between z/OS and LUW

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

Techwood

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

Speakers

Dale McInnis

Principal Data Technical Specialiust, IBM

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

Jerome Gilbert

IBM

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

Technical Session, AI Data Mining and ML

Audience All
Subject LUW

9:00am EDT

E14 | Fun with SQL – Table Expressions

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

Inman

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

Speakers

David Simpson

DBA, IDUG Content Committee

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

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

Technical Session, SQL App Dev and Modernization

Audience All
Subject z/OS, Cross Platform

9:00am EDT

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

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

University

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

Speakers

Kai Stroh

Mainframe Siftware Developer, UBS Hainer

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

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

Technical Session, Performance Monitoring and Troubleshooting

Audience Intermediate
Subject z/OS

10:10am EDT

A15 | Unlocking Recovery – The Key to Solving Everyday Problems

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

Piedmont

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

Speakers

Michael Roecken

Software Developer, IBM Canada

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

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

Technical Session, Backup Recovery & Data Movement

Audience Beginner
Subject LUW

10:10am EDT

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

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

Roswell

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

Speakers

Ulf Heinrich

Director Solutions Delivery, SEGUS Inc

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

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

Technical Session, Database Practices

Audience All
Subject z/OS

10:10am EDT

C15 | Strategies for Making Db2 Data Accessible with APIs

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

Spring

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

Speakers

Chris Crone

Distinguished Engineer - Database Technologies, Broadcom

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

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

Technical Session, Operations & Automation

Audience All
Subject z/OS

10:10am EDT

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

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

Techwood

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

Speakers

Shaikh Quader

AI Architect, IBM Db2, IBM

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

Mike Springgay

Db2 Architect, IBM

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

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

Technical Session, AI Data Mining and ML

Audience All
Subject LUW

10:10am EDT

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

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

Inman

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

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

Speakers

Samhita Pal

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

Technical Session, SQL App Dev and Modernization

Audience All
Subject z/OS

10:10am EDT

F15 | “The Art of War” Against Bad SQL

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

University

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

Speakers

Ramon Menendez

Principal Solution Engineer, BMC Software

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

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

Technical Session, Performance Monitoring and Troubleshooting

Audience Intermediate
Subject z/OS

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

Subject LUW

11:20am EDT

A16 | DDF Best Practice

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

Piedmont

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

Speakers

Derek Tempongko

Db2 for z/OS DDF development, IBM

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

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

Technical Session, Backup Recovery & Data Movement

Audience All
Subject z/OS

11:20am EDT

B16 | Digging into HADR Performance on AWS

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

Roswell

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

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

Speakers

Toby Haynes

Senior Software Developer, IBM Canada

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

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

Technical Session, Database Practices

Audience Intermediate
Subject LUW

11:20am EDT

C16 | Deciding which Buffer Pools to Page Fix using Automation

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

Spring

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

Speakers

Donnell Roach

BMC

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

Technical Session, Operations & Automation

Audience Beginner
Subject z/OS

11:20am EDT

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

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

Techwood

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

Speakers

Thomas Beavin

Senior Software Engineer, IBM

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

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

Technical Session, AI Data Mining and ML

Audience All
Subject z/OS

11:20am EDT

E16 | Db2–Pardy

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

Inman

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

Speakers

Keziah Knopp

Db2 for z/OS Specialist, IBM

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

Victoria Felt

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

Technical Session, SQL App Dev and Modernization

Audience All
Subject z/OS

11:20am EDT

F16 | Advanced Performance Diagnostics for SQL

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

University

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

Speakers

David Kalmuk

Distinguished Engineer, Analytic Databases, Data & AI, IBM

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

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

Technical Session, Performance Monitoring and Troubleshooting

Audience All
Subject z/OS, LUW

12:30pm EDT

IDUG Closing Comments

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

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.

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

Audience All
Subject LUW

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

Shaikh Quader

AI Architect, IBM Db2, IBM

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

Hands–On Lab

Audience All
Subject LUW

1:00pm EDT

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

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

Spring

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

Speakers

Artem Minin

Techincal Specialist, IBM

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

John Goodyear

z Systems Technical Support Specialist, IBM

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

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

Hands–On Lab

Audience Beginner
Subject z/OS

1:00pm EDT

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

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

Techwood

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

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

Speakers

Sueli Almeida

XuQin Zhao

Software Developer, IBM Silicon Valley Lab

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

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

Hands–On Lab

Audience All
Subject z/OS

1:00pm EDT

E203 | Db2 for z/OS Performance Monitoring and Tuning

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

Inman

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

Speakers

Andrew Badgley

Lead Product Owner, Broadcom

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

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

Workshop

Audience All
Subject z/OS

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

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 →

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

Audience Beginner
Subject LUW