Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Fault tolerance
Consistency checking
Perform periodic consistency checking
Verify consistency
Validate indexesIf an index is corrupted, the database server cannot use it in queries.

Validate indexes

If an index is corrupted, the database server cannot use it in queries.

You can validate indexes on each of the tables in the database by using the oncheck -cI command.

In addition, the Scheduler task bad_index_alert looks for indexes that have been marked as corrupted by the server. This task runs nightly. An entry is made into the sysadmin:ph_alert table for each corrupted index found by the task.

If an index is corrupted, drop and recreate it.