16.10 - SHOW CLUSTER - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Purpose

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

Syntax



CN = nnnn
the cluster number for which the appropriate AMPs are to be displayed.
The cluster number ranges from 0 to 8099.
FROM or F
Use this to specify the map that contains the information you want to list:
  • CURRENT or C is the current configuration map. This is the default if you do not specify FROM or F.
  • NEW or N is the new configuration map, which will be in effect only after you run the Reconfiguration utility.
  • mapname or mapnumber identifies a contiguous map.

Example: To display all AMPs in a specified cluster

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