34.3.3 Deleting a DB area (deleting DB area files that are block special files)
This example deletes a data DB area by executing the adbmodarea command. It deletes DB area files that are block special files, as shown in the following:
- Explanation:
-
-
The data DB area OLDAREA is deleted.
-
Block special files (/dev/mapper/VolG01 and /dev/mapper/VolG02) are allocated as the data DB area files for OLDAREA.
-
No tables or indexes are stored in OLDAREA.
-
OLDAREA is not the only data DB area.
-
This example assumes that the required access permissions have been granted for the symbolic link destination directory and the block special files.
The example uses the following procedure to execute the adbmodarea command.
- Procedure
-
-
Create a DB area addition and modification option file.
-
Execute the adbmodarea command.
-
Using an example, the following subsections explain each of these steps.
- Organization of this subsection
(1) Creating a DB area addition and modification option file
This example creates a DB area addition and modification option file and specifies the name of a data DB area (OLDAREA) that is to be deleted.
- Example of a DB area addition and modification option file
-
adbrmarea -n OLDAREA
(2) Executing the adbmodarea command
adbmodarea /HADB/server/conf/adbmodarea.opt
- Explanation:
-
Specifies the name of the DB area addition and modification option file created in (1) Creating a DB area addition and modification option file.