Tivoli Header

Administrator's Reference

DEFINE DBVOLUME (Define a Database Volume)

Use this command to define a new database volume. All database volumes reside on random access media. You can have TSM create the volume before it is assigned.

Attention: Do not change the size of a database volume after you have defined it to TSM. If you change the size, TSM may not initialize correctly and you could lose data.

When you define a new database volume, you provide additional space to the database. To permit the database to use this additional space, use the EXTEND DB command.

A database volume must be at least 5MB. TSM uses 1MB of each database volume for overhead. For example, if you define a 9MB database volume, 8MB are available for storage.

Privilege Class

To issue this command, you must have system privilege or unrestricted storage privilege.

Syntax

>>-DEFine DBVolume--volume_name--+--------------------------+--->
                                 '-Formatsize--=--megabytes-'
 
   .-Wait--=--No------.
>--+------------------+----------------------------------------><
   '-Wait--=--+-No--+-'
              '-Yes-'
 
 

Parameters

volume_name (Required)
Specifies the file name of the database volume. Enclose the name in quotation marks if it contains embedded blanks or equal signs.
     l:\win32app\ibm\adsm\server\db1.dsm

Formatsize
Specifies the size of the volume that is defined and formatted in one operation. This parameter is optional. The value is specified in megabytes.

Wait
Specifies whether a volume creation and formatting operation is performed in the foreground or background. This parameter is optional. The default is NO. It is ignored unless the FORMATSIZE parameter is also specified.

No
Specifies that a volume creation and formatting operation is performed in the background.

Yes
Specifies that a volume creation and formatting operation is performed in the foreground.
Note:
You cannot specify WAIT=YES from the server console.

Examples

Task 1

Create a database volume named db.2.

Command:
define dbvolume db.2

Task 2

Format a new database volume of 20MB in the server directory with a file name of db3.dsm and wait for the server to define the database volume.

Command:
define dbvolume db3.dsm formatsize=20 wait=yes

Related Commands

Table 50. Commands Related to DEFINE DBVOLUME

Command Description
DEFINE DBCOPY Creates a volume copy of a database volume.
DELETE DBVOLUME Deletes a volume from the database.
EXTEND DB Extends usable database storage within the volumes previously allocated for its use.
QUERY DBVOLUME Displays information database volumes.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]