Nonstop Database, HiRDB Version 9 System Operation Guide
If a deadlock or timeout occurs when Y is specified for the pd_lck_deadlock_info operand, HiRDB outputs the information shown in the following table.
Table 8-7 Information output when a deadlock or timeout occurs
Output information | Description |
---|---|
Deadlock information |
|
Timeout information | This is information that indicates that the lock-release wait time has elapsed. |
Deadlock information and timeout information are output to the following files, which are called the deadlock/timeout information files:
The file-name is determined by HiRDB as follows on the basis of the date and time the deadlock or timeout occurred:
To output deadlock/timeout information, the following specifications must be made in the system common definition:
When the following messages are output, the deadlock or timeout information should be referenced:
Deadlock or timeout information can be referenced with an OS command (for example, the cat command or the vi command). The KFPS00441-I and KFPS00451-I messages display the file name to be specified in these commands. For details about the cat and vi commands, see the OS documentation.
For details on the deadlock and timeout information that is output, see 8.6.2 Deadlock information that is output and 8.6.3 Timeout information that is output.
It might be possible to reduce the frequency of deadlock and timeout occurrences by changing the UAP access sequence or widening the UAP lock range. It is important to use the deadlock and timeout information that is output to reevaluate the resources that cause the deadlock or timeout. For details on the actions to be taken with respect to the resources that result in deadlock or timeout, see the HiRDB Version 9 UAP Development Guide.
HiRDB does not delete deadlock/timeout information files. Such files must be deleted by the HiRDB administrator when the files are no longer needed. The following deletion procedures are provided.
The pdcspool command can be used to delete unneeded deadlock/timeout information files. However, the pdcspool command deletes all troubleshooting information files under $PDDIR/spool. To delete only deadlock/timeout information files, use the method described below in (c) With an OS command.
If all is specified in the pd_spool_cleanup_interval_level operand, HiRDB deletes deadlock/timeout information files periodically. The default is that HiRDB deletes them every 24 hours, but you can change this deletion interval with the pd_spool_cleanup_interval operand.
If all is also specified in the pd_spool_cleanup_level operand, HiRDB also deletes deadlock/timeout information files when it starts.
Use an OS function (the OS's rm command, for example) to delete a deadlock/timeout information file. For details about the rm commands, see the OS documentation.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.