Purpose
The STATUS DBS command reports the status of the Teradata Database.
Syntax
{ STATUS | ST } DBS
Usage Notes
The STATUS DBS command returns a status report for the Database Status Table only. The Database Status Table includes a status row for each vproc that is defined on the system. 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 vproc status row.
Column | Description |
---|---|
Vproc Number | Uniquely identifies the vproc across the entire system. |
Rel. Vproc# | Represents the number of the vproc number relative to the Node upon which the vproc resides. |
Node ID | 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. |
Can Move | This indicates whether the vproc can be migrated to another node in its defined clique if its primary node fails. |
Crash Count | Represents the number of times the vproc has crashed. |
Vproc State | Represents the current PDE system state of a vproc. |
Config Status | Displays the Teradata Database Logical Configuration Map Status of a vproc. |
Config Type | Represents the Teradata Database Logical Configuration Map Type of a vproc. |
Cluster/Host No. | Displays the Cluster Number if the Config Type is AMP or displays the Host No. if the Config Type is PE. Cluster is the cluster number for the AMP as defined during a system configuration or reconfiguration. The valid range of cluster numbers is 0 to 8099. Host No. is 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. |
RcvJrnl/Host Type |
|
TVS Vproc | For AMP vprocs, displays the associated TVS vproc. |
Example: Displaying the status of Teradata Database
Enter a command, HELP or QUIT: status dbs SYSTEM NAME: teradata-1 DBS LOGICAL CONFIGURATION ------------------------- Rcv Jrnl/ Vproc Rel. Node Can Crash Vproc Config Config Cluster/ Host TVS Number Vproc# ID Move Count State Status Type Host No. Type Vproc ------ ------ ------ ----- ----- ------- -------- ------ -------- ----- ----- 0* 1 1-01 Yes 0 ONLINE Online AMP 0 On 10238 1 2 1-01 Yes 0 ONLINE Online AMP 0 On 10237 8192 4 1-01 No 0 ONLINE N/A GTW 1 COP N/A 10237 5 1-01 Yes 0 ONLINE N/A TVS 0 N/A N/A 10238 6 1-01 Yes 0 ONLINE N/A TVS 0 N/A N/A 16383 3 1-01 Yes 0 ONLINE Online PE 1 COP N/A -------------------------------------------------------------------------------- * DBS Control AMP DBS State: Logons are enabled - The system is quiescent DBS RestartKind: COLD