Articles & Content


Unloading and Loading LOB data in DB2 for z/OS becomes reality. (G09)

Topic: 2006 EU

Subtopic: DB2 for z/OS

DATE: 2006-10-4 (11:00 - 12:00)
SPEAKERS: Davy Goethals (Arcelor Technologies)

Recently IBM introduced an enhancement to DB2 V7 and V8 to allow LOB data bigger than 32K to be unloaded and loaded using the standard DB2 Unload and Load Utilities. In this presentation , this new function will be explained in depth, based on experiences gathered during a 5 month IBM beta program in which the presenter participated.

EXP. LEVEL: Intermediate


How are LOBs (Large objects)implemented in DB2 for z/OS and what were the current restrictions.

What exactly are the new features introduced by apar PK10278 in DB2 V7 and DB2 V8.

How to unload LOB data using the enhanced UNLOAD features. Benefits to other techniques.

How to load LOB data using the enhanced LOAD features. Benefits to other techniques.

When to use the enhanced UNLOAD/LOAD features instead of the REORG utility.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.