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

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
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 Analytics 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 Analytics Database, managing the basic functions of the system.

Analytics Database systems can include the following vproc types.

Vproc Type Description
AMP Access module processor. Performs database functions such as executing database queries. Each AMP owns a portion of database storage.
GTW Gateway vproc. Provides socket interface to Vantage.
Node Handles PDE and operating system functions not directly related to AMP and PE work. Cannot be externally manipulated. Does not appear in Vproc Manager utility output.
PE Parsing engine. Does session control, query parsing, security validation, query optimization, and query dispatch.
RSG Relay Services Gateway. Provides socket interface for communication with Teradata Data Stream Architecture (DSA).
TVS Teradata Virtual Storage. 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.