Table of Contents

Search

  1. About the Data Vault Administrator Guide
  2. Introduction to the Data Vault
  3. Data Vault Service Startup and Shutdown
  4. Data Vault Configuration
  5. Data Vault SSL Setup
  6. Data Vault ODBC Setup
  7. Data Vault Administration
  8. Data Repartitioning
  9. Partial Data Vault Copy
  10. Archived Data Migration
  11. Bulk File Uploader
  12. Data Vault Administration Tool
  13. Data Vault Logs
  14. User Account Privileges
  15. ssasql Command Line Program
  16. Data Vault Audit Log
  17. Sample Configuration Files

Data Vault Administrator Guide

Data Vault Administrator Guide

Checking Data File Integrity

Checking Data File Integrity

The CheckSCT command checks one or more registered data files for integrity errors.
CheckSCT { ALL | TABLES <table ID list> | FILES <file ID list> } [ LEVEL:{1|2|3} ]
The CheckSCT command can be applied to all data files registered in the Data Vault repository (ALL); or can be applied to all of the data files registered with one or more specific tables (TABLES); or can be applied to a list of one or more specific compressed data files (FILES). The TABLES option must specify a list of table IDs, separated by whitespace. Similarly, the FILES option must specify a list of file IDs, separated by whitespace.
Optionally, LEVEL:
n
can be included to set the level of integrity checking. There are three possible levels:
  1. Check the metadata only.
  2. Check the encoded data only.
  3. Perform all checks on the compressed data file.
Generally, the higher the level, the more time is required to complete the CheckSCT command. Depending on the size and number of data files being checked, this command can take quite a long time to finish executing, especially at LEVEL:3.
The CheckSCT command is equivalent to executing the
ssau -ch
command.

0 COMMENTS

We’d like to hear from you!