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

Data Vault Performance Tuning

Data Vault Performance Tuning

Use the ssatune utility to tune the Data Vault system and update configuration files based on evaluated hardware resources.
The ssatune utility performs the following tasks:
  • Analyzes available system resources and calculates Data Vault configuration parameters based on CPU and RAM.
  • Analyzes meta query response time and sets the optimum query execution mode for the metadata layer.
  • Tunes the metadata server configuration.
  • Analyzes the Data Vault temporary storage requirement based on current archive volume and returns a recommendation.
  • Refreshes metadata catalog indexes to optimize internal query response time.
  • Performs metadata database garbage collection to improve overall metadata layer performance.
  • On UNIX systems, operates in high availability mode, which minimizes the Data Vault system down time in the event of an abnormal termination or unexpected shutdown.
  • Evaluates I/O response time.
  • Updates Data Vault configuration files and performs a backup of the existing configuration.
  • Generates a report about current system resources and recommended configuration changes.
The ssatune utility operates in one of the following two modes:
  • Evaluation and report only
  • Evaluation and apply changes
The ssatune utility uses the following syntax:
ssatune [ <flags> ] [-h (displays the help screen)] [-m{0,1} (report only vs. update configuration)] [-t <temporary file directory>]
You can specify the flags in any order. The following table describes the flags:
Option
Description
-h
Displays the help screen.
-m
Enter 0 to generate a report about system resources and recommended configuration changes.
Enter 1 to update the configuration based on the recommendations.
Default is 0.
-t
Location of the temporary directory for log, report, and run-time files. When you run the utility, it generates a log and a report in the temporary directory. The log file contains information about the functions that were successfully called and exited. The report contains information on the parameters that were updated and by how much.
When the ssatune utility is finished, it generates a shell script named
fasd.sh
in the Data Vault root folder. The utility also configures the
ssa.ini
file settings in the STARTER and META sections to enable Data Vault process controls through the generated script. After ssatune generates the script, you can use the script to manage all Data Vault processes.
To start the Data Vault system, run the following command:
../fasd.sh start
The following message appears: "Starting-> IDV components"
To stop the Data Vault system, run the following command:
../fasd.sh stop
The following message appears: "Stopping IDV components"

0 COMMENTS

We’d like to hear from you!