Articles & Content


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

Topic: DB2 for z/OS

Subtopic: 2005

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


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

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.