STATUS DBS ORDERBY HN - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

The STATUS DBS ORDERBY HN command reports the status of Online and NotOnline Vantage PE vprocs, optionally ordered by host number.

Syntax

{ STATUS | ST } DBS [ ORDERBY HN ]

Usage Notes

The STATUS DBS ORDERBY HN command is used to return the Online and NotOnline Vantage PE vprocs ordered by the host status tables only.

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.
Can Move Indicates whether the PE vproc can be migrated to another node in its defined clique if its primary node fails.
Host Number Displays the host number that was assigned to the PE during a system configuration or reconfiguration. The valid range of host numbers is 1 to 1023.
Host Type Displays the host type for the PE as defined during a system configuration or reconfiguration, and is one of the following: IBM, COP, ATT3B, BULLHN, or OS1100.
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.
Can Move Indicates whether the PE vproc can be migrated to another node in its defined clique if its primary node fails.
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.
Host Number Displays the host number that was assigned to the PE during a system configuration or reconfiguration. The valid range of host numbers is 1 to 1023.
Host Type Displays the host type for the PE as defined during a system configuration or reconfiguration and is one of the following: IBM, COP, ATT3B, BULLHN, or OS1100.

Example:Displaying a host-ordered list of PE status

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

SYSTEM NAME: nirvana    
    
                            DBS LOGICAL CONFIGURATION
                            --------------------------
ONLINE PE vprocs ordered by Host No. - -
Vproc-Ids            Crash               Host        Host
Range                Count   Moveable    Number      Type
-------------------  ------  --------    ------      -----
16368-16382            0       Yes           52       COP
16345-16351            0       No           282       IBM
16353, 16357, 16359,   0       No           286       IBM
.
.
.
16362, 16366
-------------------------------------------------------------------------------
NOTONLINE PE vprocs ordered by Host No. - -
Vproc-Ids           Crash                Vproc    Config      Host       Host
Range               Count     Can Move   State    Status      Number     Type
----------------    ------    ---------  ------   -------     --------   ------
16383                 0         Yes      NONODE    Down           52      COP
16344                 0         No       NONODE    Down          282      IBM
16355, 16367          0         No       NONODE    Down          286      IBM
16352, 16364          0         No       NONODE    Down          289      IBM
-------------------------------------------------------------------------------
DBS State: Logons are enabled - Users are logged on
DBS RestartKind: COLD