Articles & Content

Archives

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

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



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.