15.00 - STATUS vproclist - 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 vproclist

Purpose  

The STATUS vproclist command reports the vproc status table row for the specified vproc or vprocs and allow a maximum of 30720 or 16384 vprocs, depending on the system, to be specified. This command does not display a vproc status row for undefined vprocs.

Syntax  

 

Syntax element …

Description

vproclist

A list of one or more vproc identifiers. For examples, see “Definitions of Terms Used in Vproc Manager” on page 944.

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 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.

Movable

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 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 or displays the Host Type if the Config Type is PE.

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.

Note: 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).

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, or OS1100.

TVS Vproc

For AMP vprocs, displays the associated TVS vproc.

Example  

Enter a command, HELP or QUIT:
status 1, 2, 8192 to 16383


SYSTEM NAME: teradata-1                                         07/12/21 15:55:47

                          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

Example  

The following is an example status display for undefined vprocs.

Enter a command, HELP, or QUIT:
 
status 100 to 300
 
SYSTEM NAME: teradata-1                                95/11/29 11:12:16                                
 
STATUS command ignored: None of the specified Vprocs are defined.