15.2.5 Steps to take in the event of a shortage of disk space for storing temporary work files during command execution

Temporary work files are created in the directory specified in the -w option while the following commands are executing:

adbimport command
adbidxrebuild command
adbmergechunk command
adbunarchivechunk command
adbreorgsystemdata command

If any of the following messages is output during execution of one of these commands, a shortage might have occurred in the disk space for storing the temporary work files:

KFAA30959-E
KFAA40204-E
KFAA40205-E
KFAA40207-E
KFAA40208-E
KFAA40214-E
KFAA41205-E
KFAA41206-I

You can determine whether a shortage has occurred in the disk space for storing temporary work files from the information provided in the message. For details, see (1) How to determine whether a shortage has occurred in the disk space for storing temporary work files.

The following are possible causes of a shortage of disk space for storing temporary work files. Take the corrective action appropriate to the cause.

There are unneeded temporary work files on the disk.

See (2) When there are unneeded temporary work files on the disk.
The disk capacity for storing temporary work files is too small to store temporary work files that will be created.
- When the adbimport or adbidxrebuild command was interrupted
  
  See (3) When the disk capacity for storing temporary work files is too small (when the adbimport or adbidxrebuild command was interrupted).
- When the adbmergechunk, adbunarchivechunk, or adbreorgsystemdata command was interrupted
  
  See (4) When the disk capacity for storing temporary work files is too small (when the adbmergechunk, adbunarchivechunk, or adbreorgsystemdata command was interrupted).

Organization of this subsection

(1) How to determine whether a shortage has occurred in the disk space for storing temporary work files
(2) When there are unneeded temporary work files on the disk
(3) When the disk capacity for storing temporary work files is too small (when the adbimport or adbidxrebuild command was interrupted)
(4) When the disk capacity for storing temporary work files is too small (when the adbmergechunk, adbunarchivechunk, or adbreorgsystemdata command was interrupted)

(1) How to determine whether a shortage has occurred in the disk space for storing temporary work files

To determine whether a shortage has occurred in the disk space for storing temporary work files, check the output message. If the output message is any of those listed in the following table, a shortage has occurred in the disk space for storing temporary work files.

Table 15‒1: Messages that are output when a shortage has occurred in the disk space for storing temporary work files and the information provided in the messages
No.	Message ID	Information provided in the message
No.	Message ID	File name	Error code	Error number
1	`KFAA30959-E`	File name^#1	--	`28` (`ENOSPC`)
2	`KFAA40204-E`	File path name^#2	--	--
3	`KFAA40205-E`	--	--	`28` (`ENOSPC`)
4	`KFAA40207-E`	--	`-210` or `-230`	--
5	`KFAA40208-E`	--	`-210` or `-230`	--
6	`KFAA40214-E`	--	--	`28` (`ENOSPC`)
7	`KFAA41205-E`	File path name^#2	--	`28` (`ENOSPC`)
8	`KFAA41206-I`	File path name^#2	--	`28` (`ENOSPC`)

Legend:

--: This information is not output in the corresponding message.

#1

Check the directory that contains the file that is indicated in the message. The following steps explain how to check the directory that contains a specific file:

Use the OS's find command to locate the file whose file name is displayed in the message.

The following shows an example of the OS's find command.

■ Example execution of the OS's find command

[Figure]

Explanation

Execute the find command in which is specified the file name (xxxxx) displayed in the message.

Check the command's execution results to determine whether the directory storing the file matches the directory specified in the -w option of each command.

If the directories match, a shortage has occurred in the disk space for storing temporary work files.

#2

Check the directory that contains the file based on the path name displayed in the message.

Check if the directory contained in the path name matches the directory specified in the -w option of each command.

If the directories match, a shortage has occurred in the disk space for storing temporary work files.

Note

The directory specified in the command's -w option means one of the following:

Directory specified in a command's -w option
Directory specified in the directory path file that was specified in the -w option in the command

To Page Top

(2) When there are unneeded temporary work files on the disk

