Checking the Logical Consistency of the Devspaces (SAP Library

Checking the Logical Consistency of the Devspaces

Use

You can check the consistency of the internal data structures in 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).

In ADMIN mode, free storage pages wrongly recorded as used following an abnormal termination of database operation are released to the free space management.

The size of the serverdb determines how long this function will take.

Recommendation

We recommend that you execute this function before each full data backup.

Prerequisites

The database instance is in ONLINE or ADMIN mode.

Procedure

Choose Instance ® Check ® Database and then CheckDatabase ® Verify 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 ® Files. Select the Database Errors file and choose Files ® View.