Consistency Checks (SAP DB) 

There are two types of inconsistency:

Procedure

Use the Tables/Indexes section in the Detail Analysis Menu to determine whether any database objects are inconsistent.

The available functions are:

Checks

Database <-> ABAP Dictionary: updates the comparison between the R/3 Repository and the database system

R/3 Kernel: consistency check in the kernel

Detailed analysis

Detailed index analysis for a table

Roots

Detailed index analysis for a table. The system reports the root page number for the B*tree created for the index.

Missing indexes

Detailed list of the missing indexes

 

Choose Checks ® Database <-> ABAP Dictionary

You can use already existing consistency checks or create a new one.

The system provides you with the following information:

See also:

Missing Indexes

Database - ABAP Dictionary Consistency

Creating Objects in the Database

Displaying Object Definitions

 

Consistency Check for Structures in the Database System

You can schedule the following consistency checks in the DBA Planning Calendar:

For information about planning consistency checks, see Adding an Action

To display the logs for the consistency checks, use the display in DBA Action Logs