Hi All,
My DB2 ESE 8.1 with FP6 on RedHat Linux has this problem:

DB cfg shows:
Database is consistent = NO

Since there is no current connection, I believe the normal state should be consistent = Yes. I RESTARTed the DB, but it didn't solve the problem.

I ran db2dart, It showed inconsistency in SYSIBM.SYSCOLUMNS's two indexes. I also tried to REORG the indexes. The REORG was successful but didn't solve the problem either.

Because the indexes are on a catalog table, I can not drop and recreate them. How can I "rebuild" the indexes, or how can I solve this problem? On DB2 for z/OS, there is a utility REBUILD INDEX. Is there anything like this on DB2/LUW?

Appreciate your advice in advance.

Check the status of each of the tablespaces:
db2 list tablespaces show detail

Every TS state is Normal.

Try to deactivate the database
db2 deactivate db db-name

Then disconnect all applications. To be sure that all apps are disconnected, issue:
db2 force application all

do a: db2stop and db2start.

check the status again.

Thanks Marcus_A. Your advice worked perfectly.
After I deactivated the DB, I got consistent status. Does this mean this DB had been activated by CMD ACTIVATE because earlier, when the DB was not consistent, there was no application connections.

After this problem is solved, I am still wondering the normal way to rebuild an index. Any advice on that?

Thanks so much!!!!!!!!!!!!!