Entering content frame

Procedure documentation Deleting Volume Parameters Locate the document in its SAP Library structure

Use

You delete the parameters for the specified volume from the database parameter file. This command deletes only the parameters of the volumes; you cannot fully delete a volume that has been used.

Caution

Use this command with care. Inconsistencies in the volume settings can damage the database instance.

Prerequisites

You have the server authorization ParamCheckWrite.

Syntax

param_delvolume <vol_no> <vol_mode>

Options

<vol_no>

Number of the volume

<vol_mode>

Mode of the volume

Option <vol_mode>

DATA

Data volume: the number of the data volume is assigned by the system as a four-digit number with leading zeros when the volume is created

LOG

Log volume: the number of the log volume is assigned by the system as a three-digit number with leading zeros when the volume is created

MLOG

Mirrored log volume (see also: Logging Mode)

Example

Logging on to the database manager CLI as operator DBM with password DBM, connecting to the database instance hoteldb, deleting volume number 3 of type DATA

dbmcli –u DBM,DBM –d hoteldb param_delvolume 3 DATA

Reply

The system displays an OK message.

In the event of errors, see Reply Format.

 

Leaving content frame