You check whether the database structures of a database instance are consistent.
We recommend that you check the database structures once a week.
This check is extremely CPU intensive and time consuming because many I/O operations have to be carried out. Plan checks in the production system only for times when the load on the database system is reduced or carry out the check on a system copy (see Concepts of the Database System, Creating a Homogeneous System Copy).
The database instance is the ONLINE or the ADMIN operational state.
...
...
1. Select the required database instance in the list of database instances and choose Instance ® Check ® Database Structure.
2. Choose the required function and specify the relevant options in the following step.
Functions and Options for Checking the Database Structure
Function |
Operational State |
Command |
Options |
Checking the entire dataset |
ONLINE |
Check database structure in operational state ONLINE |
EXTENDED: The length and ascending order of the keys are checked, among other things. EXCEPT INDEX: Indexes are not checked. This option usually speeds up the check. |
Checking the entire dataset and cleaning the converter |
ADMIN |
Check database structure and clear converter in operation state ADMIN |
EXTENDED: See above. |
Checking a selected table |
ONLINE |
Check database structure for a selected table in operational state ONLINE |
EXTENDED: See above. WITH LONG CHECK: If the basic table to be checked contains LONG columns, the system checks whether all the LONG values defined actually exist. To ensure the consistency of the transaction, an SQL read lock is requested for the duration of the check. CATALOG: The database catalog for this table is checked. This option cannot be combined with the EXTENDED and WITH LONG CHECK options. |
3. To start the database structure check, choose Start.
4. After the check has been completed, choose Close.
Errors encountered during the database structure check are written to the Database Errors database file. You can open this file to analyze these errors (see Reading Database Files).
See also:
Concepts of the Database System, Checking the Database Structures