The following table shows the troubleshooting information that is collected by HiRDB when an error occurs.

Table 20-1 Troubleshooting information collected by HiRDB when an error occurs

Information collected	Explanation
Message log file ($PDDIR/spool/pdlog1, pdlog2)	This file consists of messages output by HiRDB; it can be viewed with the pdcat command. If an error occurs, make a backup of this file.
Standard output and standard error output when executing commands	These screens are output information of the operating command and error messages, which are displayed in the screen that the operating command is input. Save them as redirect if you needed.
Syslogfile	This file contains messages output by HiRDB.This file consists of messages output by HiRDB; it can be referenced using an OS editor. If there are too many accesses to syslogfile at the same time, some messages might not be output.
Save core file# ($PDDIR/spool/save/file-name	This is HiRDB-related process data and stack information. Because only up to three core files are saved in each server, save core files that need to be saved should be backed up. The file name format is server-name-n (If the server name is not known, a number might be displayed for the server name.), where n is the sequence number (1 to 3) of the save core file. Note that a sequence number might not be assigned in some cases.
Server process abnormal termination information file# ($PDDIR/spool/save/file-name.deb,file-name.ext.deb)	This file stores information about a process that terminated abnormally. If this file is output, make a backup. If a process is forcibly terminated by the pdcancel -d command, the .ext.deb file name format is server-name.process-ID.cancel.ext.deb.
Abort information file# ($PDDIR/spool/save/file-name)	This is a file of abort information. If this information is output, back it up. The abort codes only can be referenced using an OS editor. The file name format is abcode.server-process-ID.
Snap during an error# ($PDDIR/spool/save/file-name)	This is a file of snap information generated during an error. If this information is output, back it up. The file name format is server-name-n.deb (If the server name is not known, a number might be displayed for the server name), where n is the sequence number (1 to 3) of the save core file. Note that a sequence number might not be assigned in some cases.
Shared memory dump file# ($PDDIR/spool/pdshmdump/file-name)	This file consists of data maintained by HiRDB in the shared memory. If this information is output, back it up. The file name format is server-name.rmb.server-process-ID.
Simple dump file# ($PDDIR/spool/server-directory/file-name)	This file consists of data maintained by HiRDB in the shared memory and process private memory. If this information is output, back it up. The file name format is a combination of the date and process ID.
RPC trace file	This is a file of the message sent and received by HiRDB using RPC. If this information is output, back it up. The file name is specified in the pd_rpc_trace_name operand.
Command trace file ($PDDIR/spool/cmdlog1, cmdlog2)	This file consists of statistical information on executed commands (including commands generated internally by HiRDB). Use an OS editor to reference this information. If an error occurs, back up this statistical information.
Error log file ($PDDIR/spool/errlog/errlog1, errlog2)	This is a file of internal information output by HiRDB. If this information is output, back it up.
Connected user data file ($PDDIR/spool/cnctusrinf\)	This file contains information on users who were connected when HiRDB terminated. Use an OS-provided text editor to view this information.
Connected user details file ($PDDIR/spool/cnctusrdtl)
Data file for locked resources management table ($PDDIR/spool/pdlckinf/output-date-and-time.mem)	This is a file of user information when deadlock, a lock-release timeout, or an error due to a space shortage in the table for managing locked resources occurs during locking by HiRDB. Use an OS-provided text editor to view this information. If this information is output, back it up.
PRF trace information file ($PDDIR/spool/pdprf/file-name)	This is a file of trace information for troubleshooting that is output by HiRDB. Use the pdprfed command to edit the output for referencing. The file name format is pdprf_nnn, where nnn is a file generation number. You can use the pd_prf_output_directory operand to change the PRF trace output directory.

#: This is troubleshooting information that is output when a HiRDB server process terminates abnormally. Abnormal termination of a HiRDB server process can be confirmed when the KFPS01820-E message is output. The server name, process ID, and termination status can be determined from this message. Note, however, that troubleshooting information is not output in the following cases:

1. Termination status begins with c or d (no troubleshooting information is output)
2. Termination status is 0009 (the abort information, save core file, and shared memory dump file are not output)