Advanced SQL Engine | Vproc Manager (vprocmanager) | Teradata Vantage - Vproc Manager (vprocmanager) - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢
The utility described is not available for as-a-service customers.

The Vproc Manager utility, vprocmanager, allows you to manage the virtual processors (vprocs) in an Advanced SQL Engine 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 Advanced SQL Engine, managing the basic functions of the system.

Advanced SQL Engine 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 Vantage.
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 Vantage 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.