Articles & Content

Archives

The Clones have landed - Watch Out! (A09)

Topic: 2008 NA

Subtopic: DB2 for z/OS



DATE: 2008-05-21 (09:45 AM - 10:45 AM)
SPEAKERS: Steen Rasmussen (CA)

This presentation will cover all the details worth to know prior to implementing one of the new DB2 9 for z/OS object types - Cloned Tables. A first view into this new feature might confuse a lot of users since the underlying structure and behavior is quite different from the table types we have been using in the past. Prior to implementing Cloned Tables, it is important to understand how SQL and Utilities work on this new object type in order to understand where a Cloned Table can be useful and satisfy a certain business need. Leaving this presentation, the attendee will be fully armed to attack the Clones.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

What is a Cloned table, where can it be useful and what are the limitations

DDL syntax changes and SQL impact exploiting Cloned tables

Utility changes and considerations when executing utilities against Cloned tables

Catalog changes including attributes when utilizing Cloned tables

Recommendations and experiences based on a case study using Cloned tables



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.