Checks the database for data and structural integrity.
VALIDATE errorlogFile
errorlogFile | Name and optional path of destination file for error messages. If no path is specified, the specified list file is stored in the current application\database directory. |
This command validates the current database. You must select a database before issuing this command.
The VALIDATE command checks the following information:
If this command finds integrity errors, it writes
validation process error messages to a text-format log
file. The default location for the specified file is in
the application\database directory. For example:
ESSBASE\APP\app\db\VALIDATE.LST
.
database_name.OCL
,
when it grows too large. database_name.OCL
is a file used
for incremental restructuring. VALIDATE causes Analytic Services to restructure
any blocks whose restructure was deferred, and clears the file. alter
database DBS-NAME begin archive to file FILE-NAME;
VALIDATE VALERROR.TXT;
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |