Manage Vproc Status | Teradata Vantage - About Managing Vproc Status and Initializing AMP Disks with Vproc Manager - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
upb1600054424724.ditamap
dita:ditavalPath
upb1600054424724.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantage™

The Vproc Manager utility allows you to:

  • View or change vproc states
  • Initialize and boot a specific vproc
  • Initialize the storage associated with a specific vproc
  • Force a manual SQL Engine restart

You can start Vproc Manager from the DBW Supervisor window (start vprocmanager) or from the Linux command line (vprocmanager). Valid commands are STATUS, INITVDISK, RESTART, BOOT, SET, HELP, and QUIT.

Vproc Manager Command Description
STATUS Provides STATUS information about vprocs.
INITVDISK <vproc ID> Initializes the DBS File System on a vdisk. It applies only to vprocs with a status of NEWPROC or FATAL AMP. Valid vproc IDs are decimals ranging from 0 to 16383. Hex numbers can be used with a trailing “x.”
RESTART [TPA] [NODUMP | DUMP = {YES, NO}][<RestartKind] [<comment>] Forces different types of DBS restarts:
  • NODUMP (the default) indicates no system dump.
  • DUMP = YES indicates a system dump.
  • DUMP = NO is equivalent to NODUMP.
  • ValidRestartKind is either COLD or COLDWAIT.
  • Comment specifies the reason for the restart.
BOOT <vproc ID> Reinitialize the AMP disk before an all-table rebuild and starts the DBS partitions on the specified AMP. It applies only to vprocs with a VprocState of FATAL and a ConfigStatus of Down.
SET Sets the state of a vproc to either ONLINE, OFFLINE, or FATAL.