Solving 'the Database State Is Not Consistent' Error

DB2 databases are often the repository of business data

, so it becomes imperative that the data within these database must remain consistent, both logically and physically. One of the critical components that help maintaining the consistency of a DB2 database is transactions, which can get interrupted unexpectedly. If an interruption occurs before all the transactions have been committed or all the modifications have been completed, the database is left in an unusable and inconsistent state. As a crash recovery measure, you need to apply the last available backup or perform some practices to Recover DB2 Database.

A DB2 database can be checked for architectural correctness and consistency of its objects by a command-line tool called db2dart. At times, when you run this tool to check the integrity of your database, it might return you all or an error message, such as below:

The database state is not consistent.

Or

Errors reported about reorg rows may be due to the

inconsistent state of the database.

Or

Found some orphaned extent numbers in a DMS user tablespace

The database might ot might not be accessible.

Explanation

The errors indicate inconsistent state of DB2 database, which doesn't always imply database corruption. This can simply mean that there are still some changes that need to be applied on the problem database.

Transaction failure occurs due to situations that cause database manager or database to stop unexpectedly. These situations can be power failure, hardware failure, or operating system problems.

User Action

To rollback the incomplete work, run RESTART DATABASE command. You need to specify WRITE RESUME option of this command if in case, the database I/O was suspended prior the crash.

If the above crash recovery doesn't resolve the existing problem, your database is severely corrupted. Thus, you should restore it from the last hot or cold data backup. If none of the valid backup is available, you need to use a third-party db2 database repair utility. These tools can scan your corrupted DB2 database and Recover DB2 Database and its objects in exact format and view.

DB2 Recovery is a high-end tool that can scan and repair your corrupted DB2 database with just few simple clicks. The db2 repair tool supports IBM DB2 (UDB) v8 and recovers all database tables, triggers, buffer pools, containers, and other objects. The software comes with a user-friendly interface that makes the application easily operable.

by: Adishree Singh

POST COMMENT

Resolving bad Container Path Error In Db2 Error In File Exe - Here is a Tip ! Organizational Chart Software Cfg Popup Error - Wait - Fix it Now! Fix Error Code 39 - Best Solution to Fix Error Code 39 Now! Fix Code 43 Driver Error - How to 100% Fix the Code 43 Driver Error Now! Tips To Solve 'ora-1578' Error' Fix Code 45 Driver Error - How to 100% Fix the Code 45 Driver Error Now! Fix Code 46 Driver Error - How to 100% Fix the Code 46 Driver Error Now! Bp's Fatal Design Errors Ares- A Software That Gives You Faster Accessibility to a Wide Data Source Fundamentals of Custom Software Development Outsourcing Using Best Forex System Trading Software In Forex Trading