The connection name that was used to start the Data Vault repository database. There must be a corresponding [CONNECTION

connection-name

] section in the

nucleus.ini

file.

The name of the Data Vault repository database.

The user name that will be used to connect to the Data Vault repository database. It must be a user with at least INSERT, UPDATE, and DELETE privileges on the tables in the SDS_REPOSITORY schema.

The password for the user specified by UID. If the user does not have a password, leave this parameter empty.

This parameter is used to enable the automatic startup of a Data Vault repository database when the load balancer is started. The same Data Vault repository database shuts down when the load balancer is shut down.

Possible AUTOSTARTUP values:

1

enables autostartup

0

disables autostartup

When AUTOSTARTUP=1, the STARTUPHOST and STARTUPCOMMAND parameters should be set as well.

Default is 0.

The name of the machine where the Data Vault repository database will be started when AUTOSTARTUP=1. If autostartup is turned on and this parameter is missing or empty, the local machine is assumed to be the Data Vault repository database host machine.

If a remote host is specified, a Data Vault Agent process with an AID set to

0

must be started on that machine in order for the autostartup option to work. This Agent will be dedicated to starting/stopping the Data Vault repository database, and will not be able to process client requests. Thus, there must be at least one other Data Vault Agent process running on the same machine, or elsewhere on the network, to handle queries.

Default is localhost.

The command line that will be used to start the Data Vault repository database, when AUTOSTARTUP=1. Use the following syntax:

For UNIX:

Sets the amount of time (in seconds) before a connection attempt to the Data Vault repository database is cancelled.

Specifying

0

means the timeout period defined for the Nucleus ODBC Driver will be used (by default,

120

seconds).

Note that a negative value is not permitted for this parameter.

Default is 0.

Enables (1) or disables (0) data type conversion.

When data type conversion is enabled, certain data types can differ between columns in a registered compressed data file and ones in the archived table to which it belongs. The server will attempt to convert the compressed data file column to make it compatible with the table column.

When data type conversion is disabled, the data type of a column in a compressed data file must be exactly the same as that of the corresponding column in the table, although length, precision and/or scale may differ in some cases.

Default is 0

Enables (

1

) or disables (

0

) data truncation. (This setting only works when data type conversion is turned on: CASTING=1.)

When data truncation is enabled, more data types can be converted between a compressed data file and an archived table, but the trade-off is that some Data Vault data might be truncated by the conversion. (Note that the "truncation" here is only virtual; the data in compressed data files is read-only and cannot be changed.)

When data truncation is disabled, the types of conversions that can result in truncated Data Vault data are disallowed.

Default is 0.