17.10 - STATUS DBS ORDERBY CN - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The STATUS DBS ORDERBY CN command reports the status of Online and NotOnline Vantage AMP vprocs, optionally ordered by cluster number.

Syntax

{ STATUS | ST } DBS [ ORDERBY CN ]

Usage Notes

The STATUS DBS Orderby CN command returns the Online and NotOnline Vantage AMP vprocs ordered by the cluster status tables only. When applicable, a footnote will follow the Database Status Table, indicating which AMP vproc has been selected as the Control AMP.

ONLINE vproc Columns
Column Description
Vproc-Ids Range Uniquely identifies the Vproc-id or Vproc-ids individually or in a range across the entire system. Vproc numbers in the range of 0 through 30719 are used exclusively by the Vantage configuration. Vproc numbers greater than 30719 are used exclusively by PDE and are not included in the Teradata logical configuration.
Crash Count Represents the number of times the vproc has crashed.
CN No. Displays the cluster number for the AMP as defined during a system configuration or reconfiguration. The valid range of cluster numbers is 0 to 8099.
NOTONLINE vproc Columns
Column Description
Vproc-Ids Range Uniquely identifies the Vproc-id or Vproc-ids individually or in a range across the entire system. Vproc numbers in the range of 0 through 30719 are used exclusively by the Vantage configuration. Vproc numbers greater than 30719 are used exclusively by PDE and are not included in the Teradata logical configuration.
Crash Count Represents the number of times the vproc has crashed.
Vproc State Represents the current PDE system state of a vproc if the state is not online.
Config Status Displays the Teradata Logical Configuration Map Status of a vproc.
Cluster Number Displays the cluster number for the AMP as defined during a system configuration or reconfiguration. The valid range of cluster numbers is 0 to 8099.

Example: Displaying a cluster-ordered list of AMP status

Enter a command, HELP or QUIT:
status dbs orderby cn

SYSTEM NAME: ippd        
                          DBS LOGICAL CONFIGURATION
                          -------------------------

ONLINE AMP Vprocs ordered by Cluster No. -
Vproc-Ids                  Crash  CN     Vproc-Ids                  Crash  CN
Range                       Cnt   NO     Range                       Cnt   NO
--------------------------  ---  ----    --------------------------  ---  ----
0*-1                         0      0    2-3                          0      1
4-5                          0      2    6-7                          0      3
-------------------------------------------------------------------------------
*   DBS Control AMP

  DBS State: Logons are enabled - Users are logged on

  DBS RestartKind: COLD