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 available on all database nodes. For more information, see ConfD.

Connect to COS

Connect to EXAClusterOS (COS) using c4 connect -t <DEPLOYMENT>[.<NODE>]/cos. For example:

c4 connect -t 1/cos

In most cases it does not matter on which node you access ConfD. If you do not specify a node, c4 will connect to the first active node in the deployment. The command prompt in COS indicates which node you are connected to:

[root@n11 ~]#

For more information about how to use c4 connect, see How to use c4.

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 The database owner as an integer tuple (user id, group id) or list (user name, user group name).



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 st_volume_create 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 returns 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. To check the actual size of the archive volume after creation to see if it is acceptable, use the ConfD job st_volume_info. 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 st_volume_add_label vname: LocalArchiveVolume1 label: useinitopt
confd_client st_volume_add_label 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'