469,950 Members | 1,933 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

inconsistent state of the database

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

Dec 22 '06 #1
1 13240
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/infoce...69%73%74%22%20

On Dec 21, 10:11 pm, "James" <huyu...@gmail.comwrote:
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
Dec 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Byron Morgan | last post: by
2 posts views Thread by gangulyarindam | last post: by
3 posts views Thread by mairhtin o'feannag | last post: by
1 post views Thread by Peter Knörrich | last post: by
3 posts views Thread by codeman | last post: by
3 posts views Thread by Rahul Babbar | last post: by
reply views Thread by johnthawk | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.