Hitachi

Hitachi Advanced Database Command Reference


34.3.6 Expanding a DB area (adding DB area files using regular files)

This example expands a data DB area (adds data DB area files) by executing the adbmodarea command. It adds data DB area files under the DB directory, as shown in the following:

[Figure]

Explanation:
  • Data DB area file entities have been created in data DB area OLDAREA under the DB directory.

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

    DB area name: OLDAREA

    Number of DB area files to be added: 2

    Initial allocation size for each DB area file: 500 megabytes

The example uses the following procedure to execute the adbmodarea command.

Procedure
  1. Create a DB area addition and modification option file.

  2. 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 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
              -i 500M,2                                     ...2
Explanation:
  1. Specifies the data DB area name (OLDAREA).

  2. Specifies the initial allocation size (500 megabytes) for each DB area file and the number of files (2) to be added.

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