11.10.1 Adding data DB areas
This subsection explains how to use the adbmodarea command to add new data DB areas. For details about the adbmodarea command, see adbmodarea (Add and Change DB Areas) in the manual HADB Command Reference.
A specification example for adding a data DB area is shown below. Only the HADB administrator can add a data DB area.
- ■ Specification example
-
A data DB area is added.
adbmodarea /HADB/server/conf/adbmodarea.opt
When you execute the adbmodarea command, you need to create a DB area addition/modification option file in which the adbaddarea operand of the DB area addition/modification option is specified.
For details about the adbaddarea operand of the DB area addition and modification option, see Specification format for the adbmodarea command under adbmodarea (Add and Change DB Areas) in the manual HADB Command Reference.
If one of the following cases is applicable when you are defining a new base table, B-tree index, text index, or range index, consider adding a data DB area:
-
If you are defining a range index
We recommend that you add a DB area dedicated to the range index.
-
If you want to separate a global buffer or data DB area file from the existing data DB area
Add a data DB area in order to distribute the effect on the existing base table, B-tree index, text index, or range index.
-
If there is no data DB area that has a size adequate to store the new base table
- Note
-
- ■ Relationship between the added data DB area and allocated global buffer
-
If the -o option is specified for the adbbuff operand in the server definition, a global buffer is automatically allocated to the added data DB area according to the specification in the -o option.
Even if the -o option is not specified, a global buffer similar to the one that is allocated when the -o option is specified is automatically allocated to the added data DB area.
In either case, if the required processing performance is not achieved, specify the global buffer allocated to the added DB area in the adbbuff operand. For details, see 7.2.11 Operands and options related to global buffers (command format) and 8.5.2 Modifying the server definition.
Also, if necessary, re-evaluate the value specified for the adbbuff operand. For details, see 13.2.2 Reducing the SQL statement execution time.