Simple Offline DB2 Reorg Script – Take 2

A few weeks back, I had published a script that will dynamically create a reorg script and execute it.   Now I have made few modifications to it.  The new script does couple of things more :

  • It has an exclude list . Any table name or index name will be excluded from the reorg script
  • It now includes the “USE” temporary tablespace feature.
  • It will also email the reorg report to an email address

Offline or classic reorgs are much faster and lot more efficient. It however needs exclusive access to the table.  Here is a new script : reorg.zip   The zip has two files, one is the reorg script and the other one is called from the reorg.sh that generates the report.

About rpillai

I am a technology enthusiasts and love to work with databases and other technology. Learning new things everyday and don't think the path ever ends ...
This entry was posted in db2 and tagged , , , , , , , . Bookmark the permalink.