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