IDUG NA 2025

This is a back–to–basics session that will cover the fundamentals of Db2 Large Objects (LOBs), their structure, different LOB types, how they are implemented, considerations for daily management and how it is possible to Improve application performance transforming standard lobs to Inline Lobs.
Db2 LOBs enable you to store large amounts of data in a single column. The data can be structured in nature, but more often contain unstructured data such as images or audio data. LOB implementation requires auxiliary objects to be created, which increases the complexity of object administration, space utilization, and utility processing.
This session provides an overview of Db2 LOBs, things to watch out for, and tips for tuning and space allocation.
Objectives:1.    Provide an overview of LOB types, and how they are structured and implemented.2.    Provide tips for performance tuning and space utilization using the Inline Lobs.3.    How to avoid LOB data corruption scenarios and ensure data integrity.

An engaging exploration of the hot topic sweeping through the tech world, with a particular focus on mainframe modernization.
This interactive session will demystify the concepts surrounding modernization, including rehosting, refactoring, replatforming, repurchasing, retiring, and retaining.
Through a fun game of Buzzword Bingo, attendees will gain insights into how modernization, concepts and all things new, can elevate their skills and keep their organizations competitive in the digital age. The presentation will highlight the importance of embracing modernization while also appreciating the enduring value of legacy ... legendary systems.
Don't be left behind – join us to understand why modernization is more than just a trend and how it can shape the future of your career and industry.

We will illustrate how 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.
During this session we will show you the steps administrators would take to set the framework followed by the steps a developer would take to modify an application including database changes and additional objects.

(IDUG EMEA 2024 BEST USER SPEAKER)
SQL stored procedures are a very common method of delivering Db2 functionality to applications.  But when they need performance tuning how do you achieve this.   In this presentation we will explore the components behind SQL stored procedures and how to tune the individual elements.