Data management

You have several options when identifying and diagnosing inconsistent data.

Resolving inconsistencies manually
If you cannot resolve an issue by using the RECOVER utility, you might need to manually determine the cause of a data or index inconsistency and resolve the problem. Be sure to keep a complete record of the actions you take.
Inconsistency resolution with RECOVER TABLESPACE and RECOVER INDEX
The RECOVER and REBUILD INDEX utilities provide the easiest way to recover inconsistent data that is indicated by abend reason codes 00C9010x or 00C902xx.
Diagnosing DBD inconsistencies
You can locate a database descriptor (DBD) by using the REPAIR DBD utility or in a dump, and analyze the structure of the DBD.

Parent topic: Troubleshooting problems in Db2