15.00 - Chapter 33 Vproc Manager (vprocmanager) - 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

The Vproc Manager utility, vprocmanager, allows you to manage the virtual processors (vprocs) in a Teradata Database system. Vprocs are a set of software processes that run under Teradata Parallel Database Extensions (PDE) within the multitasking environment of the operating system. Vprocs are the heart of Teradata Database, managing the basic functions of the system.

Teradata Database systems can include the following vproc types.

 

Vproc Type

Description

AMP

Access module processors perform database functions, such as executing database queries. Each AMP owns a portion of the overall database storage.

GTW

Gateway vprocs provide a socket interface to Teradata Database.

Node

The node vproc handles PDE and operating system functions not directly related to AMP and PE work. Node vprocs cannot be externally manipulated, and do not appear in the output of the Vproc Manager utility.

PE

Parsing engines perform session control, query parsing, security validation, query optimization, and query dispatch.

RSG

Relay Services Gateway provides a socket interface for relaying dictionary changes to the Teradata Meta Data Services utility.

TVS

Manages Teradata Database storage. AMPs acquire their portions of database storage through the TVS vproc.

Vproc Manager allows you to perform the following:

  • Obtain the status of some or all of the vprocs
  • Change vproc states
  • Initialize and boot one or more specified AMP vprocs
  • Initialize the storage associated with one or more specified AMP vprocs
  • Force a database restart
  • Vproc Manager can be used with the Table Rebuild utility to initialize and boot a specific AMP vproc in order to rebuild the portion of all tables associated with the vproc.

    Scenarios Runs From

  • Database Window or comparable interface to the Teradata Database console subsystem, such as cnsterm
  • Linux command line
  • Teradata Viewpoint Remote Console portlet
  • For general information on starting the utilities from different interfaces, see Appendix B: “Starting the Utilities” For information on Viewpoint, see Teradata Viewpoint User Guide.