Data Vault Administrator Guide

6.5
- 6.5.1
- 6.5 HotFix 1
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Query Statistics Log

The Data Vault can be configured to export query statistics to CSV (Comma-Separated Values) files, from which the information can be loaded into a database table for analysis and manipulation. The exported statistics include such things as query timings, number of data files processed, and the amount of disk space required for temporary files, recorded for each individual query.

The query statistics log can be enabled or disabled, and the maximum log file size can be set, through the ssa.ini file.

The following table describes the query statistics log parameters that are set in the [SERVER] section:

Parameter	Description
STATLOG	Enables or disables the query statistics log. The possible values are ON (enable) and OFF (disable). By default, the query statistics log is enabled. When enabled, the query statistics are continuously written to CSV files in the directory location specified by the LOGDIR parameter.
STATLOGLIMIT_FILESIZE	Sets the maximum size of each log file in bytes. When the size limit for the current log file is reached, it is renamed, and the query statistics are written to a new log file. By default, the maximum log file size is 1048576 bytes (1 MB).