15.00 - SET vproclist - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

SET vproclist

Purpose  

The SET vproclist command sets the new state of a vproc or the new states for a list of vprocs.

Syntax  

 

Syntax element …

Description

/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” on page 944.

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.

Note: 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  

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  

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.