Articles & Content


Online Schema Evolution in DB2 for z/OS

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2015

The ability to modify database structures in DB2 for z/OS has improved radically over the past few releases, culminating in the introduction of the Deferred Alter capability in DB2 10. Further improvements to this were added in DB2 11 allowing a Recovery to a Point in time before the change was materialized, making the feature much more usable for many customers.

This session will summarize the development of Online Schema Change capabilities in DB2 for z/OS with a particular focus on the Deferred Alter feature and the improvements added in DB2 11. In addition Steve will provide a checklist of things to think about when implementing Schema Changes which should help you avoid falling into some traps when changing your database structures.

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.