Articles & Content


DB2 9.7 LUW Newest Online Schema Change Capabilities (F08)

Topic: DB2 for LUW

Subtopic: 2010

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

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.