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

QUERY Section

QUERY Section

The QUERY section of the ssa.ini file contains the parameters for queries sent to the Data Vault.
The following table describes the parameters in the QUERY section of the ssa.ini file:
Column
Description
MEMORY
The total amount of memory (in MB) to be used for query result sets. Memory is allocated dynamically up to this amount as required. Note that the specified value must be greater than 0.
Default is 1024
THREADS
The number of threads used when querying the compressed data file.
Default is 2.
TEMPDIR
The directory for Data Vault temporary data files. To improve performance, use a local directory.
Default is <DataVaultServiceDirectory>/temp.
VFS
The directory location of a virtual file system. Instead of creating a number of temporary data files, the Data Vault Service stores the temporary files in a single file container.
If this parameter is absent or empty, the Data Vault Service uses the standard file system in the location specified by the TEMPDIR parameter.
SHAREDIR
The network location where temporary files for GROUP BY and ORDER BY queries are stored. This location must be accessible to any machine that runs the Data Vault Agent.
Default is <DataVaultServiceDirectory>/share.
INDEXDIR
The directory where the Data Vault stores index files when you create indexes for archived tables.
Default is <DataVaultServiceDirectory>/index.

0 COMMENTS

We’d like to hear from you!