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 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.