Articles & Content
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.