When errors are found upon running a Verify on the data file it is important to note the section the error came from. This is important because pieces of the structure are checked when verifying the records and/or indexes. If the errors were from the section where the structure was being verified, it is possible the problem can be resolved by rebuilding the structure indexes.

Looking at a Verify log file, the following checks are related to the structure:

• Check bit tables for segment 1
• Check bit tables for segment 65
• Checking auto sequence number definitions
• Checking chained list of deleted auto sequence number definitions
• Checking data table definitions
• Checking chained list of deleted table definitions
• Checking index definitions
• Checking chained list of deleted index definitions
• Checking backup index definitions
• Checking chained list of deleted backup index definitions
• Load data tables
• Checking BLOBs in table Resources
• Checking list of deleted BLOBs in table Resources
• Checking records in table Resources
• Checking list of deleted records in table Resources
• Checking BLOBs in table [Table#2]
• Checking list of deleted BLOBs in table [Table#2]
• Checking records in table [Table#2]
• Checking list of deleted records in table [Table#2]
• Checking index B-tree Index 0 on kind (TYPE only)
• Checking index B-tree Index 1 on stamp (stamp)
• Checking index B-tree Index 2 on kind, id (TYPE and ID)