INITVDISK - Advanced SQL Engine - Teradata Database

Database Utilities

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

The INITVDISK command initializes the Teradata File System on the storage associated with a specific AMP, also known as the AMP’s vdisk. This applies only to AMPs with a VprocState of FATAL or NEWPROC. The state of the specified AMP remains unchanged.

Syntax

{ INITVDISK | I } vprocid

Syntax Elements

vprocid
The number that identifies the vproc to be initialized. For a description of vprocIDs, see Definitions of Terms Used in Vproc Manager.

Usage Notes

The initialization is accomplished by invoking File System Initialization Task in the Application partition on the specified AMP. InitVdisk will abort if the Application partition is in use already.

The initialization of the storage associated with a NEWPROC AMP is only relevant prior to database startup.

System startup implicitly initializes the storage for NEWPROC AMPs (if necessary).

Example: Initializing the storage associated with a specified AMP

Enter a command, Help, or Quit:

INITVDISK 3

WARNING: This command will destroy all user and dictionary data of vproc 3’s vdisk. To recover from this may require an ALL TABLES REBUILD!
Are you sure you want to do this (Y/N)?

Y

Starting the file system initialization task on vproc 3.
The Vdisk associated with vproc 3 has been initialized.