Purpose
The STATUS DBS ORDERBY HN command reports the status of Online and NotOnline Teradata Database PE vprocs 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 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. |
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. |
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. |
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 Database 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