34.3.5 Expanding a DB area (adding DB area files using block special files)

This example expands a data DB area (adds data DB area files) 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) have been allocated as the data DB area files for data DB area OLDAREA.
This example allocates block special files (/dev/mapper/VolG03 and /dev/mapper/VolG04) as new data DB area files in DB area OLDAREA.

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

DB area name: OLDAREA

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

Example of a DB area addition and modification option file

adbexpandarea -n OLDAREA \                                  ...1
              -v /dev/mapper/VolG03,/dev/mapper/VolG04 \    ...2
              -q \                                          ...3
              -i 500M,2                                     ...4

Explanation:

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

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