16.10 - Overview - 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

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 communication with Teradata Data Stream Architecture (DSA).
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.