STATUS DBS ORDERBY NODEID
Purpose
The STATUS DBS Orderby Nodeid command reports the status of Online and NotOnline Teradata Database vprocs ordered by node id.
Syntax
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
Enter a command, HELP or QUIT:
status dbs orderby nodeid
SYSTEM NAME: nirvana 07/12/21 15:29:09
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.