Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2016
    Posts
    16

    Unanswered: Reorg utility was interrupted

    Hi everyone,

    My name is siva. I am a fresher and working at client location. Today I have a big problem please help me to solve it.

    Today I am performing reorg utility on some tables all are successful at the end of the time i performed reorg utility on one large table it takes so long time so i canceled it by pressing ctrl+c . now what will happen?

    is the data will be in inconsistent state?

    if the data is in inconsistent state how can i solve it?

    plz help me.....


    thanks
    siva_prabhala.

  2. #2
    Join Date
    Aug 2016
    Posts
    50
    Provided Answers: 2
    online reorg or offline reorg ?

    if offline reorg u forced off check the status of table and check sysibmadm.admintabinfo column required_index_rebuild column

    if its online reorg, mostly all gets rolled back..

    regds
    paul

Posting Permissions

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