You are here: Reference Information > Command Line Tools > NuoDB Manager > Show StorageGroups

Show StorageGroups

This is a NuoDB Manager command. See NuoDB Manager.

Description

Shows the storage groups serviced by each database in the domain.

Syntax

show storageGroups

Parameters

None.

Interactive Example

Show all storage groups serviced in the domain. Information is organized by database - first the storage groups serviced by the database test2 and then the storage groups serviced by the database test:

nuodb [domain] > show storageGroups
Database: test2
  [id=2] UNPARTITIONED Available
    Serviced by:
    [SM] ip-172-31-14-56/52.25.88.188:48008 (us-west-2) [ pid = 13405 ] [ nodeId = 3 ] RUNNING
    [SM] ip-172-31-14-171/52.24.143.83:48007 (us-west-2) [ pid = 7295 ] [ nodeId = 1 ] RUNNING
 
  [id=10] SG2 Available
    Serviced by:
    [SM] ip-172-31-14-56/52.25.88.188:48008 (us-west-2) [ pid = 13405 ] [ nodeId = 3 ] RUNNING
 
  [id=1] ALL Available
    Serviced by:
 
Database: test
  [id=2] UNPARTITIONED Available
    Serviced by:
    [SM] ip-172-31-14-56/52.25.88.188:48005 (us-west-2) [ pid = 13274 ] [ nodeId = 1 ] RUNNING
    [SM] ip-172-31-14-171/52.24.143.83:48006 (us-west-2) [ pid = 6535 ] [ nodeId = 3 ] RUNNING
 
  [id=10] SG1 Available
    Serviced by:
    [SM] ip-172-31-14-171/52.24.143.83:48006 (us-west-2) [ pid = 6535 ] [ nodeId = 3 ] RUNNING
 
  [id=1] ALL Available
    Serviced by:

A status of RUNNING indicates that the storage manager is doing useful work or available to do useful work. A status of WAITING indicates that the storage manager is waiting to synchronize with another storage manager and is not yet available for operations. The storage group will automatically transition from WAITING when your database has finished restarting.

Scripting Example

The same show storageGroups command can be executed with --command as follows:

nuodbmgr --broker host --password password --command "show storageGroups"