15.16.1 Releasing the message log file from fall-back mode
This subsection describes how to release the message log file from fall-back mode. For details about fall-back mode of the message log file, see 10.4.4 Fall-back mode of the message log file.
- Note
-
The message log file is automatically released from fall-back mode in the following condition. An SQL statement or command is executed when the free space of the disk that stores the message log file is larger than or equal to the following value: the value specified (in megabytes) for environment variable ADBMSGLOGSIZE × 2.
- ■ Releasing the message log file on the HADB server from fall-back mode
-
Perform the following procedure.
Procedure:
-
Execute the following command to check the amount of free space on the disk storing the message log file:
df $ADBDIR/spool
-
Reserve free space on the disk, by, for example, deleting unnecessary files. At least the following amount of free space is required:
Value specified for environment variable ADBMSGLOGSIZE (megabytes) x 2
-
- ■ Releasing the message log file on an HADB client from fall-back mode
-
Perform the following procedure.
Procedure (for an HADB client (for Windows)):
-
From the command prompt, execute the following command to check the amount of free space on the disk drive storing the message log file:
echo %ADBCLTDIR%
-
Check the amount of free space on the disk drive storing the message log file.
-
Reserve free space on the disk drive by, for example, deleting unnecessary files. At least the following amount of free space is required:
Value specified for environment variable ADBMSGLOGSIZE (megabytes) x 2
Procedure (for an HADB client (for Linux)):
-
Execute the following command to check the amount of free space on the disk storing the message log file:
df $ADBCLTDIR/spool
-
Reserve free space on the disk, by, for example, deleting unnecessary files. At least the following amount of free space is required:
Value specified for environment variable ADBMSGLOGSIZE (megabytes) x 2
-