pdcspool (Delete troubleshooting information)

Function

The pdcspool command deletes the troubleshooting information created by HiRDB in the spool ($PDDIR/spool directory) and the temporary work files created in the temporary work file storage directory ($PDDIR/tmp directory).

Executor

HiRDB administrator

Format

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

Options

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.

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.

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.

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. Note that you cannot specify this option for temporary work files.

all
Deletes all troubleshooting information including the access path information.
dump
Deletes the files internally collected by HiRDB (files other than the deadlock timeout information and access path information files).

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.

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. Therefore, 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 spool ($PDDIR/spool directory) and the temporary work file storage directory ($PDDIR/tmp directory) subject to deletion. Therefore, any files created in those directories will be deleted together. The following table describes the directories that are subject to deletion:
    • Spool ($PDDIR/spool directory)
      DirectoryDescription of output file-k optionRemarks
      alldumpOmitted
      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 file, etc.YYYThis 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.
      pdfesdump(1,2)
      pddicdump(1,2)
      pdbesdump(1,2)
      YYYThis is output in a HiRDB/Parallel Server.
      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.