15.7.3 Steps to take when a data DB area can no longer be expanded
This subsection explains the steps to take when an existing data DB area can no longer be expanded using the adbmodarea command.
The upper limit for the number of data DB area files that comprise a data DB area is 1,024. You cannot add data DB area files beyond this upper limit.
Therefore, if you want to expand a data DB area that already consists of 1,024 data DB area files, you need to rebuild the data DB area, as described in the following procedure:
-
Output all data from the table.
Use the adbexport command to output all data from the base table to an output data file.
-
Delete the base table and indexes.
Delete the base table and indexes (B-tree index, text index, and range index) that are defined for the data DB area you are rebuilding.
Use the DROP TABLE statement for deletion if a base table alone is defined, or if both a base table and an index are defined. Executing the DROP TABLE statement deletes any indexes defined for the base table at the same time. If only indexes are defined, use the DROP INDEX statement for deletion.
-
Delete the data DB area.
Use the adbmodarea command to delete the target data DB area.
-
Add a new data DB area.
Use the adbmodarea command to add a new data DB area.
When you do so, take into consideration the volume of data that will be added in the future, and specify sufficiently large values for the following: the initial allocation size specified for the -i option of the adbaddarea operand of the DB area addition/modification option, and the number of data DB area files to be created.
-
Redefine a table and indexes.
Use the CREATE TABLE and CREATE INDEX statements to redefine the base table and indexes you deleted in step 2 for the new data DB area you added in step 4.
-
Re-store all table data that was output.
Use the adbimport command to re-store all base table data that was output in step 1 in the base table you redefined in step 5.