Find symptoms of corruption

You can find information about corruption several different ways.

The database server alerts the user and administrator to possible corruption in the following ways:
  • Error messages reported to the application state that pages, tables, or databases cannot be found. One of the following errors is always returned to the application if an operation has failed because of an inconsistency in the underlying data or overhead information:
    -105 ISAM error: bad isam file format
    -172 ISAM error: Unexpected internal error
  • Assertion-failure reports are written to the database server message log. They always indicate files that contain additional diagnostic information that can help you determine the source of the problem. See Verify consistency.
  • The oncheck utility returns errors
  • The ph_alert table shows information about corrupted indexes.

Copyright© 2018 HCL Technologies Limited