15.3.1 When a free space shortage is caused by an increase in the size of the DB area files

If the size of a DB area file increases and thus reduces the available space in the disk where the DB area file is stored, try one of the following methods to deal with this problem.

Expand the size of the DB area files.
Change the storage location for DB area files.
Reduce the size of the work table DB area files.

For details about the actions that can be taken if the preceding methods are ineffective for securing free space in the DB areas, see 11.10.6 Securing free space in a data DB area.

Organization of this subsection

(1) Expanding the size of the DB area files
(2) Changing the storage location for DB area files
(3) Reducing the size of the work table DB area files

(1) Expanding the size of the DB area files

The method of expanding the size of the DB area files varies depending on whether regular files or block special files are used. The following describes each method.

For regular files

Delete unnecessary files to increase free space on the disk.

When free space on the disk is increased, the HADB server automatically extends DB area files to their maximum value. For details about the maximum value of DB area files, see 2.4.5 DB area automatic extension.
For block special files

If you are using the OS-supported LVM, expand the logical volume (LV). For details about how to expand the LV, see the documentation for the operating system you are using.

When the LV is expanded, the HADB server automatically extends DB area files to their maximum value. For details about the maximum value of DB area files, see 2.4.5 DB area automatic extension.

To Page Top

(2) Changing the storage location for DB area files

Change the storage location for DB area files to a disk having a larger capacity. How to change the storage location for DB area file is explained below.

The following figure shows an example of the DB area file configuration before the storage location is changed.

Figure 15‒1: Example of DB area file configuration before change

The disk containing the block special file (/dev/mapper/vol01) symbolically linked from the DB area under the DB directory is full. Since there is no more free space, the storage locations of these files must be changed.

For details about how to change the storage location of DB area files, see (2) Changing the storage location of a data DB area file (block special file) in 11.10.5 Changing the storage location of data DB area files.

To Page Top

(3) Reducing the size of the work table DB area files

If the disk becomes full due to the increased size of the work table DB area files consisting of regular files, use the following procedure to reduce the size of the work table DB area files.

Procedure:

Normally terminate the HADB server by using the adbstop command.
Delete work table DB area files by using an OS command or similar method.
Normally start the HADB server by using the adbstart command.

To Page Top