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.

Creating backups of and recovering your data are essential tasks performed by the IBM Db2 utilities.  This presentation will cover the basics – the different types of backups and recovery options – for the COPY, RECOVER, REBUILD INDEX, BACKUP SYSTEM, RESTORE SYSTEM utilities, and more, including a peek at new and future enhancements.