Rectifying Error 204 In Corrupted Db2 Version 8 Database

DB2 or Database 2 is a relational model database that is designed by IBM. It is used by many reputed organizations as the backend support. It gives you the freedom to operate the databases either from a command line argument or from its GUI (Graphic User Interface). However, sometimes the DB2 database gets corrupted due to various reasons such as bugs in the database software, database header corruption, improper system shutdown, virus infections, etc. In such cases, you should try to resolve the error using appropriate methods. If you are not able to recover DB2 database, then you should use a third-party DB2 database recovery software to do the needful.

Consider a scenario wherein you are using DB2 version 8 database. You run the Select query to fetch some records, but it fails to execute. An error message is displayed, that is:

“DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 DB2ADMIN.TABLE" [SELECT
* FROM IDSC.TABLE]”

Where, db2admin is the user id.

Cause
The root cause of this erroneous situation is that the identified object is not defined in the DB2 subsystem. You may have issued COMMENT ON PACKAGE without providing a version. Because of this, DB2 has internally opted for the NULL version but could not find the NULL version. Another cause for this error is that the DB2 database is corrupted.

Resolution
To resolve this situation, you should perform the following steps:
.Verify that the SQL statement is correct by checking the object name including the qualifiers.
.If the SQL statement is correct, then check the object exists in the database. If it does, then execute the SQL statement again.
.However, if the null version is not there, then you should drop the specific version by using the VERSION clause. This should resolve the issue.

However, if you are facing the similar problem even after performing the aforementioned steps it means that the DB2 database is corrupted. In such cases, you should use a third-party db2 database repair software to recover DB2 database. Such tools are read-only in nature that do not overwrite the existing database while scanning using fast yet sophisticated scanning algorithms.

Stellar Phoenix DB2 Recovery is a DB2 database recovery software that is able to recover DB2 database from all instances of corruption. It is able to recover DB2 database components such as triggers, tables, schemas, views, containers, buffer pools, etc. In addition, this db2 recovery utility provides two option to recover the DB2 database, automatic and manual. It is compatible with Windows Server 2003, XP, and 2000.

By: Adishree Singh

Article Directory: http://www.articledashboard.com

Adishree Singh work as a freelancer and researcher db2 database recovery & recover db2 database software.