15.00 - STATUS DBS ORDERBY HN - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

STATUS DBS ORDERBY HN

Purpose  

The STATUS DBS Orderby HN command reports the status of Online and NotOnline Teradata Database PE vprocs ordered by host number.

Syntax  

Usage Notes  

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

The following table shows the columns of the ONLINE vproc status row.

 

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 Teradata Database configuration. Vproc numbers greater than 30719 are used exclusively by PDE and are not included in the Teradata Database logical configuration.

Crash Count

Represents the number of times the vproc has crashed.

Moveable

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 using the Configuration Utility. The valid range of host numbers is 1 to 1023.

Host Type

Displays the host type for the PE as defined using the Configuration Utility and is one of the following: IBM, COP, ATT3B, BULLHN, or OS1100.

The following table shows the columns of the NOTONLINE vproc status row.

 

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 Teradata Database configuration. Vproc numbers greater than 30719 are used exclusively by PDE and are not included in the Teradata Database logical configuration.

Crash Count

Represents the number of times the vproc has crashed.

Moveable

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 Database Logical Configuration Map Status of a vproc.

Host Number

Displays the host number that was assigned to the PE using the Configuration Utility. The valid range of host numbers is 1 to 1023.

Host Type

Displays the host type for the PE as defined using the Configuration Utility and is one of the following: IBM, COP, ATT3B, BULLHN, or OS1100.

Example  

Enter a command, HELP or QUIT:
status dbs orderby hn
 
SYSTEM NAME: nirvana                                             08/12/21 15:29:09
                            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     Moveable   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