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