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