Articles & Content


Attack of the DB2 for z/OS Clones - Clone Tables That Is! (C03)

Topic: DB2 for z/OS

Subtopic: 2007

DATE: 2007-5-7 (01:40 PM - 02:40 PM)
SPEAKERS: John Lyle (IBM Silicon Valley Lab)

In V9 DB2 for z/OS introduces Clone Tables. In this presentation I will introduce the concept of Clone Tables and detail how they work. Clone Tables have several dependencies on other new V9 functionality and I will briefly go over what these dependencies are. I will then indicate how you create Clone Tables tables, and how the data is magically 'exchanged' between the parent/base table and it's clone. I'll then finish up with a discussion of how Clone Tables can be used in a customer environment.

EXP. LEVEL: Beginner,Intermediate


What clone tables are and why the capability was added

How to create, modify, and drop clone tables

How clone tables can be used in a customer environment

How clone tables can be used in disaster recovery scenarios

Learn how the DB2 for z/OS implementation of clone tables might evolve in the future

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.