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 test database and then the storage groups serviced by this database:

nuodb [domain] > show storageGroups
Database: test
	[id=1] ALL Available
		No Leader Candidates.

	[id=2] UNPARTITIONED Available
		Leader Candidates:
		[SM] nuotest01/nuotest01:48005 (US_EAST) [ pid = 2204 ] [ nodeId = 1 ] RUNNING
		[SM] nuotest01/nuotest01:48008 (US_EAST) [ pid = 16990 ] [ nodeId = 7 ] RUNNING

	[id=10] SG1 Available
		Leader Candidates:
		[SM] nuotest01/nuotest01:48005 (US_EAST) [ pid = 2204 ] [ nodeId = 1 ] RUNNING
		[SM] nuotest01/nuotest01:48008 (US_EAST) [ pid = 16990 ] [ nodeId = 7 ] RUNNING
		

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"