Consistency Checks (iSeries)

You can find out whether tables or indexes are missing from the database or from the ABAP Dictionary. You can also use these checks to determine whether missing indexes are primary or secondary indexes.

To display information on missing tables and indexes, call transaction DB4COCKPIT.

...

       1.      In the navigation frame, choose Space ® State on Disk. 

The Database Performance: State on Disk screen appears.

       2.      Choose Missing indexes .

To find out whether the indexes involved are primary or secondary indexes, choose Consistency checks on the State on Disk screen. A dialog box providing the following options is displayed:

Option

Description

Find database tables without primary keys

Checks for database tables without indexes and provides information on whether they are primary or secondary indexes.

Database<->ABAP Dictionary

Checks for inconsistencies between the database objects and the ABAP Dictionary. If you choose this option, a second dialog box appears. It displays the types of objects that could be missing and the number missing for each type of object.

Select the object type you are interested in and choose OK. A report listing the objects of this type that are missing is displayed.

If a primary index is missing from the database, contact SAP for help with restoring the index. Primary indexes ensure that row keys are unique. There is no simple procedure for restoring a primary index if duplicate keys have been created in the table concerned.

If a secondary index is missing from the database, you can restore it using ABAP Dictionary functions (transaction SE11). These indexes are used for performance purposes only, which means that missing indexes do not represent a risk.

If a view is missing from the database, you can restore it using ABAP Dictionary functions (transaction SE11). Missing views can cause some SAP applications to fail.

If a table is missing from the database, check whether the objects involved are test dictionary objects that were possibly never meant to be in the database.

If objects are missing from the ABAP Dictionary, they may be system objects that do not require an entry in the Dictionary. If you find that a table or index from an SAP application is missing from the ABAP Dictionary, please contact SAP for assistance.

SAP kernel <-> ABAP Dictionary

Checks the consistency of the kernel with the ABAP Dictionary. If errors are found, contact SAP for assistance.