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:
- 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
-
-
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 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:
-
-
Specifies the data DB area name (OLDAREA).
-
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.