2.22 pdcspool (Delete troubleshooting information)

Organization of this section
(1) Function
(2) Executor
(3) Format
(4) Options
(5) Rules
(6) Notes

(1) Function

The pdcspool command deletes the following files created by HiRDB:

(2) Executor

HiRDB administrator

(3) Format

pdcspool [-i] [-d days] [-k type]

(4) Options

(a) -i

Specifies that when a file storing troubleshooting information is to be deleted, a prompt is to be returned to the standard output device requesting confirmation that the file is to be deleted (in the case of temporary work files, the option does not return a prompt). Responding with a y to the prompt causes the file to be deleted. The default is to delete the file without generating a prompt, in which case the name of the deleted file is output to the standard output device.

(b) -d days ~ <unsigned integer> ((0-24855)) <<1>>

This option makes files that were created 24 hours [Figure] specified number of days from the time the pdcspool command was executed subject to deletion. If 10 is specified, all files created 240 or more hours before are subject to deletion.

If 0 is specified, all troubleshooting information in the spool and all temporary work files in the temporary work file storage directory are subject to deletion. Note that even when 0 is specified, the files listed below are not deleted if their last update time is within 3,600 seconds of the command's start time. If any files remain, re-execute the command after 3,600 seconds.

If all parameters are omitted, the troubleshooting information in the spool and the temporary work files in the temporary work file storage directory that were created 24 or more hours before are subject to deletion.

If you execute periodically commands that take a long time to execute, such as pdcopy and pdrstr, specify a value that provides sufficient time for the commands to be completed.

(c) -k type

This option specifies the range of troubleshooting information to be deleted.

If this option is omitted, the command deletes all troubleshooting information except for the access path information.

all
Deletes all troubleshooting information and temporary work files, including access path information, unless the pd_tmp_directory operand is omitted in the system definition or the specified directory is /tmp, /usr/tmp, or /var/tmp.
dump
Deletes the files internally collected by HiRDB (files other than the deadlock timeout information and access path information files).

(5) Rules

  1. The pdcspool command can be executed at any time, whether or not HiRDB is active.
  2. The pdcspool command must be executed at each server machine.

(6) Notes

  1. Return code 0 or 4 for the pdcspool command indicates normal termination, and return code 12 indicates abnormal termination.
  2. The pdcspool command may not delete a troubleshooting information file that was output by a command or utility executed by a user other than the HiRDB administrator. In such a case, the user with the deletion privilege for the troubleshooting information files must delete the file using the OS's rm command. However, do not delete the following directories and files in the temporary work file storage directory ($PDDIR/tmp directory):
    • home
    • pdommenv
    • Files whose names begin with CMb
  3. If the TMPDIR environment variable has been specified, the temporary work files will be output to the directory specified in this environment variable, not to the $PDDIR/tmp directory. The temporary work files in the directory specified in the TMPDIR environment variable are not subject to deletion by the pdcspool command. Also, pipe files (FIFO) are not deleted (you need to delete these files directly using the OS's rm command).
  4. The pdcspool command makes all files that were created by HiRDB in the directories listed in the table below subject to deletion.
    Therefore, all files created in these directories will be deleted together. The following table describes the directories that are subject to deletion:
    DirectoryDescription of output file-k optionRemarks
    High-order directoryLow-order directoryalldumpOmitted
    $PDDIR/tmp
    (temporary work files storage directory)
    --Temporary work fileYYYIf 0 is specified in the -d option, this command deletes the files whose last update time was at least 3,600 seconds before the command started.
    Directory specified in the pd_tmp_directory operand in the unit control information definition--Temporary work fileYYY
    $PDDIR/spool
    (troubleshooting information)
    pdsqldumpAccess path informationYNNThis is output when 1 or a greater value is specified in the PDVWOPTMODE client environment definition and then an SQL statement is executed.
    pdlckinfDeadlock/timeout informationYNYThis is output when an error occurs during lock control.
    saveSave core fileYYYThis is output upon abnormal termination of a process.
    pdshmdumpShared memory dump fileYYYThis is output upon abnormal termination of a process or a unit.
    pdsysdump(1,2)Quick dump fileYYYNone.
    pdsdsdump(1,2)YYYThis is output in a HiRDB single server configuration.
    pdfesdump(1,2)
    pddicdump(1,2)
    pdbesdump(1,2)
    YYYThis is output in a HiRDB parallel server configuration.
    pdjnlinfSystem log file status information fileYNYOnly files beginning with pdsnap. are deleted.
    pdtrninfRecovered transaction information fileYNYThis is output only when Real Time SAN Replication is used.
    Legend:
    Y: Deleted.
    N: Not deleted.
    --: Not applicable
    Note that directories and files under the directories listed below are not deleted:
    High-order directoryName of directory or file that is not deletedDescription of output file
    $PDDIR/spool
    (troubleshooting information)
    Pipe fileAll pipe files (any file name)
    $PDDIR/tmp
    (temporary work files storage directory)
    Pipe fileAll pipe files (any file name)
    homeCurrent working directory of a process where HiRDB runs
    pdommenvShared memory information file
    File whose name begins with CMbDifferential information file for the pdbufls command
    Directory specified in the pd_tmp_directory operand in the unit control information definition#Pipe fileAll pipe files (any file name)
    homeCurrent working directory of a process where HiRDB runs
    pdommenvShared memory information file
    File whose name begins with CMbDifferential information file for the pdbufls command
#: Not deleted if any of the following is specified in the pd_tmp_directory operand:
  • /tmp
  • /usr/tmp
  • /var/tmp