config shard

Displays properties of a specified shard.

Syntax

config shard -shard shard_name
            [-support]
            [-verbose]

Options

Table 2-30 GDSCTL config shard Options

Option	Description
-shard shard_name	Specify the name of the shard.
-support	GDSCTL output displays additional support information.
-verbose	Enable verbose mode

Examples

GDSCTL> config shard 

Name   Shard Group Status State    Region Availability 
----   ----------- ------ -----    ------ ------------ 
den17b dbs1        Ok     Deployed east   ONLINE
den17c dbs2        Ok     Deployed east   READ ONLY 

The State column in the results can have the following values:

• Created: Indicates that add shard or create shard was run, but deploy has not yet been run for that shard.

• Replicated: Indicates that deploy was run and the Data Guard broker configuration was created. No other metadata (chunks, for example) are on the shard and the shard has not yet registered with the shard director

• Sharded: Indicates that the database has successfully registered with the shard director. Creates chunk metadata for new shards, but does not start any automatic rebalancing. To manually get from Replicated to Sharded and beyond, run GDSCTL sync -database <shard_name>.  This is what is happening internally in this step.

• Deployed: Indicates that all DDL catchup is completed and the shard is ready for operations. At this point, any scheduled chunk moves are begun in the background. A shard can be Deployed without having been rebalanced because rebalancing is a background operation.