I am having small quick question From the 4 stages(sort,built,replace,recreate_index) of reorg.. in which stage we can pause/stop it. I mean is there any particular stage in which we can do it or we can do it in any stage?
I am asking that in what phase(sort,build,replace,recreate_index) of online/inplace reorg we can pause/stop the reorg? is there any particular phase in which we can do it on in any phase we can do it?
These phases you're mentioning are related to the offline reorg only.
Online reorg has it's own phases described at the link I provided above. db2 does the following small operations cyclically.
- SELECT n pages
- Vacate the range
- Fill the range
So, once again: you can stop/pause the online reorg any time you want.