Nonstop Database, HiRDB Version 9 System Operation Guide
The following figure shows the steps to take after the cause of a system log file shortage has been identified.
Figure 20-6 General procedure when the cause of system log file shortage has been identified
Note: The numbers in the figure correspond to the numbers in the explanation below.
The table below shows the action to take in response to each cause of a system log file shortage. If there are multiple causes, take action to eliminate all of them.
Table 20-22 Action to take in response to each cause of a system log file shortage
No. | Cause of system log file shortage | Action |
---|---|---|
1 | Because the automatic log unloading facility stopped, the number of files waiting to be unloaded increased, causing a system log file shortage. | The KFPS01150-E message is output. Take the action prescribed in this message to eliminate the factor that caused the automatic log unloading facility to stop. Also see 3.8.5 Error handling. |
2 | Because system log files were not unloaded or their status was not changed, the number of files waiting to be unloaded increased, causing a system log file shortage. | Unload the system log files that are waiting to be unloaded. For details about how to perform this operation, see 20.17.5 Changing a system log file to unloaded status. |
3 | Because the system log extraction process fell behind during linkage with HiRDB Datareplicator, the number of files in extracting status increased, causing a system log file shortage. | For details about the action to take, see 20.17.9 Action to take when there are system log files that are in extracting status. |
4 | Because transactions were not committed for a long time, the number of files that are overwrite disabled increased, causing a system log file shortage. | Take action by performing the following steps:
|
5 | Because synchronization point dump validation processing was skipped, the number of files that are overwrite disabled increased, causing a system log file shortage. | |
6 | During updatable online reorganization, the number of files in the overwriting denied status for online reorganization increased, causing a system log file shortage. | |
7 | Because an error occurred in a system log file, there was no file that could be made a swappable target, and this caused a system log file shortage. |
Perform the tasks explained here only after you have taken the action described in steps 1 through 3 in Table 20-22 Action to take in response to each cause of a system log file shortage.
Check whether the system log file capacity required for unit restart is available. The checking method follows.
Compare the record counts obtained in steps 2 and 3 above, and if the following conditional expression is satisfied, proceed to (3) below.
If the above conditional expression is not satisfied, add system log files in which the number of additional records needed is defined. For details about how to add system log files, see 20.17.7 Adding system log files.
Execute the pdstart command to restart the unit.
After the unit restarts, transactions can be accepted. However, the system logs that are output by processing of new transactions might cause a system log file shortage again. Therefore, resume the job only after the operation in step (5) is completed.
Confirm that synchronization point validation processing is complete. For details about the confirmation procedure, see 20.17.1(6) Confirm that the synchronization point validation process has completed.
If the number of system log files is insufficient during a restart, the unit will terminate abnormally again before the validation process for the synchronization point dump completes. In this case, take the action described in the error message that is output to syslogfile or the message log file. If the system log file shortage still has not been resolved, see 20.17.3 Unit-restarting procedure (restarting the unit after identifying the cause) and identify the cause.
Take the following steps before resuming the job:
After you have eliminated the system log file shortage, take the actions described in 20.17.10 Actions to take after eliminating the system log file shortage.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.