SAP Note 940420 - FAQ: Database structure check (CHECK DATA/VERIFY)

Component : MaxDB -

Solution : https://service.sap.com/sap/support/notes/940420 (SAP Service marketplace login required)

Summary :
This SAP Note addresses the database structure check operations such as VERIFY, CHECK DATA, and CHECK TABLE within SAP MaxDB/liveCache environments. It serves as a guideline for customers and support to clarify the procedures and utilities of structure checks in ensuring database integrity and consistency. Essential aspects covered include the frequency and necessity of these checks, the differences between checks in ONLINE and ADMIN modes, and the capability of the checks to repair data or only verify structural integrity. Instructions on how to perform checks via GUI, CLI, and with specific SAP transactions like DB13 or DB13C are also documented. This note does not encompass every possible scenario but offers a substantial foundation for understanding and managing database health in SAP systems.

Key words :
long check]dbmcli db_execute check table <table_name> catalogdbmcli db_execute check index <index_name>, index]dbmcli db_execute check table <tablename> [extended] [, dbm command 'dbmcli db_execute check data, database manager command line interface, database manager graphical user interface, dbmcli db_execute check data [extended] [, dbmcli db_execute check data [extended], dbm command 'db_execute check data', admin operational state                        'check database structure, 6d                        sap maxdb version lower

Related Notes :

1423732FAQ: SAP MaxDB snapshots
1366652MaxDB Version 7.7: Do not cancel CHECK DATA in ADMIN mode
1180845Actions displayed incorrectly in CCMS (runtime > 24 hours)
978717VERIX with MaxDB 7.6 and WebAS 6.*
852168Content Server: Caution with VERIFY/CHECK DATA
846890FAQ: SAP MaxDB Administration
767598Available SAP MaxDB documentation