STATUS ONLINE - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

The STATUS ONLINE command reports whether all AMPs are online. If any AMP is not online, STATUS ONLINE shows a more detailed list of status for online vprocs.

Syntax

{ STATUS | ST } { ONLINE | ON }

Usage Notes

If all vprocs are online, the STATUS ONLINE command simply reports that.

If one or more vprocs are offline, the STATUS ONLINE command displays a STATUS row for each of the vprocs that is online. 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
  • Displays the RcvJrnl (that is, Recovery Journaling) flag if the Config Type is AMP. The RcvJrnl flag is Off if an AMP is down and the other AMPs in its cluster are not to create a recovery journal for the down AMP.
    If you anticipate that an AMP will be down for a long period of time, then Teradata recommends an offline rebuild of all tables on the AMP (after the RcvJrnl flag has been set to Off).
  • Displays the Host Type if the Config Type is PE. The Host Type is the host type for the PE as defined during a system configuration or reconfiguration, and is one of the following:
    • IBM
    • COP
    • ATT3B
    • BULLHN
    • OS1100
TVS Vproc For AMP vprocs, displays the associated TVS vproc.

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 status of online vprocs

If all vprocs are online, the STATUS ONLINE command simply reports that.

Enter a command, HELP or QUIT:
status online

SYSTEM NAME: ztest  

All DBS vprocs are fully online.

All PDE nodes are fully online.
 

If any vproc is not online, the STATUS ONLINE command displays a more detailed status screen for all vprocs and nodes that are ONLINE. In the following example, vproc number 2 has been disabled and is offline, so it is not shown in the list of online vprocs.

Enter a command, HELP or QUIT:
status online
 
SYSTEM NAME: localhost   
 
                          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
    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
 
All PDE nodes are fully online.