STORAGEGROUPS System Table Description


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

Caution: 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.


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 NuoDB Manager add storageGroup command.
STATUS string This tells whether the storage group is available or unavailable. A storage group is listed as Unavailable if there are no SMs available to service this particular storage group.
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.