IDUG NA 2025

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.

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.

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.

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.