Articles & Content


IBM DB2 REORG Utility: how to run it successfully in this 24/7 world (I15)

Topic: 2009 NA

Subtopic: DB2 for z/OS

DATE: 2009-5-15 (12:30 PM - 01:30 PM)
SPEAKERS: Ka Chun Ng (IBM Silicon Valley Laboratory)

This presentation first reviews the basics of the IBM DB2 REORG utility: why reorg, what it does and how to run it. Then follows by an indepth analysis of the various tuning and parameter choosing of REORG to achieve optimal performance and availability on various database objects being reorganized. Upon completion of this session, the attendee, whose skill level may range from low to high, will be able to understand how the DB2 REORG utility works, and learn how to execute the REORG utility effectively with minimal outage in today's 24/7 world.

EXP. LEVEL: Beginner,Intermediate,Advanced


Understand what the goal of reorganization is and how the IBM DB2 REORG utility works.

Review the newest improvements to the REORG utility in DB2 V8 and 9.

Review the various features of REORG and how to tailor its execution to different users' requirement.

Provide examples and guidelines as to when REORG should be run, and how to run it with optimal efficiency and availability

Discuss what are the pain points of REORG in users' views and future enhancements

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.