SET vproclist - 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 SET vproclist command sets the new state of a vproc or the new states for a list of vprocs.

Syntax

{ SET | S } [ /V ] vproclist_spec [[,]...]

Syntax Elements

vproclist_spec
vproclist [=] vprocstate
/V
Specifies the verbose mode of output, which includes more information.
vproclist
A list of one or more vproc identifier numbers. For examples, see Definitions of Terms Used in Vproc Manager.
vprocstate
Indicates the PDE system state of a vproc, such as ONLINE, OFFLINE, or FATAL.

Usage Notes

If the VprocState of an AMP or PE is changed from … After the next system restart, the VprocState/ConfigStatus is …
either OFFLINE or FATAL to ONLINE,

and its ConfigStatus is Down

ONLINE/Online. The AMP will be in UTILITY/Catchup state during recovery, immediately prior to ONLINE/Online.
either OFFLINE or FATAL to NEWPROC,

and its ConfigStatus is NewDown

NEWPROC/NewReady.
ONLINE to either OFFLINE or FATAL OFFLINE/Down or FATAL/Down.
NEWPROC to either OFFLINE or FATAL OFFLINE/NewDown or FATAL/NewDown.
Any allowed VprocState transition becomes effective immediately. With the exception of AMPs being recovered using the Recovery Control Task, no changes are made to the ConfigStatus, the static message group, or whether the vproc is the Control AMP. These changes are deferred until the next system restart.

The SET VprocList command is governed by the allowable VprocState transitions shown in the following table.

Current VprocState Desired VprocState
NONODE OFFLINE ONLINE NEWPROC FATAL UTILITY
NONODE No change. Not allowed. Not allowed. Not allowed. Not allowed. Not allowed.
OFFLINE Not allowed. No change. Allowed.

If Config-Status = Down, initiate recovery.

Allowed

if Config- Status = NewDown.

Allowed. Not allowed.
ONLINE Not allowed. Allowed.

ConfigStatus will be Down after system restart.

No change. Not allowed. Allowed.

ConfigStatus will be Down after system restart.

Not allowed.
NEWPROC Not allowed. Allowed.

ConfigStatus will be NewDown after system restart.

Not allowed. No change. Allowed.

Config Status will be NewDown after system restart.

Not allowed.
FATAL Not allowed. Allowed. Allowed.

If ConfigStatus = Down, initiate recovery.

Allowed if ConfigStatus = NewDown. No change. Not allowed.
UTILITY Not allowed. Not allowed. Not allowed. Not allowed. Not allowed. No change.

Example: Taking specified vprocs offline

This example shows how to take vprocs 0 and 1 offline.

Enter a command, HELP or QUIT:

set /v 0 to 1 offline

Vproc 0’s VprocState has been set from ONLINE to OFFLINE.
NOTE: Vproc 0 will be forced down (i.e., its ConfigStatus will be Down) 
after the next system restart.

Vproc 1’s VprocState has been set from ONLINE to OFFLINE.
NOTE: Vproc 1 will be forced down (i.e., its ConfigStatus will be Down) 
after the next system restart.

Example: Setting a vproc online

This example shows how to take vproc 1 online.

Enter a command, HELP or QUIT:

set /v 1 online

Vproc 1’s VprocState has been set from OFFLINE to ONLINE.
NOTE: Vproc 1 will begin recovery in the background via
      the Recovery Control Task and will assume a
      VprocState/ConfigStatus of UTILITY/Catchup.
      Please refer to the System Console for
      additional status information.