Application Configuration

Once you have installed Datavault Builder, you can influence the applications behavior by settings defined in the configuration table dvb_config.config on your database.

Available Parameters

Some samples of what you can configure:

  • environment appearance: coloring of the navigation bar of Datavault Builder to distinguish multiple environments

  • degree of parallel load executors

  • user inactivity timeout

  • server name

  • default staging loading batch size

  • bulk copy usage on installs targeting ms sql

  • index storage location for supported databases

Please refer to the parameters available in the configuration table dvb_config.config for details and comments about the parameters.

Parameter Configuration

These parameters can be provided via:

  • In-Database Configuration (changing value directly within table dvb_config.config),

  • Core Environment-Variables (if provided, will override value in dvb_config.config during startup of core).

Advanced Parameters

Following can be added additionally to existing parameters in dvb_config.config:

config_key

Sample config_value

Purpose

Possible Values

Since DVB Version
persistence_runtime_logs_delay_in_seconds
 
2

Time to wait until a runtime log batch (datavault._dvb_runtime_load_data & staging._dvb_runtime_table_status) is written down to the client db.

Integers

7.1.1.0
persistence_logs_delay_in_seconds
 
10

Time to wait until a log batch (e.g. for load logs, dvbuilder_log) is written down to the client db.

Integers

7.1.1.0

Hint

Additional information about configuration for loading parallelization can be found in the knowledge base: Performance Configuration

When changing a value directly in the table dvb_config.config, the changes will take effect within 1 minute. If you would like them to be applied immediately, you can execute the following statement in Datavault Builder > Operations > Command Line:

SELECT dvb_core.f_refresh_config();