Purpose
The STATUS DBS Orderby CN command reports the status of Online and NotOnline Teradata Database AMP vprocs ordered by cluster number.
Syntax
{ STATUS | ST } DBS [ ORDERBY CN ]
Usage Notes
The STATUS DBS Orderby CN command returns the Online and NotOnline Teradata Database AMP vprocs ordered by the cluster 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. |
| CN No. | Displays the cluster number for the AMP as defined during a system configuration or reconfiguration. The valid range of cluster numbers is 0 to 8099. |
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. |
| Cluster Number | Displays the cluster number for the AMP as defined during a system configuration or reconfiguration. The valid range of cluster numbers is 0 to 8099. |
Example: Displaying a cluster-ordered list of AMP status
Enter a command, HELP or QUIT: status dbs orderby cn SYSTEM NAME: ippd DBS LOGICAL CONFIGURATION ------------------------- ONLINE AMP Vprocs ordered by Cluster No. - Vproc-Ids Crash CN Vproc-Ids Crash CN Range Cnt NO Range Cnt NO -------------------------- --- ---- -------------------------- --- ---- 0*-1 0 0 2-3 0 1 4-5 0 2 6-7 0 3 ------------------------------------------------------------------------------- * DBS Control AMP DBS State: Logons are enabled - Users are logged on DBS RestartKind: COLD