Articles & Content

Archives

DB2 V10: If You Don’t Like It ALTER It - B09

Topic: 2012 NA

Subtopic: DB2 for z/OS



DB2 10 for z/OS allows you to make changes to database objects (indexes and table spaces) while maximizing the availability of the altered objects. Through enhancements to ALTER statements, you can now change indexes and table spaces without having to unload the data, drop and re-create the objects, regenerate all of the security authorizations, re-create the views, and reload the data. This session explores the Schema Enhancements introduced in DB2 10 that impact performance and availability using examples tested on our sandbox subsystem.



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.