16.10 - STATUS NOTONLINE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

The STATUS NOTONLINE command reports the status row for vprocs and nodes that are not fully online.

Syntax



Usage Notes

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

Host No. is the host number that was assigned to the PE using the Configuration Utility. 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 using the Configuration Utility and is one of the following:
    • IBM
    • COP
    • ATT3B
    • BULLHN
    • OS1100
TVS Vproc For AMP vprocs, displays the associated TVS vproc.

Example: Displaying a list of vprocs and nodes that are not online

Enter a command, HELP, or QUIT:
status notonline

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
------ ------ ------  ----- ----- ------- -------- ------ -------- ----- -----
    5     6     2-14  Yes     0   OFFLINE Online    AMP       2    On    10237
--------------------------------------------------------------------------------