The pdcspool command deletes the following files created by HiRDB:

• Spooled troubleshooting information (%PDDIR%\spool directory)
• Temporary work files in the temporary work file storage directory (%PDDIR%\tmp directory)
• Files under the directory specified in the pd_tmp_directory operand in the system definition

HiRDB administrator

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

(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 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.

• Temporary work files under the %PDDIR%\tmp directory

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.

dump

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

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.

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. 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 TMP 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 TMP 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 Explorer).
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:
   

   Directory		Description of output file	-k option			Remarks
   High-order directory	Low-order directory		all	dump	Omitted
   %PDDIR%\tmp (temporary work files storage directory)	--	Temporary work file	Y	Y	Y	If 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 file	Y	Y	Y
   %PDDIR%\spool (troubleshooting information)	pdsqldump	Access path information	Y	N	N	This is output when 1 or a greater value is specified in the PDVWOPTMODE client environment definition and then an SQL statement is executed.
   	pdlckinf	Deadlock/timeout information	Y	N	Y	This is output when an error occurs during lock control.
   	save	Save core file	Y	Y	Y	This is output upon abnormal termination of a process.
   	pdshmdump	Shared memory dump file	Y	Y	Y	This is output upon abnormal termination of a process or a unit.
   	pdsysdump(1,2)	Quick dump file	Y	Y	Y	None.
   	pdsdsdump(1,2)		Y	Y	Y	This is output in a HiRDB/Single Server.
   	pdfesdump(1,2) pddicdump(1,2) pdbesdump(1,2)		Y	Y	Y	This is output in a HiRDB/Parallel Server.

   Legend:

   Y: Deleted.

   N: Not deleted.

   --: Not applicable

   Note that directories and files under the directories listed below are not deleted:
   

   High-order directory	Name of directory or file that is not deleted	Description of output file
   %PDDIR%\spool (troubleshooting information)	Pipe file	All pipe files (any file name)
   %PDDIR%\tmp (temporary work files storage directory)	Pipe file	All pipe files (any file name)
   	home	Current working directory of a process where HiRDB runs
   	pdommenv	Shared memory information file
   	File whose name begins with CMb	Differential information file for the pdbufls command
   Directory specified in the pd_tmp_directory operand in the unit control information definition	Pipe file	All pipe files (any file name)
   	home	Current working directory of a process where HiRDB runs
   	pdommenv	Shared memory information file
   	File whose name begins with CMb	Differential information file for the pdbufls command