The following example of configuration settings enable the query statistics log and sets a maximum log file size of 10485760 bytes (10 MB).

When query statistics logging is enabled, the statistics for each query are written to a CSV log file in the LOGDIR directory, whether or not the query completes successfully. The log file name has the following format:

where

yyyy-mm-dd-HH-MM-SS

is the timestamp from when the CSV file was created.

The initial timestamp used for the log file name will remain the same for the duration of the Data Vault Service session, even if query statistics logging is disabled and then re-enabled. The timestamp will only change if Data Vault Service is restarted.

The initial timestamp used for the log file name will remain the same for the duration of the Data Vault Service session, even if query statistics logging is disabled and then re-enabled. The timestamp will only change if the Data Vault Service is restarted.

When the maximum file size (set by the STATLOGLIMIT_FILESIZE parameter) is reached, the current log file is renamed and a new log file is created for the latest query statistics. The older log file has a three-digit extension appended to its name, to distinguish it from the currently active log file. The numeric extension starts at ".001" and increments by one for each subsequent log file that reaches its maximum size, up to ".999".

For example:

The LOGDIR location can therefore contain at most

1000

query statistics log files (999 previous log files, plus one currently active CSV file) for the same session.