IDUG NA 2025

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.

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.
 
 

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.