Create Local Archive Volume

This section explains how to create a local archive volume.

This procedure is carried out using ConfD.


The following examples use ConfD through the command-line tool confd_client, which is accessible on all database nodes. You can also access ConfD through XML-RPC in your own Python programs. For more information, see ConfD.

Create a local archive volume

To create a local archive volume, use the ConfD job st_volume_create and set the parameters described in the following table.

Some parameters values for the new archive volume must match the corresponding values for the data volume. To find out the values used by the data volume, use the ConfD jobs db_info and st_node_list.

Required parameters

Parameter Name

Data type




The disk name in Exasol for the storage disk where the data volume resides.


tuple, list

Owner tuple (or list of tuples) for the data volume.



List of node IDs in the data volume.

num_master_nodes integer

The number of master nodes (active nodes) in the data volume.




A name for the new archive volume.



The redundancy level of the archive volume.



Volume size for the archive volume as a string, with unit (MiB, GiB, or TiB).

The size value depends on the database size and the backup schedule.


string, integer

4294967296 for volumes <250 GiB

34359738368 for volumes ≥ 250 GiB and <1TiB

274877906944 for volumes ≥ 1 TiB







block_size string 512 KiB
stripe_size string 512 KiB

Master Nodes

The parameter num_master_nodes defines the number of master nodes that the volume will use. The number of master nodes must match the number of active nodes in the cluster. For example: in a cluster that will have 4 active nodes and 1 reserve node (4+1), the number of master nodes is 4.

In the following example, we create a 1 TiB data volume with the name LocalArchiveVolume1 on the storage disk disk1 with 4 master nodes and redundancy 2. The command returns the volume ID for the new volume (vid: 3).

confd_client -c st_volume_create -a '{"name": "LocalArchiveVolume1", "disk": "disk1", "type": "archive", "size": "1 TiB", "num_master_nodes": 4, "nodes": [11, 12, 13, 14], "redundancy": 2, "partition_size": 274877906944, "shared": true, "owner": [500,500]}'
# ConfD will return the volume ID of the new archive volume:
vid: 3

The ConfD job st_volume_create does not necessarily use the specified size, but does internal rounding. Use the ConfD job st_volume_info to check the actual size of the archive volume after creation to see if it is acceptable. If the rounding takes up too much space, contact Support.

Enable optimizations

To enable optimizations for the local archive volume, use the ConfD job st_volume_add_label

confd_client -c st_volume_add_label -a '{"vname": "LocalArchiveVolume1", "label": "useinitopt"}'
confd_client -c st_volume_add_label -a '{"vname": "LocalArchiveVolume1", "label": "usesearchopt"}'


To verify the properties of the new local archive volume, use the ConfD job st_volume_info with the volume ID:

confd_client st_volume_info vid: 3
_sec_name: 'EXAVolume : LocalArchiveVolume1'