IDUG EMEA 2024

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.

Are you exploring how to exploit Ansible on your DevOps journey? Or, you may be well on your way towards standardizing on Ansible. Either way, our workshop will introduce you to a Broadcom developed Ansible collection that will empower you to automate your Db2 for z/OS Schema Management the Ansible way. This Ansible collection will be a powerful tool to enable a developer to provision the Db2 environment needed to test an application. It also has the necessary capabilities to automate deployment of any schema changes. In this workshop you will have the opportunity for an instructor-led hands on experience with the Broadcom DBM-Db2 Ansible collection. You will learn ways to use the collection in ad hoc mode as well as understand how to develop Ansible playbooks to achieve your goal.

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.

We will illustrate how in an agile cloud native environment, applications developers can easily use the self-service facilities to make changes, test, commit, push, automate deployment with automated CI/CD pipeline. Such changes can only be done within pre-established rules set by DBA and other administrators.This presentation will show the steps a developer would take to modify an application including database changes and additional objects. A central part of the presentation will be a demo of DevOps facilities.
We will illustrate how in an agile cloud native environment, applications developers can easily use the self-service facilities to make changes, test, commit, push, automate deployment with automated CI/CD pipeline. Such changes can only be done within pre-established rules set by DBA and other administrators

Db2 12 on Amazon RDS for Db2 will be discussed along with a set of tips and tricks on getting the most of Db2 running in AWS.

In the ever-evolving landscape of database management, ensuring the availability and swift recovery of critical data has become paramount. This presentation dives into the latest enhancements and changes upcoming in availability and recovery with Db2’s Next Release to help you get the most out of your investment and defend against potential disruptions.

This session introduces the Lakehouse concept and what sets it apart from data lakes and traditional data warehouses. We focus on mainframe operational data stores as data feeds, and how such feeds can be integrated with other, non-mainframe data sources, how Lakehouses re-invent analytics and how machine learning training pipelines can be fed using data extracted and refined on a Lakehouse. 
We will use watsonx.data as the Lakehouse implementation, but the approach translates to any Lakehouse because of the use of open data formats.

In 2021, we initiated a PoC for Db2 for z/OS Data Gate with primary focus on functional and non-functional performance requirements, running on an x86 platform, which was successfully completed with good results. As we started to drill further into other non-functional requirements focusing on HA/DR we came to the conclusion that Data Gate on Z could be a better fit for what we wanted to achieve, which triggered our 2022 PoC, covering Data Gate on Z. This presentation will cover the whole journey of having done PoCs for both x86 and the Z platform, but with emphasis on what additional benefits the Z variant brings to the table. This session will be about positioning Db2 Data Gate on Z as the most efficient/effective way of supporting the fundamental need for unlocking Db2 for z/OS data to support UBS requirements related to a newly defined Digital Core Architecture, app modernization, and MIPS offload use cases.

Come to this session to learn about the value that REST APIs can bring to your shop. You will find that it is not nearly as tough as it may look. I will explain the how using some working examples.

Application developers and database administrators alike are under constant pressure to drive down costs and reduce CPU cycles. Discover technical insights and cultural shifts for Developers, DBAs, and Operations to tackle the widespread challenges in mainframe enterprises globally. Learn SQL tips and compiler hints. Find out what culture changes are necessary for co-ordinated cooperation in cost reduction. Join Marcus Davage, BMC Lead Product Developer, for this insightful webinar.

Trying to figure out the ins and outs of Db2 Log Space Management?  Spent too much time trying to figure out what settings are best for your environment?  With the introduction of Advanced Log Space Management the time has come to unleash it's potential.  Fully supported, the journey has begun in making log space management more autonomic.  This presentation will introduce you to some of the concepts and principles behind it all.  We will do a deep dive into the technology and transformation behind making log space management more hands off, which in the end will make life simple for you and your organization.

Transform mainframe development with Ansible's automation capabilities. Learn how the IBM Ansible Z Collection provides a modern mainframe interface for RESTful API interactions to IBM® Db2® integrations, including practical ways to streamline a workflow for this. We'll also explore ways to configure Visual Studio Code for seamless Docker/Ansible operations and demonstrate managing Db2 containers for a more efficient and effective development environment. This deep dive into Ansible's provisioning power will arm you with modern tools to revolutionize mainframe development and interaction with Db2 for z/OS.
In this session we'll be exploring the dynamic landscape of Ansible and Db2 for z/OS, redefining development practices through efficient strategies and innovative solutions. It commences with an introduction to Ansible, showcasing its versatility across diverse use cases and highlights the IBM Ansible Z Collection's interface with the mainframe.
The narrative delves into tips and tricks, offering insights to circumvent common challenges and avoid pitfalls, particularly through the usage of REST calls and integrating with Db2. It unravels the process of discovery, illustrating the interaction with Db2 through commands, SQL/DDL, utilities.

Data Studio has long been the standard desktop interface for Db2 for z/OS (alongside traditional ISPF). But  with Data Studio support for Db2 for z/OS ceasing in March 2025 what is replacing it?
This session will look at the 2 (free) products that are replacing Data Studio - Db2 Admin Foundation, and the Db2 for zOS Developer Extension for VSCode. We will look at the prereqs for the solution's, discuss the personas that each is targeted at, and look at the functionality available in each product.
If technology is on my side I will also attempt to do a live demo.

RESTful API (Application Programming Interface) support has been introduced to strengthen the position Db2 for z/OS plays in the new mobile application era. This presentation will equip the audience with a solid understanding of REST APIs in general and how to apply them to Db2. Administrators will learn how to create and maintain the services while developers will get familiar with the Db2 specifics.

Db2 for z/OS is undergoing a seismic shift in its tooling portfolio at the moment, with the sunsetting of Data Studio and DSM, and the emergency of a VS Code plugin stack for desktop developers and a web based suite built around the Admin Foundation offering.  This talk will focus on the VS Code side that leverages The Open Mainframe Project Zowe Explorer and Db2 Developer for z/OS extension to provide a powerful and intuitive way to work with z/OS address spaces, jobs, stored procedures, ad-hoc SQL scripts, and more.   Zowe is fast becoming the new face of z/OS for folks doing mainframe education courses and this talk will cover the Zowe CLI as well as the Db2 CLP showing the differences and overlap and when to choose each one,  as well as the use of Zowe to build out DevOps pipelines to help simplify and automate software agility.

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.