DB15 - DB2 Programming with Large Objects
Duration1 Day
AvailabilityCheck course price and availability

Target Audience

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

Pre-requisites

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

Course Objectives

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

Course Environment

Development will be performed using:

  •     IBM Mainframe
  •     COBOL, PL1 or Java

Course Details

DEFINING LARGE OBJECTS
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
PROGRAMMING WITH LARGE OBJECTS
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
LARGE OBJECT UTILITY SUPPORT
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.