Nonstop Database, HiRDB Version 9 System Operation Guide
This section describes how to use the status information file for system log files to identify the cause of an area insufficiency for the system log files.
When the percentage of free area for the system log files falls below the warning value, a status information file for system log files is output. This file acquires the status of the system log files, synchronization points, and transactions. The status information file for system log files is created in the $PDDIR/spool/pdjnlinf directory. The file name is as shown below:
pdsnap.server-name.time-issued
pdsnap.bes1.030415124350 <- File name#1 Date:2003/04/15 <- Date issued#1 Time:12:43:50 <- Time issued#1 pdlogls -d sys -e -s bes1 <- Command issued internally by HiRDB Execution result of the pdlogls command : pdlogls -d spd -e -s bes1 Execution result of the pdlogls command : pdls -d trn -a -s bes1 Execution result of the pdls command : pdls -d svr Execution result of the pdls command#2 : |
Use the status information file for system log files to identify the cause of the area insufficiency for the system log files. The method of identifying the cause is described below.
Identify the status information file for the system log files from the KFPS01160-E or KFPS01162-W message.
Refer to the contents of the status information file for the system log files and check the status of the system log files. The STATUS entry in the output results of the pdlogls -d sys command shows the status of the system log files.
The cause can be inferred from the status of the system log files. The following table shows the causes of insufficient free area for system log files.
Table 3-12 Causes of free area insufficiencies for system log files
Status of system log files | Causes of insufficient free area for system log files |
---|---|
Many files are in unload wait status | System log files might not have been unloaded. You must unload system log files regularly. |
Many files are in overwrite disabled status | One of the following causes might be applicable:
|
Many files are in extracting status | Extraction processing might not have been applied to the system log files. Either revise the design of the system log files or revise the operation method for data linkage that uses the HiRDB Datareplicator. |
Many files are in overwriting denied status for online reorganization | Update processing of updatable online reorganization might not have been applied. Either revise the design of the system log files or revise the method of operating updatable online reorganization of the inner replica facility. |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.