subject: Troubleshooting "Error: DB21034E the command was processed..." Error by:Mark Willium [print this page] DB2 table spaces are the actual structures that store database tables. There can be numerous physical and logical factors that might corrupt the table spaces, consequently rendering database tables inaccessible. Table space corruption can be detected by an error message that comes up when you try to mount the affected table. Such situations can be effectively and safely dealt with, if a valid and updated backup is available. But when there is no such backup present that can be used to restore inaccessible data, the last resort is to use a DB2 Database Repair utility.
Reportedly, there are many instances that depict table space corruption in a DB2 database. For instance, consider a realistic problem when hardware failure occurs on a computer running DB2 database. After this, the table space is marked as offline with a specific state, for say '0x4000'. The failed hardware is replaced, but when the user tries to switch the offline table space back to online state, it doesn't proceed as expected. On each attempt of doing so, the following error message pops up:
"Error: DB21034E the command was processed as an SQL statement because it was not a valid Command Line Processor command."
Running DB2DART confirms that the database table space in issue is corrupted as this gives the below error message:
"ERROR: One or more object tables or DMS tablespaces are corrupt. Some tablespaces may not be
usable."
Here, the root of table space corruption is hardware failure.
Solution
Following are the basic solutions to resolve the given issue. Apply the one that suits your requirements:
Drop the affected table space and recreate a new one with the original attributes
Restore the database from last available stand-by or cold backup
Use a third-party DB2 Recovery tool
DB2 Database Recovery software are exclusive tools designed with safe technology to scan and repair corrupted DB2 database. These tools are created by smart programmers to analyze a corrupted DB2 database and extract all the valuable data in readable format. Special consideration is given to maintain the originality of database contents.
DB2 Recovery Software is a high-end secure application that can repair and restore corrupted DB2 database using powerful algorithms. Supporting IBM DB2 (UDB) v8, this DB2 Recovery utility can restore all database objects like, tables table spaces, containers, triggers, buffer pools, views, and more. It is compatible with Windows 2003, XP and 2000.
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 repair and many more. i am sharing my experience and knowledge with you all. For more details visit: http://www.db2databaserecovery.com/
