Articles & Content

Archives

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

Topic: DB2 for z/OS

Subtopic: 2006



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

OBJECTIVES:

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.



Click Here to Download

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