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---------------------------------> .-Wait--=--No------. >-----+---------------------------+---+------------------+----->< '-Formatsize--=--megabytes--' '-Wait--=--+-No--+-' '-Yes-'
Parameters
Specify either a regular file name or, if you are using a raw partition, a symbolic link to a character special file. A regular file name can be either a fully qualified path name or a path name relative to the current working directory. For example, if the file name is mainvol and the current working directory is /opt/IBMadsm-s/bin, the volume name would be:
/opt/IBMadsm-s/bin/mainvol
A symbolic link to a character special file would be entered in the format:
/dev/.../rdsk/.../fn
Where /... is zero or more directories and fn is the file name. For example,
/dev/rdsk/c1t34ds6
Attention: TSM cannot always detect if data already exists on a raw partition. Existing data can be destroyed if you define a volume to that partition.
Note: | You cannot specify WAIT=YES from the server console. |
Examples
Task 1
Create a database volume named 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.
Related Commands
Table 48. 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. |