The Check command checks the metadata for internal inconsistencies. This applies to the metadata information in the Data Vault and the Data Vault repository.

Specify TABLES to check the validity of selected archived tables in the Data Vault repository, FILES to check the validity of selected data files registered with the Data Vault repository, or ALL to check all metadata information. If there is a problem with the metadata, a diagnostic message describing the nature of the problem will be returned.

When TABLES or FILES is specified, the validity check is limited to the list of, respectively, table IDs (archived tables) or file IDs (data files), separated by whitespace. Note that table IDs can be determined using the Tables command, while file IDs can be determined with the Files command.

If the FULL keyword is included, there is an additional comparison of the metadata in data files against the Data Vault repository for discrepancies. As this comparison can require a significant amount of time, it is not the default behavior.

If Check is executed without any parameters, only a basic validity check of metadata in the Data Vault and the Data Vault repository is performed.

To verify the integrity of data files only, use the CheckSCT command.

If unreferenced objects (for example, data files associated with a non-existent archived tables) are found in the metadata, they can be removed using the Cleanup command.