Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2013
    Posts
    34

    Unanswered: Time Require to rebuild of indexes

    Hi,

    I have 1 very big table whose data is in range of crores.

    When i restarted the server and then database some of the indexes of that table is invalid so rebuilding of indexes is started automatically after crash recovery.

    Can anyone please suggest how to check when (time prediction) this rebuilding of indexes on that table is done?

    I mean how to determine amount of indexing is done and the time to take the completion of indexes?

    Also please suggest can we stop this index rebuilding to load the data in this table?


    Thanks in advance

  2. #2
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    Quote Originally Posted by Pra View Post

    I mean how to determine amount of indexing is done and the time to take the completion of indexes?

    Also please suggest can we stop this index rebuilding to load the data in this table?
    Hi Pra,

    As i understood, Your index recreation is taking a lot of time and you want an estimate about its completion.



    1. You can do "db2top -d <dbname>" ----> then press "u"

    u= utility (progress in real time)

    2. You can query SYSIBMADM.SNAPUTIL_PROGRESS for UTILITY_TYPE = RESTART_RECREATE_INDEX


    i will revert on stopping index creation shortly.
    ssumit

  3. #3
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    Hi Pra,

    I afraid Index rebuilt can not be stopped.

    Just curious why don't you set

    db2 update db cfg using INDEXREC RESTART
    (if DB startup time is not critical)

    This will prevent such situation to happen .
    ssumit

Posting Permissions

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