17.10 - INITVDISK - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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.