Using VALIDATE to Check Integrity
The VALIDATE command performs many structural and data integrity checks:
•Verifies the structural integrity of free space information in the index.
•Compares the data block key in the index page with the data block key in the corresponding data block.
•The Essbase index contains an entry for every data block. For every read operation, VALIDATE automatically compares the index key in the index page with the index key in the corresponding data block and checks other header information in the block. If it encounters a mismatch, VALIDATE displays an error message and continues processing until it checks the entire database.
•Restructures data blocks whose restructure was deferred with incremental restructuring.
•Checks every block in the database to make sure each value is a valid floating point number.
•Verifies the structural integrity of the LROs catalog.
Note:
When you issue the VALIDATE command, we recommend placing the database in read-only mode.
As Essbase encounters mismatches, it records error messages in the VALIDATE error log. You can specify a file name for error logging; Essbase prompts you for this information if you do not provide it. The VALIDATE utility runs until it has checked the entire database.
You can use the VALIDATE command in ESSCMD to perform these structural integrity checks.
During index free space validation, the VALIDATE command verifies the structural integrity of free space information in the index. If integrity errors exist, Essbase records them in the VALIDATE log. The file that you specified on the VALIDATE command holds the error log.
If VALIDATE detects integrity errors regarding the index free space information, the database must be rebuilt. You can rebuild in three ways:
•Restore the database from a recent system backup
•Restore the data by exporting data from the database; creating an empty database; and loading the exported data into the new database.
•Restructure the database
