Archive for the ‘DB2 Database Repair’ Category

How to restore corrupted DB2 Database?

Friday, March 19th, 2010

When we talk about relational database management system (RDBMS), DB2 database is one of them and talking with respect. It’s an IBM product so it safely stores data and you can easily manage and access data. Mainly DB2 database is used to store different types of “data/records/information” in tables. The tables are stored in the “tablespace”.

As we know, “Tables are the most critical part in any relational database management systems”. In DB2 database “tablespace” acts as container that stores various tables. In case of logical or physical error may encounter error messages. And finally you may unable to access the stored data/information/contents. It is because of corrupted, damaged or inaccessible DB2 database.

Here DB2 database users need backup to restore DB2 tables and tablespaces. To perform “corrupt DB2 database restoration” you should a utility named as “Database Restore”. Here you can use different restoration models such as – simple, full or bulk restoration. In case of its failure you may move ahead for advanced DB2 Database Repair utility.

DB2 Database Repair software is a cool but all in-one solution for any DB2 database issue. Its effective application will resolve your all issues related to DB2 database management system.

Repair Corrupt Tablespaces In DB2 Database

Monday, March 8th, 2010

DB2, also referred as Database 2, is a popular RDBMS (Relational Database Management System). It is designed, developed and powered by IBM. Like others relational database management system, DB2 also corrupt, loose data and even data can go in in-accessible mode. These corruption or damaging DB2 database table or tablespaces could be due to improper shutdown the system, virus or Trojan attacks or human errors. Hardware failure i.e. broken or damages system or hard disk may also lead data loss or table corruption in DB2 database.

Under this failure or corruption of DB2 database tablespaces you may get error message such as:

SQL0293N Error accessing a tablespace container SQLSTATE=57048”

In such situation only repair DB2 Database and restore backup file help you to make accessible database tables once again. In case of updated backup, it may lead your issue. To troubleshoot this error message you can use “db2dart” command. If the above error message caused due to hardware problem, first you need to replace that issue. In case of failure of the above steps, you may go for DB2 Database Recovery Software tool. Today various professional database recovery tools are available. Choose any one and easily recover all deleted, corrupt and inaccessible DB2 Database tables and tablespaces.