Monday, January 24, 2011

How to resolve Table Space corruption in DB2 database

DB2 is an enterprises RDBMS that offers efficient data safety & stores the data in tables. The database tables are further stored in the table space. If the table space gets damaged or corrupted due to some reason, then all the tables become inaccessible.

DB2 table space may get damaged due to several reasons, which include both logical and physical factors.

Reasons of Table space corruption:

  • Table space get corrupted due to hardware failure, virus attacks, application corruption etc.
  • Single Table corruption cause of Table Space corruption.
  • Tables becomes inaccessible due to some error.
  • DB2 table space is marked as offline after a hardware crash. When you resolve hardware problem & try to change the state of the table from offline to online. The state does not change & give some error this is the cause of table space corruption.

Resolution

You can resolve above issues and recover DB2 data using any of the below steps-

  1. Drop the faulty table space and then recreate it.
  2. Restore DB2 database from recent updated backup.
  3. When all two steps fails, use third-party DB2 repair software to recover corrupt Table Space.
The DB2 repair software are totally safe and easy to use and are very much useful for all above issues.

Stellar Phoenix DB2 Recovery is a secure application that repairs and restores damaged DB2
database using powerful DB2 database recovery algorithms.

No comments:

Post a Comment