Articles & Content


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

Topic: 2011 EMEA

Subtopic: DB2 for LUW

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.