Articles & Content

Archives

Deep dive in DB2 LUW's offline table reorg and index reorg (D11)

Topic: DB2 for LUW

Subtopic: 2011



In this presentation reviews offline table and index reorg in detail. You learn the offline table reorg phases, when tempspace is used, how much extra storage is needed and sort / no-sort scenarios during table reorg - you get more knowledge about index online and offline reorg. The presentation covers even locking, logging and rollforward recovery/crach recovery scenarios from reorg perspective. We end this session by looking closer to DB2 V9.7 procedure ADMIN_MOVE_TABLE's reorg option.



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.