I have several quick questions about reorg's, and a request (favor).
1. The documentation says that reorg "Reorganizes an index or a table"
I cannot see how one would reorg ONE particular index - is there a way
to do this? More importantly, would you WANT to do this?
2. We plan on doing inplace reorg's due to the 24x7 nature of our
database servers. Are there any "undocumented" issues with these for
V8.1, FP2 or FP6?
3. When you do a table reorg, the manual says that one needs to
"complete all database operations and release all locks before invoking
REORG TABLE." I thought the whole idea of in inplace reorg was that
the application could go on without interruption. Can I start an
inplace reorg without interrupting the users? Is this statement in the
manual true for inplace reorgs?
Request:
Does anyone have a "canned" script for running reorg's? I hate to
reinvent the wheel :-) ! I checked the IDUG and IBM sites, but could
not find any "sample" scripts. I would prefer to tweak an existing
script rather than create one from scratch.
Design:
I plan to use the output of the reorgchk command to drive the reorg
script, doing only those tables that are marked as needing a reorg. If
possible, I also hope to do this for those individual indexes that are
marked as needing a reorg. I understand that it is best to do an
"index all" reorg after a table reorg, so I may add this step after
each table reorg to the script.
Of course, this design depends on how long all this takes. Our
databases are not "huge" (they average about 2 GB), but I have no idea
how long these reorgs will take until I test them out.
Thanks in advance!