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