Articles & Content


What do Clones do on Mother's Day? An Overview of the Strange New World of the Clone Table (H15)

Topic: 2009 NA

Subtopic: DB2 for z/OS

DATE: 2009-5-15 (12:30 PM - 01:30 PM)
SPEAKERS: Gregory Parrish (CA)

In previous releases of DB2, users expressed the need for a functionality that is similar to an online LOAD REPLACE utility. Introduced in DB2 9, clone table support provides users with the ability to generate a table with the exact same attributes as a table that already exists in the current DB2 subsystem. The clone is created within the same universal table space as the base table, and is structurally identical to the base table in every way. Once created, a clone table can be manipulated independently of the base table, and you can exchange data between the base table and the clone table. Clone tables thus provide the functional equivalent of an online LOAD REPLACE utility, allowing users to, for example, reload table data multiple times a day while still being able to access the existing data with read-only operations. This presentation will examine the new clone table feature, discussing concepts, advantages, commands and restrictions (including the new UTS table space type).

EXP. LEVEL: Beginner,Intermediate


Learn what a clone table is and why you might want one (or several).

Become familiar with clone table concepts, objects, advantages, and restrictions.

Gain an understanding of the new DB2 9 universal table space type.

Learn how to exchange clone and base table.

Learn how to use utilities efficiently for clone table objects - including backup and recovery.

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.