SET vproclist - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

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 [[,]...]
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

The following table relates the changes to vproc states occurring before and after Teradata Database restart.

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.