DB15 - DB2 Programming with Large Objects - 1 Days

Course Description

This course is aimed at Programmers who need to understand how to define and manipulate DB2 Large Objects.


A strong knowledge and experience in DB2 Applications Development is required to attend this course.


The aim of this course is to provide the programmer, already familiar with DB2 applications program development, with the necessary skills required define, load and manipulate LOB data.

On completion of this course the student will be able to:

  • define large objects
  • understand ROWIDS
  • access and manipulate large objects from a program
  • use LOB locators
  • use File Reference Variables
  • run LOAD, REORG and COPY with LOB data


Development will be performed using:

  • IBM Mainframe
  • DB2 for z/OS or DB2 LUW - Versions 10, 11 or 12
  • COBOL, PL1 or Java


For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

Large Objects (LOBs)
LOB Definition
Base Table Definition
Altering A Table To Add LOB Data
Rowid Data Type
LOB Tablespace And Auxiliary Table Requirements
LOB Tablespace Considerations
LOB Tablespace Definition
Auxiliary Table Definition
Auxiliary Table - Index Definition
LOB Authorisations
Dropping LOB Tables
Hidden Rowid Generation

LOB Data Manipulation
Inserting Or Updating LOB Values
Declaring LOB Host Variables
Example Using LOB Variables
LOB Manipulation
Using LOB Locators
Declaring LOB Locator Host Variables
Holding Locators
Freeing Locators
Example Using LOB Locators
LOB Limitations
LOB Locator Considerations
LOB Locators and LOB Integrity
File Reference Variables
Defining File Reference Variables
File Reference Variables - Example
Loading Data using File Reference Variables
File Reference Variables - New DSNZPARM
Fetch Continue
Fetch Continue Example
Fetch Continue Considerations
Locking LOB Data
LOB Locking Summary
LOB Tablespace Logging
LOB Bufferpool Management

Load Utility - LOB Data
Loading Rowids
Reorg Utility - LOB Data
Copy Utility - LOB Data
Recovering LOB Data to a Point-In-Time
LOB Recovery States
Procedure For Recovering Invalid LOBs
Recover Utility - LOB Data
The Check LOB Utility
Check LOB Considerations
Check Data Utility - Base Tablespace
Check Data Utility - Scope
Check Data Utility - Auxerror
Resetting Auxiliary Check Pending Status (ACHKP)
Resetting Auxiliary Warning Status (AUXW)

Course Format

The course contains many practical exercises to ensure familiarity with the product. On completion of this course students will be able to develop application programs which use advanced programming techniques.

The comprehensive Student Guide supplied is fully indexed serving as a useful reference tool long after the course has finished. Delegates will also be able to access a free help-line with technical questions relating to topics covered on the course.

Course Enquiry