15.00 - SHOW VPROC - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

SHOW VPROC

Purpose  

The SHOW VPROC command displays the attributes of a specified AMP or PE vproc in a current or new configuration.

Syntax  

 

Syntax element …

Specifies …

mmmm

the vproc number of an AMP or PE.

Note: The AMP vproc number ranges from 0 to 16199, and the PE vproc number ranges from 15360 to 16383.

FROM

that you will choose the type of configuration map to be displayed.

CURRENT

the configuration map that the Teradata Database is using currently. This is the default.

The default map type is CURRENT.

If you do not specify a map type, the current configuration map is displayed.

NEW

the proposed configuration map.

Usage Notes  

The following table lists what the SHOW VPROC command displays.

 

Type of vproc

Information displayed

PE

  • Vproc number
  • Status
  • Host number with which the PE is associated
  • AMP

  • Vproc number
  • Status
  • Cluster number
  • Example  

    To display the attributes of PE vproc 16380 for the current configuration map, type:

    show vproc 16380

    An example output generated by the SHOW VPROC command is shown below:

    Vproc    Status    HostNo
    -----    ------    ----------
    16380    Online    821

    Example  

    To display the attributes of AMP vproc six for the current configuration map, type:

    show vproc 6

    An example output generated by the SHOW VPROC command is shown below:

    Vproc    Status    Cluster
    -----    ------    -------
      6      Online      2