Scheduling a Database Structure Check

Schedule database structure checks at regular intervals in the DBA Planning Calendar. Update the database structure checks, if necessary.

Use the display DB Filling/Tables and Indexes for the consistency checks between the ABAP Dictionary and the database system.

Prerequisites

DBA Planning Calendar

Setting Up and Using the DBA Planning Calendar

Procedure

...

       1.      Observe the planning concept.

       2.      Open the DBA Planning Calendar.

       3.      You can use an action pattern to check the database structure.

       4.      To schedule database structure checks, proceed as described in Scheduling an Action. Use the following actions:

Ў        Check database structure: checks the structure of all tables and indexes.

Ў        Check database structure (tables only): checks the structure of tables.

Result

The database structures are checked at the specified time.

Check the scheduling and the results of the database structure check in the DBA Planning Calendar, as described in Displaying Actions. Use the information displayed in the DBA History. Also use the Database Structure Check display in the Database, or in the liveCache Alert Monitor (OLTP/ liveCache).

See also:

Tables/Views/Synonyms

Concepts of the Database System, Checking Database Structures