Articles & Content

Archives

ALTER in DB2 10 - Things got easier didn't they?

Topic: DB2 for z/OS

Subtopic: 2012



We’ve all been there – a sudden need to change an attribute of a DB2 object only to find that the ALTER command doesn’t support THAT particular alteration. Faced with an Unload, Drop, Recreate, Reload, sometimes it seems simpler to just leave things alone
Well, DB2 has started evolving and we gained the power of On-Line Schema Evolution a few years ago, but this still had its limitations and there were still common alterations that required a drop/recreate
Enter DB2 10 and Deferred Schema Evolution. Whilst this may still not be the universal panacea for those awkward alters, it does move the goalposts significantly and enables many alterations to be performed as part of a REORG instead



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.