Recovering DB2 Database Post "SQL0980C A disk error occurred..." Error by:Mark Willium

Are you receiving an error message while taking a DB2 database backup

? Or an error message pops up while restoring the database backup? If the answer for any of the above questions is 'yes', then there are possibilities of DB2 database corruption. Damage in DB2 database can occur due to both logical (improper system shutdown, application malfunction, virus attack, concurrent execution, and operating system malfunction) and physical (heat, water, accidental drop down, and natural disasters) reasons. While database recovery from a physically damaged hard drive can only be performed by a reputed data recovery organization, the logically damaged DB2 database can be repaired using a third-party DB2 Repair software.

For deep explanation of the above scenario, take a real-time situation where you want to create a backup of your DB2 database. You run the backup command, and the backup process starts. However, when the database backup process is in progress, you encounter the below error message:

"SQL0980C A disk error occurred. Subsequent SQL statements cannot be processed."

After the above error message appears, the DB2 database backup process halts. In addition, the database becomes unmountable after the above error message appears. The records saved in the database also become inaccessible. On viewing the db2diag.log file, you see the below error message:

"MESSAGE : ADM6023I The table space "SYSTOOLSTMP" (ID "28") is in state

0x"0". The table space cannot be accessed. Refer to the documentation for SQLCODE -290. "

Cause:

The above error message appears when the database gets logically damaged.

Resolution:

To resolve DB2 database corruption and to get past the above error message, you will need to take underneath actions:

Use another backup file (standby database) and perform complete restoration.

However, the standby database does not contains all those changes that you made recently. So, if you need to access the updated database with all the recent changes, then you will need to repair the database using an effective DB2 Recovery utility. Such DB2 Database Repair tools use effective recovery techniques to repair any logically damaged DB2 database.

DB2 Recovery is a pioneer in recovering databases corrupted due to logical crash. Compatible with IBM DB2 (UDB) v8, the read-only DB2 Recovery software is competent enough to recover almost all database objects. The user-friendly tool is designed for Windows 2003, XP, and 2000 operating systems.

About the author

I have completed my Ph.D in computer science and currently doing research on how to recover and repair corrupted database. During my research i found many third party software for several database recovery like sql database repair, mdf recovery, db2 recovery and many more. i am sharing my experience and knowledge with you all. For more details visit: http://www.db2databaserecovery.com/

POST COMMENT

Yahoo Store Design Services - Gateway for Better Business by:Jessica Woodson Recovering SQL Server Database From Error: 5171 by:Mark Willium DBCC CHECKTABLE Displays 8966 and 8944 Error Messages by:Mark Willium Like Broadband...but Faster! by:Chris Holgate How Modem Technology Has Changed the Way We Communicate by:Chris Haycox Finding The Best Kyocera Mita Color Toner by:Steve White Purchasing Kyocera Mita Color Toner by:Steve White Why You Should Use Kyocera Mita Toner by:Steve White Prolific Viruses by:Chris Holgate A Look At An Excellent Example Of Kyocera Mita Color Laser Printers: The FS-5300DN by:Steve White High Growth Predicted in Egyptian Telecom Sector - RNCOS by:RNCOS E-Services Pvt. Ltd. Use Business VoIP Service To Maximize Your Profits by:Dennis Smith Microsoft SQL Database Hosting by:John Anthony