15.5.2 Steps to take when a problem occurs in a system log file
When a problem occurs in a system log file (master log file or user log files), one of the following messages is output:
-
KFAA30959-E
-
KFAA41205-E
If you cannot resolve the problem that caused the error message to be output after checking the return codes for the system calls that are found in the above messages, take the following actions.
- To resolve the problem that caused the error message to be output:
-
-
Check whether the HADB server can be restarted.
See if the HADB server can be terminated using the adbstop command and restarted using the adbstart command. When the HADB server is restarted, the master log file area that was being used previously is reinitialized. Therefore, if the problem was caused by a shortage in the master log file capacity, restarting the HADB server can solve the problem.
If you cannot restart the HADB server, proceed to step 2.
-
Check the free space on the disk in which the DB directory is stored.
System log files are stored in the DB directory ($DBDIR/ADBSYS/ADBSLG). Check whether there is sufficient free space on the disk on which the DB directory is stored. If the disk has no free space, allocate free space on the disk by following 15.3.3 When a free space shortage is caused by an increase in the size of files other than the DB area files.
If the disk has sufficient free space, proceed to step 3.
-
Check whether a system log file has been corrupted.
If you cannot resolve the problem even though the disk has sufficient free space, a system log file might have been corrupted. If an error is returned when you try to access the system log file, the system log file is corrupted. Proceed to step 4.
-
Recover the system log file.
If a system log file is corrupted, you must recover it from the backup. If a database backup collected according to 10.3.1 Backup acquisition method is available, recover the system log file from the backup by following 10.3.2 Recovering the database from the backup.
If the database has not been backed up, the system log file cannot be recovered, and therefore you need to re-create the database.
-