INITVDISK - 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 INITVDISK command initializes the Teradata Database 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
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.

Database 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.