Simple DB2 Reorg Script – Take 1

I used to run a script that did went thru the reorgchk output and build a script out of it. Even though it worked, I often found it difficult to pick the right index. I rewrote it for scalability and flexiblity. This currently reorgs offline for tables and r/w mode for indexes and will only do non SYSIBM objects.   I thought of making it an inplace reorg. What I don’t like about inplace reorg is , its all asynchronous , so there can be mulitple of them running.  But I have an idea to make it run synchronously and I am working on it. but until then this is what I have.  Feel free to customize it the way that suits you…oh Iam sure y’all will do that.  Here is it :  reorg

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.