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

Common Configuration

Common Configuration

There are some common parameters that can be set in multiple ssa.ini sections, allowing different components to use different parameter values. However, if the same parameter value is required for different components, there is an alternative to setting the same parameter multiple times: The COMMON section is where common parameters can be set once for all or some of the Data Vault Service components.
A common parameter is first sought in its proper section. If it is not found there, the COMMON section is checked. So in order for a common parameter to be used, the parameter should be set in the COMMON section and also omitted from the sections that will make use of this common parameter. A common parameter can be set in both the COMMON section and a specialized section, but the specialized section value will override the common one.
Note that the default value of a common parameter will be used only if there is no valid value in both the specialized section and the COMMON section.
The following are the parameters that can be set in the COMMON section, along with the other sections where they can appear:
  • EXEHOST – [SERVER], [AGENT], [ADMIN]
  • EXEPORT – [SERVER], [AGENT], [ADMIN]
  • LOGDIR – [SERVER], [AGENT], [STARTER]
  • SHAREDIR – [SERVER], [QUERY]
  • TEMPDIR – [SERVER], [QUERY], [EXPORT], [MERGE]
  • IDVCHARSET
  • MAXNUMLEGALHOLD

Source Data Encoding

The
IDVCHARSET
parameter gives you the choice to represent source data as either extended ASCII or UTF-8 in Data Vault.
To designate ASCII or UTF-8 encoding for source data, add the following parameter to the
ssa.ini
file:
IDVCHARSET=
When you provide an "ASCII" value, the
IDVCHARSET
parameter enables ASCII mode and handles source data as sets of bytes in the range 0x00-0xFF. For example:
IDVCHARSET=ASCII
If you provide an "UTF-8" value, Data Vault handles all object names and string data as UTF-8 compliant. For example:
IDVCHARSET=UTF-8
Do not switch to ASCII mode on a Data Vault installation with archived or retired data. This results in a combination of ASCII and UTF-8 data, which may cause some Data Vault functions to fail.

Maximum Number of Legal Holds

Add the MAXNUMLEGALHOLD parameter to the COMMON section of the ssa.ini file to set the maximum number of legal holds allowed per table. By default, the maximum number of legal holds allowed per table is 256, but you can configure the parameter up to 16384.

0 COMMENTS

We’d like to hear from you!