inconsistent state of the database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James - 22 Dec 2006 03:11 GMT

When I ran db2dart to check a database, I got the following warning and
error messages.
1.Warning: The database state is not consistent.
2.Warning: Errors reported about reorg rows may be due to the
inconsistent state of the database.
3.Found some orphaned extent numbers in a DMS user tablespace.

Any advice on how to change database to be consistent and fix orphaned
data?
Thanks so much!

James

Reply to this Message

jdokos - 28 Dec 2006 21:15 GMT

The incosistent state of the database simply means that there are
changes pending in the database. Most databases that are activated
will be in this 'inconsistent state'. This does not imply corruption,
etc. It just means that if the database were to crash at that moment
it would have to go through crash recovery before one could use it
again. Which is almost always the case.

http://publib.boulder.ibm.com/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/ad
min/r0000282.htm?resultof=%22%63%6f%6e%73%69%73%74%65%6e%74%22%20%22%63%6f%6e%73
%69%73%74%22%20

> When I ran db2dart to check a database, I got the following warning and
> error messages.
[quoted text clipped - 8 lines]
>
> James

Reply to this Message