Checking the Logical Consistency of the Volumes 
Use
You check the consistency of the internal data structures of the current
database instance. If there are serious inconsistencies, the database instance must be recovered in the same way as after a disk failure (Recovery).
If you execute this command in the
ADMIN
operational state, free storage pages wrongly recorded as used following an abnormal termination of database operation are released to the free space management.
We recommend that you execute this function before each
full data backup.
Prerequisites
The database instance is the
ONLINE or the ADMIN operational state.Procedure
Choose Instance ® Check ® Database Structures and then DatabaseStructures ® Execute to start the logical consistency check.
Result
The information supplied by the database kernel is written to the
Database Errors file. To view the contents of the file, choose Instance ® Check ® Diagnosis Files. Select the Database Errors file and choose DiagnosisFiles ® View.