34.3.1 Adding a DB area (creating DB area files using block special files)

This example adds a data DB area to the DB directory by executing the adbmodarea command. It allocates block special files as the data DB area files, as shown in the following:

[Figure]

Explanation:

Block special files (/dev/mapper/VolG01 and /dev/mapper/VolG02) are allocated as data DB area files for the added data DB area.

The following is the definition of the data DB area that is to be added:

DB area name: NEWAREA
Number of DB area files: 2
Initial allocation size for each DB area file: 500 megabytes

This example assumes the existence of a symbolic link destination directory and block special files and that the required access permissions have been granted.

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
(2) Executing the adbmodarea command

(1) Creating a DB area addition and modification option file

This example creates a DB area addition and modification option file and specifies the definition of a data DB area that is to be added.

Example of a DB area addition and modification option file

adbaddarea -n NEWAREA \                                  ...1
           -v /dev/mapper/VolG01,/dev/mapper/VolG02 \    ...2
           -q \                                          ...3
           -i 500M,2                                     ...4

Explanation:

Specifies the data DB area name (NEWAREA).
Specifies the block special files (/dev/mapper/VolG01 and /dev/mapper/VolG02) that are to be allocated as the data DB area files.
Specifies that the data DB area files are to be created in quick mode.
Specifies the initial allocation size (500 megabytes) of each data DB area file and the number of files (2) to be created.

To Page Top

(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.

To Page Top