17.10 - STATUS DBS ORDERBY NODEID - 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 NODEID command reports the status of Online and NotOnline Vantage vprocs, optionally ordered by node id.

Syntax

{ STATUS | ST } DBS [ ORDERBY NODEID ]

Usage Notes

The STATUS DBS Orderby Nodeid command is used to return the Online and NotOnline Vantage vprocs ordered by the node id 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 crashed.
Node Ids Identifies the Node upon which the vproc resides. The Node ID is formatted as CCC-MM, where CCC denotes the cabinet number and MM denotes the module number.
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 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.
Node Ids Identifies the Node upon which the vproc resides. The Node ID is formatted as CCC-MM, where CCC denotes the cabinet number and MM denotes the module number.

Example: Displaying a node-ID-ordered list of vproc status

Enter a command, HELP or QUIT:

status dbs orderby nodeid

SYSTEM NAME: nirvana  

                          DBS LOGICAL CONFIGURATION     
 
ONLINE AMP and PE vprocs ordered by Node ID - -
Vproc-Ids           Crash     Node    Vproc-Ids           Crash     Node
Range               Count     Ids     Range               Count     Ids
----------------    ------    -----   ----------------    ------    -----
3, 7, 11, 15           0       9-00   16366                 0         9-00
2, 6, 10, 14           0       9-02   1, 5, 9, 13           0        10-00
16362-16363, 16381     0      10-00   0*, 4, 8, 12          0        10-02
.
.
.
16369                  0      17-00   16368                 0        17-02
---------------------------------------------------------------------------

NOTONLINE AMP and PE vprocs orderby Node ID - -
Vproc-Ids           Crash     Vproc    Config       Node
Range               Count     State    Status       IDs
----------------    -------   ------   -----------  -------
16367, 16383           0      NONODE   Down           9-00
16364                  0      NONODE   Down           9-02
16355                  0      NONODE   Down          11-02
17                     0      UTILITY  CATCHUP       11-02
21                     0      NEWPROC  NewReady      11-02
.
.
.
.
63                     0      FATAL**   Down              15
--------------------------------------------------------------------------
*   DBS Control AMP
**  The storage associated with the AMP has an I/O error or can't be opened.
    Vproc can be brought online after fixing the I/O error and restarting
    the database.