15.00 - SHOW CLUSTER - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

SHOW CLUSTER

Purpose  

The SHOW CLUSTER command displays all AMPs in a specified cluster for a current or new configuration map.

Syntax  

 

Syntax element …

Specifies …

CN = nnnn

the cluster number for which the appropriate AMPs are to be displayed.

The cluster number ranges from 0 to 8099.

FROM

that you will choose the type of configuration map to be displayed.

CURRENT

the configuration map that the Teradata Database is using currently. This is the default.

If you do not specify a map type, the current cluster configuration map is displayed.

NEW

the proposed configuration map.

Usage Notes  

The SHOW CLUSTER command displays the cluster configuration map.

Example  

To display the current configuration map for cluster three and its associated AMPs, type:

show cluster cn = 3

An example output generated by the SHOW CLUSTER command is shown below.

OK, AMPs of cluster 3 are listed.
Vproc   Status   Cluster     Vproc   Status   Cluster
______  _______  ________    ______  _______  _________
  3     Online      3         7      Online      3
 11     Online      3        15      Online      3