Articles & Content

Archives

DB2 UDB for z/OS V8 Online Schema Evolution (I12)

Topic: 2005 NA

Subtopic: DB2 for z/OS



DATE: 2005-5-25 (12:30 PM - 01:40 PM)
SPEAKERS: Craig Friske (IBM Silicon Valley Laboratory)

Now matter how much time was spent up front designing tables and indexes, changes to the schema will inevitably be required as dictated by changing business requirements. Come see how these changes can be made with improved data availability in the next release of DB2 with the ability to change a column data type, or change attributes on indexes without dropping and recreating objects.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Availiability issues when changing schema

Changing table column data types

Implications for indexes, views, constraints, etc.

Copy and Recover support of versioned objects

Changing index attributes



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.