The following procedure explains how to delete the unneeded temporary work files.

Procedure:

Check if there are any commands that need to be re-executed.

Execute the adbdbstatus command with table specified in the -c option. This command's execution results show in the Rerun_command column in the table summary information the names of the commands that need to be re-executed. If no commands need to be re-executed, nothing is displayed in the Rerun_command column.

If there is any command that needs to be re-executed, go to step 2. If no commands need to be re-executed, go to step 3.

For details about the adbdbstatus command, see adbdbstatus (Analyze the Database Status) in the manual HADB Command Reference.
Re-execute the commands.

Re-execute the commands that were found to be needing re-execution in step 1. If the re-executed commands terminate normally, the temporary work files have been deleted, and there is no need to perform step 3.
Delete the remaining temporary work files.

Because any remaining temporary work files are all unneeded, delete them (with the OS's rm command, for example).

To Page Top

(3) When the disk capacity for storing temporary work files is too small (when the adbimport or adbidxrebuild command was interrupted)

If the disk capacity for storing temporary work files is too small, you need to change the storage location for temporary work files to another disk with greater capacity. This subsection explains how to change the storage location of temporary work files when the adbimport or adbidxrebuild command has been interrupted.

For details about how to change the storage location of temporary work files when the adbmergechunk, adbunarchivechunk, or adbreorgsystemdata command has been interrupted, see (4) When the disk capacity for storing temporary work files is too small (when the adbmergechunk, adbunarchivechunk, or adbreorgsystemdata command was interrupted).

The procedure for changing the storage location for temporary work files depends on whether the directory specified in the -w option in the command is changed. The directory specified in the command's -w option means one of the following:

Directory specified in the command's -w option
Directory specified in the directory path file that was specified in the -w option in the command

The following subsections explain the procedure when the directory specified in the -w option in the command is and is not changed.

(a) When the directory specified in the -w option in the command is changed

Procedure:

Change the directory specified in the -w option in the command.

Change the directory specified in the -w option in the command to a directory on another disk with greater capacity.

The following shows example directory path file specifications before and after the directories specified in the directory path files are changed.

■ Example of directory path file specifications before change
```
/mnt/disk1/xxxxx
/mnt/disk2/yyyyy
/mnt/disk3/zzzzz
```
Explanation

Directories on disks resulting in a space shortage (/mnt/disk1 to /mnt/disk3) are specified in the directory path files before the change as the storage locations for temporary work files.

■ Example of directory path file specifications after change
```
/mnt/largedisk1/xxxxx
/mnt/largedisk2/yyyyy
/mnt/largedisk3/zzzzz
```
Explanation

This example changes the storage locations for temporary work files by specifying different disks with greater capacity (/mnt/largedisk1 to /mnt/largedisk3) in place of /mnt/disk1 to /mnt/disk3.
Execute the adbidxrebuild command.

Execute the adbidxrebuild command with the -w option and the --create-temp-file option both specified. For details about the specification format for the adbidxrebuild command, see adbidxrebuild (Rebuild Indexes) in the manual HADB Command Reference.

(b) When the directory specified in the -w option in the command is not changed

Procedure:

Copy the temporary work files to a different directory.

Use the OS's cp command, for example, to copy all temporary work files stored immediately under the directory specified in the -w option of the command to a directory on another disk with a greater capacity.

The following shows example directory path file specifications and an example of the OS's cp command for copying the temporary work files stored under the directories specified in the directory path files.

■ Example of directory path file specifications
```
/mnt/disk1/xxxxx
/mnt/disk2/yyyyy
/mnt/disk3/zzzzz
```
Explanation

The storage locations for temporary work files are set to directories on disks resulting in a space shortage (/mnt/disk1 to /mnt/disk3).

■ Example of the OS's cp command
```
cp -R /mnt/disk1/xxxxx  /mnt/largedisk1/xxxxx
cp -R /mnt/disk2/yyyyy  /mnt/largedisk2/yyyyy
cp -R /mnt/disk3/zzzzz  /mnt/largedisk3/zzzzz
```
Explanation

The temporary work files are copied from the directories on the disks resulting in a space shortage (/mnt/disk1 to /mnt/disk3) to directories on different disks with greater capacity (/mnt/largedisk1 to /mnt/largedisk3).
Delete the directory specified in the -w option in the command.

Delete the directory specified in the -w option in the command by using, for example, the OS's rm command. The following shows an example of the OS's rm command for deleting directories.

■ Example of the OS's rm command
```
rm  -r  /mnt/disk1/xxxxx
rm  -r  /mnt/disk2/yyyyy
rm  -r  /mnt/disk3/zzzzz
```
Explanation

The directories are deleted from the disks resulting in a space shortage (/mnt/disk1 to /mnt/disk3).
Create a symbolic link to the directory on the disk with the greater capacity.

Execute the OS's ln command to create a symbolic link to the directory on the other disk with greater capacity. In this case, specify the directory that was specified in the -w option in the command as the path name of the symbolic link. The following shows an example of the OS's ln command for creating a symbolic link.

■ Example of the OS's ln command
```
ln  -s /mnt/largedisk1/xxxxx  /mnt/disk1/xxxxx
ln  -s /mnt/largedisk2/yyyyy  /mnt/disk2/yyyyy
ln  -s /mnt/largedisk3/zzzzz  /mnt/disk3/zzzzz
```
Explanation

This example specifies directories (/mnt/largedisk1/xxxxx to /mnt/largedisk3/zzzzz) on disks with greater capacity as the link target and creates symbolic links (/mnt/disk1/xxxxx to /mnt/disk3/zzzzz) with the same names as the directories specified in the -w option in the command (/mnt/disk1/xxxxx to /mnt/disk3/zzzzz).
Re-execute the interrupted command.

Re-execute the interrupted adbimport or adbidxrebuild command. The command's processing resumes from the sort processing or the B-tree index and text index creation processing.

If the KFAA50247-E message is displayed after the command has re-executed, delete all the temporary work files that were copied in step 1. Finally, execute the adbidxrebuild command with the --create-temp-file option specified.

To Page Top

(4) When the disk capacity for storing temporary work files is too small (when the adbmergechunk, adbunarchivechunk, or adbreorgsystemdata command was interrupted)

If the disk capacity for storing temporary work files is too small, you need to change the storage location for temporary work files to another disk with greater capacity. This subsection explains how to change the storage location of temporary work files when the adbmergechunk, adbunarchivechunk, or adbreorgsystemdata command has been interrupted.

For details about how to change the storage location of temporary work files when the adbimport or adbidxrebuild command has been interrupted, see (3) When the disk capacity for storing temporary work files is too small (when the adbimport or adbidxrebuild command was interrupted).

Directory specified in the command's -w option
Directory specified in the directory path file that was specified in the -w option in the command

The following subsections explain the procedure when the directory specified in the -w option in the command is and is not changed.

(a) When the directory specified in the -w option in the command is changed

Procedure:

Change the directory specified in the -w option in the command.

Change the directory specified in the -w option in the command to a directory on another disk with greater capacity.

For specification examples of directory path files when changing the directories specified in the file, see (3) When the disk capacity for storing temporary work files is too small (when the adbimport or adbidxrebuild command was interrupted).
Re-execute the interrupted command.

Re-execute the interrupted command (adbmergechunk, adbunarchivechunk, or adbreorgsystemdata command).

(b) When the directory specified in the -w option in the command is not changed

Procedure:

Create a symbolic link to the directory on a disk with greater capacity.

Execute the OS's ln command to create a symbolic link to a directory on another disk with greater capacity. In this case, specify the directory that was specified in the -w option in the command as the path name of the symbolic link.

For an example of executing the ln OS command, see (3) When the disk capacity for storing temporary work files is too small (when the adbimport or adbidxrebuild command was interrupted).
Re-execute the interrupted command.

Re-execute the interrupted command (adbmergechunk, adbunarchivechunk, or adbreorgsystemdata command).

To Page Top