16.10 - SHOW VPROC - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Purpose

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

Syntax



mmmm
the vproc number of an AMP or PE.
FROM or F
Use this to specify the map that contains the information you want to list:
  • CURRENT or C is the current configuration map. This is the default if you do not specify FROM or F.
  • NEW or N is the new configuration map, which will be in effect only after you run the Reconfiguration utility.
  • mapname or mapnumber identifies a contiguous map.

Examples: Displaying attributes of specified vprocs

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


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