If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: database consistent no

I'm new to DB2 on AIX. We recently have had many problems with hardware. Everytime we looked at the db2diag log, DB2 said it went through successful recovery. However, I just did a db2 get db cfg, and the output says

Database is consistent = NO

I have heard about DBVERIFY. Is this something I should perform. Is this a problem? This is our production database. Do I need to do a "List indoubt transactions"?

The usage notes say to only use this command "Restart Database" if a connection gets the error message that the database needs to be restarted. How would I know if that message was given to anyone? The previous entry I got from an old entry in this forum said that the database will show inconsistent as long as there are connections to the database and not all the rows that need to be committed have been. Is there an issue here, or when I start the database normally next time(after force applications all and db2stop and db2start), will the database show consistent then? I think this will be the case. Let me know if you think I need to run this "restart database" command.

Since you have had problems with the hardware , the safest bet is to stop the instance and restart it as suggested by Lekharaju ... If the database state is still inconsistent, then you may have to investigate further ...
I would also suggest a backup and a db2iupdt to be extra sure you do not loose data

As suggested in the old post, database consistent NO is not a problem under normal circumstances ...