Purpose
The STATUS command reports the status of the database, PDE, and contiguous maps configuration.
Syntax
{ STATUS | ST }
Usage Notes
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 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. The count increments with every attempted system restart. When the system restart succeeds, Crash Count is reset to 0 for all vprocs. |
| Vproc State | Represents the current PDE system state of the vproc. |
| Config Status | Displays the Teradata Database Logical Configuration Map Status of the vproc. |
| Config Type | Represents the Teradata Database Logical Configuration Map Type of a vproc. |
| Global Map 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. |
The map status table identifies the clustering used for the AMP vprocs with respect to the maps that determine how data is distributed among the AMPs. In the example output below, AMPs 0 and 2 constitute cluster 0 in all maps that include those AMPs. AMPs 1 and 3 constitute cluster 1.
The PDE Status Table includes a status row for each node that is defined on the system. The columns of the node status row are shown in the following table.
| Column | Description |
|---|---|
| Node ID | The Node ID as defined using the Parallel Upgrade Tool (PUT). For more information, see the Parallel Upgrade Tool (PUT) Reference. The Node ID is formatted as CCC-MM, where CCC denotes the cabinet number and MM denotes the module number. |
| Node State | The current state of the node, which is either ONLINE, DOWN, or STANDBY. |
| Clique Number | The clique number for the node as defined using the Parallel Upgrade Tool (PUT). For more information, see the Parallel Upgrade Tool (PUT) Reference. |
| CPUs | The number of CPUs on the node. |
| Memory (MB) | The total memory size in megabytes for the node (rounded up to the nearest integer). |
| CHANs | The number of channels attached to the node. |
| LANs | The number of LANs attached to the node. |
| AMPs | The number of AMPs running on the node. |
| Node Name | The network name for the node. |
When applicable, a footnote will follow the PDE Status Table, indicating which node is defined as a Non-TPA Node (for STANDBY node).
Example: Displaying the database, map, and PDE status
Enter a command, HELP or QUIT:
status
SYSTEM NAME: teradata-1
DBS LOGICAL CONFIGURATION
-------------------------
Global Rcv
Map 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 28671
1 2 1-01 Yes 0 ONLINE Online AMP 1 On 28671
2 3 1-01 Yes 0 ONLINE Online AMP 0 On 28670
3 4 1-01 Yes 0 ONLINE Online AMP 1 On 28670
26623 8 1-01 No 0 ONLINE N/A RSG 0 N/A N/A
22528 7 1-01 No 0 ONLINE N/A GTW 1 COP N/A
28670 9 1-01 Yes 0 ONLINE N/A TVS 0 N/A N/A
28671 10 1-01 Yes 0 ONLINE N/A TVS 0 N/A N/A
30718 5 1-01 Yes 0 ONLINE Online PE 1 COP N/A
30719 6 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
MAP CONFIGURATION
-----------------
Slot 0: TD_GlobalMap
MAP State: Online
Slot 1: TD_DataDictionaryMap
MAP State: Online
Slot 2: TD_Map1
MAP State: Online
Slot 0 Slot 1 Slot 2
AMP Cluster Cluster Cluster
Number No No No
------ ------- ------- -------
0 0 0 0
1 1 1 1
2 0 0 0
3 1 1 1
------------------------------------------------------------------------------
PDE PHYSICAL CONFIGURATION
--------------------------
Node Node Clique Memory
ID State Number CPUs (MB) CHANs LANs AMPs Node Name
------- ------- ------ ---- ------ ----- ---- ---- ---------------------------
1-01 ONLINE 0 1 7740 0 1 4 localhost
------------------------------------------------------------------------------
PDE State: RUN/STARTED