STORAGEGROUPS System Table Description

Description

A pseudo Table generated to show all storage groups serviced by this database.

Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.

Fields

Field Type Description

Field	Type	Description
ID	bigint	The ID of the storage group. Note, storage group `ALL` is always 1.
NAME	string	The name of the storage group. This is the name assigned to the storage group by the `nuocmd add storage-group` command.
STATUS	string	This describes the availability of the storage group. A storage group is listed as `Unavailable` if there are no SMs available to service this particular storage group. `Available` – storage group is on-line. `Unavailable` – no running Storage Managers service this storage group. `Stranded` – there may still be stranded transactions in the leader archive for this storage group. Until all of these are resolved, the state of all past transactions is uncertain.
NUMLEADERCANDIDATES	bigint	The number of live archive nodes that are leader candidates for this storage group. See `SYSTEM.NODESTORAGEGROUPS.LEADERCANDIDATE` to determine which archive nodes are defined as leader candidates for the storage group.

bigint

The ID of the storage group. Note, storage group ALL is always 1.

NAME

string

The name of the storage group. This is the name assigned to the storage group by the nuocmd add storage-group command.

STATUS

string

This describes the availability of the storage group. A storage group is listed as Unavailable if there are no SMs available to service this particular storage group.

Available – storage group is on-line.

Unavailable – no running Storage Managers service this storage group.

Stranded – there may still be stranded transactions in the leader archive for this storage group. Until all of these are resolved, the state of all past transactions is uncertain.

NUMLEADERCANDIDATES

bigint

The number of live archive nodes that are leader candidates for this storage group. See SYSTEM.NODESTORAGEGROUPS.LEADERCANDIDATE to determine which archive nodes are defined as leader candidates for the storage group.

Indexes

None