IDUG NA 2025

We were in a situation that some parts from a old/huge Partition range table are full and PAGENUM was ABSOLUTE, and we are not able to manage space locally in each part , So was Decided to ADD some parts between existing parts ! In this journey we needed to tackle some issues Like finding partitions range value for brand new parts, learning about concept of physical and Logical parts, and understanding how Db2 manages them. Moreover how utilities like Load and Reorg handle the added Parts! Many details  discussed and shared.

Understand, manage and love certificates in z/OS and USS, will address distributed Db2 access. You can communicate with z/OS, USS, Db2, or any other server or service via “postcards”, or “sealed envelopes”. Even within a trusted network, unencrypted postcard communication isn’t state of the art and may compromise information you don’t intend to share.
Web–based solutions, like ZOWE, UMS, ADF,… require secure connections, but the setup can be frustrating. Setting up and using encrypted channels isn’t rocket science, but they’re all based on certificates that some people find difficult to manage.This session sheds light on secure communication and their implementation in z/OS and USS services. I’ll explain how secure communication is set up, established and managed, as well as understanding difficulties that may arise.

Db2 HADR is a widely deployed Highly–Available configuration, providing excellent reliability and capacity, with Reads–on–Standby and multiple auxillaries. This session takes a look at the performance of HADR solutions, including

how to successfully configure and monitor HADR operation 
best practices and troubleshooting
Configuring and using virtual IP
examining performance data from AWS HADR pairs for different sync modes 

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.