Tech Library

    IDUG is proud to offer the latest in DB2 information straight from those who know it best: database administrators (DBAs), database managers, application programmers and developers, vendors and other IT professionals who use DB2 daily.

    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


    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.

    Copyright © 2015 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact