Results 1 to 6 of 6

Thread: Reorg phase..

  1. #1
    Join Date
    Oct 2013
    Posts
    39

    Wink Unanswered: Reorg phase..

    Hi,
    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?

    Thanks in advance

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    You are not able to pause/stop classic (offline) reorg.
    If you want to force the application doing the offline reorg, read the following article.
    Recovery of an offline table reorganization.
    Regards,
    Mark.

  3. #3
    Join Date
    Oct 2013
    Posts
    39
    Quote Originally Posted by mark.b View Post
    Hi,

    You are not able to pause/stop classic (offline) reorg.
    If you want to force the application doing the offline reorg, read the following article.
    Recovery of an offline table reorganization.

    Hi,

    What about inplace(online) reorg. Can i pause/stop it at any phase of reorg?

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Yes, you can.
    For additional details read the following article.
    Inplace (online) table reorganization
    Regards,
    Mark.

  5. #5
    Join Date
    Oct 2013
    Posts
    39
    Hi Mark,

    Thanks for providing me the link. I have gone through the link which you have given. But my question is still unanswered.

    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?

  6. #6
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Quote Originally Posted by japs1988 View Post
    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.
    Regards,
    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •