IDUG EMEA 2024

Get hands-on experience with IBM Db2 AI for z/OS, a powerful new offering built on machine learning. Learn how Db2 AI can: optimize SQL statements, provide Db2 system assessments with expert guidance for tuning your subsystem, use the Distributed Connection Controller to learn remote workload traffic and generate Db2 profiles to monitor and control remote connection access of Db2's distributed server for location, user ID, and application name, and monitor system performance with a new performance insight visualization dashboard.

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.

Cloud Pak for Data, we've all heard of it before, but what can it do? Which components are inside of this offering and why would we combine this with Db2? This presentation present some key takeaways on the IBM Data Fabric solution and zooms in on its functional and technical architecture.
First, the presentation will explain how the Cloud Pak sits within a typical data architecture, with special attention to the uses cases of Db2 Warehouse en Watsonx.data. Next, we will discuss the main components and how they differ from their non-Cloud Pak counterparts. Finally, we discuss the deployment and licensing on different platforms.

This lab session is provide the attendees the hands-on experience to explore how AI enabled monitoring solution, with a trained ML model, can help manage DB2 and z/OS performance to empower you to become more proactive before the problem damages the system.  The lab is hosted on an IBM live z/OS environment via internet.  The instructor will be on-site providing a lab guide and answering questions.  The lab guide gives step-by-step instructions to take you through Db2 problem solving scenarios with AI-ML scoring in action.  Bring your own laptop device, and we will set it up for you to login to this AI-ML lab on a live IBM Z system.

A secure environment while operating Db2 has become of utmost importance as the cost of cyberattack and data breach increase year by year. The purpose of this hands on lab is to provide guidance on building a secure Db2 environment with some of Db2’s latest security features. In this hands-on workshop, participants will learn about Db2 security services including configuring TLS, Native Encryption, Row and Column Access Control, and the Db2 Audit Facility.

We hear a lot about the open mainframe, but what does it really mean?  Depending on your role and organization boundary, the definition of open mainframe can vary.  At Broadcom, our point of view on the open mainframe is essentially to enable those capabilities our customers need to effectively manage this critical component of their hybrid IT architecture, as services.  This is supported through our Database Management Data Service (DBM-DS) architecture built to be Zowe compliant, leveraging the many benefits provided by the Zowe API mediation layer (API-ML).  Come join our workshop to learn best practices for standing up a DBM-DS instance and API-ML which will then open the doors to many exciting use cases enabled through a web-based interactive user interface. 

When running a DB2 data sharing system; understanding global locking is critical togood application and system performance.This double session will describe how DB2data sharing locking works under the covers. The session will also explain whatinformation you have at your disposal to understand the data sharing lockingcharacteristics of your system; and how to influence and tune your data sharing lockingbehavior for various types of problems that you may encounter.