Results 1 to 4 of 4
  1. #1
    Join Date
    May 2010
    Location
    Mexico
    Posts
    3

    Unhappy Unanswered: Rebuilding index

    ADM5541W Rebuilding index with IID "1" in object with ID "5" and table space
    ID "11" on tablename.
    How can I fix it?

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    DB2 is rebuilding the index(es). You don't need to take any action unless it fails. See the following technote for some additional info:
    IBM - How to determine if an index needs to be rebuilt

  3. #3
    Join Date
    May 2010
    Location
    Mexico
    Posts
    3

    Wink Hi Bella

    This is the message that appears.

    ADM5543E Rebuild of indexes on table name failed with SQLCODE of "-952".

    Do you know about this?

    Thanks!

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    It was interrupted. Redo it again and let it run to completion.

Posting Permissions

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