Tuesday, February 8, 2011

Tips to resolve “object tables or DMS tablespaces are corrupt...” Error

A tablespace in DB2 database can become offline due to various reasons like low system memory (system ran out of space), tablespace corruption, hardware failure, application malfunction, improper system shutdown, and many more reasons. In case of tablespace going offline, a user encounters an error message while mounting the database, which results into inaccessibility of its records saved in tables. Such tablespace corruption scenarios can be handled easily if the user maintains a regular backup. However, if in the user has forgot to create a backup or the backup file is inaccessible, then the user can execute the Recover command to recover the table spaces. While Recover command is handy in recovering tablespaces and pages in them, there are times when the command fails to deliver the desired output. For such situations, a DB2 user needs to opt for effective DB2 database recovery software.

To illustrate the above scenario, here is an error message that appears after the corruption of DB2 tablespaces:

“ERROR: One or more object tables or DMS tablespaces are corrupt. Some tablespaces may not be usable.”

The above error message appears every time the user attempt to mount the database.


As discussed in the error message, tables or tablespaces are corrupt.

Recover DB2 database:

To resolve the above error message and mount the DB2 database, the user needs to follow either of the below steps:

  • Use Recover command to ensure complete recovery of tablespace and table data.
  • Use an updated online backup to restore the data

In case both the above options fail to display the desired output, then the user needs to opt for a third-party DB2 database recovery tool that can repair the database.

Data Recovery Info:

A DB2 recovery utility is powerful utility to recover DB2 database after all logical corruption situations. These DB2 recovery applications are totally non-destructive as they do not make any change in original database. These database recovery tools can be installed on almost all Windows operating systems and are competent enough to recover almost all database objects like tables, buffer pools, containers, views, and schemas.

Applied For:

DB2 (UDB) v8

No comments:

Post a Comment