Rebuilding index

Morrison01 · #1 (**permalink**) 06-01-10, 11:55

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

db2girl · #2 (**permalink**) 06-01-10, 12:27

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

Morrison01 · #3 (**permalink**) 06-01-10, 13:27

This is the message that appears.

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

Do you know about this?

Thanks!

db2girl · #4 (**permalink**) 06-01-10, 13:33

It was interrupted. Redo it again and let it run to completion.