Checking Database Structures

During a database structure check, the database system checks whether the database structures (for example the B* trees) in the cache and data area are consistent. The data model semantics are not checked, which is why you cannot find logical errors with a database structure check.

Recommendation

Check the database structures once a week.

If you receive one of the following error messages, perform an unscheduled database structure check:

-9053: Data page corrupted

-9023: Illegal entrypos

-9003: Illegal entrylength

-9006: Illegal keylength

-9041: Index not accessible

End of the recommendation.

Procedure

To avoid disrupting operation, you can perform the database structure check on a database copy.

Use one of the following database tools: Database Studio or CCMS (in SAP systems only).

More information:

Database Studio, Checking Database Structures
Database Administration in CCMS,
- Scheduling a Database Structure Check
- Tables/Views/Synonyms (checking a single table)

Result

The database system lists all the commands used in the database structure check in the log files DBM.UTL and DBM.PRT; errors and return codes are also logged there. CCMS user can check the scheduling and the results of the database structure check in the DBA Planning Calendar.

More information: Log Files, Database Administration in CCMS, Displaying Actions

Return code 0 means that the database system found no errors during the database structure check. If the database structure check returns any other return code, proceed as described in Fixing Errors in the Database Structure.

More Information

Concepts of the Database System, Logical Access Structures