Articles & Content


DB2 9.7 LUW Newest Online Schema Change Capabilities (F08)

Topic: 2010 NA

Subtopic: DB2 for LUW

DATE: 2010-5-12 (02:45 PM - 03:45 PM)
SPEAKERS: Burt Vialpando (IBM)

DB2 9.7 LUW offers many new online schema change capabilities to help ease DBA maintenance activities. Learn how to use automatic revalidation of objects which can even allow you to create hierarchies of objects without knowing the order they need to be created in. Learn about soft validation to allow you to work with objects even while they are being used. Understand the rules of the new online alter table capabilities which offer extreme flexibility in changing column names, data types and more while keeping the data available. Finally, understand the use of "CREATE OR REPLACE".

EXP. LEVEL: Beginner,Intermediate,Advanced


Auto revalidation - learn what this means and how it works

Create with errors- a special auto revalidation usage, how this works.

Soft validation - maintenance on currently referenced objects, how this works.

Extended online table alter - how this is different from previous versions of DB2

CREATE OR REPLACE - why and what scope

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.