15.00 - STATUS DBS ORDERBY CN - 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 CN

Purpose  

The STATUS DBS Orderby CN command reports the status of Online and NotOnline Teradata Database AMP vprocs ordered by cluster number.

Syntax  

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 using the Configuration Utility. 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 using the Configuration Utility. The valid range of cluster numbers is 0 to 8099.

Example