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.

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.

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.