Appendix I. List of Files Output by Commands

The table below lists the files that are output by the HiRDB commands.

When there are multiple file output destinations, the destination is determined according to the priority, where 1 in the table below is the highest priority.

Table I-1 List of files output by the HiRDB commands

Command nameOutput file or output directoryFile output destinationWhether deleted automatically
pdaudputpdaudput management file
  1. Location specified in the -d option
  2. Under $PDDIR/auditlog
N
Audit log output file for JP1/NETM/Audit
  1. Location specified in the -d option
  2. Under $PDDIR/auditlog
N
pdcancelcore file
  1. Under $PDDIR/spool/save
N
deb file
  1. Under $PDDIR/spool/save
N
pdconstckProcess results file
  1. Location specified in the -o option
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
N
pdcopyBackup file
  1. Location specified in the -b option
N
Process results output file
  1. Location specified in the -p option
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
N
Log point information file
  1. Location specified in the -z option
N
History file for differential backups
  1. Location specified in the -o option
N
pddbstCSV output file for facility for predicting reorganization time
  1. Location specified in the predict file operand in the predict statement
N
Directory for work files
  1. Location specified in the workdir statement
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
N
pddefrevDefinition SQL output file
  1. Location specified in the -o option
N
Work directory for exporting dictionary
  1. Location specified in the -w option
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
Y
pddivinfgtPartitioning information file
  1. Location specified in the -f option
N
pdexpExport file
  1. Location specified in the -e or -i option
N
Definition SQL output file
  1. Location specified in the -o option
N
pdgetcstOutput result file
  1. Location specified in the -l option
N
Optimization information parameter file
  1. Location specified in the -e option
N
pdgeterOutput destination directory
  1. Location specified in the -o option
  2. $PDDIR/erinf/outinf
Y
Work directory
  1. Location specified in the -w option
  2. $PDDIR/erinf/work
Y
pdinfogetInitial information file output destination directory
  1. Location specified in the -e option
Y
Detail information file output destination directory
  1. Location specified in the -d option
Y
Work directory
  1. Location specified in the -w option
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
Y
XDS shared memory dump file output destination directory
  1. Location specified in the -b option
N
pditvtrcOutput file
  1. Under the current directory where the command was executed
N
Directory for locking
  1. Under the current directory where the command was executed
Y
pdjarsyncJAR file
  1. Location specified in the pd_java_archive_directory operand
  2. Under $PDDIR/java
N
pdloadLOB middle file
  1. Location specified in the lobmid statement
  2. Location specified in the TMPDIR environment variable
  3. Under /tmp
N
Index information file
  1. Location specified in the index statement
  2. Location specified in the idxwork statement
  3. Location specified in the pd_tmp_directory operand
  4. Location specified in the TMPDIR environment variable
  5. Under /tmp
Y
Work file for sorting
  1. Location specified in the sort statement
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
Y
Error information file
  1. Location specified in the source statement
  2. Location specified in the TMPDIR environment variable
  3. Under /tmp
N
Temporary file for creating error information file
  1. Location specified in the pd_tmp_directory operand
  2. Location specified in the TMPDIR environment variable
  3. Under /tmp
Y
Error data file
  1. Location specified in the errdata operand in the source statement
N
Temporary file for creating error data file
  1. Location specified in the errdata operand in the source statement
Y
Processing performance information file
  1. Under $PDDIR/spool
N
User troubleshooting information file#
  1. Under /tmp and $PDDIR/spool/save
N
Work file
  1. Location specified in the pd_tmp_directory operand
  2. Location specified in the TMPDIR environment variable
  3. Under /tmp
N
pdlogunldUnload log file
  1. Location specified in the -o option
  2. Standard output
N
pdorendSkip information output file
  1. Location specified in the skip_info operand in the report statement
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
N
SQL trace information file
  1. Location specified in the sqltrc_dir operand in the report statement
N
pdparaloadpdload control statements file
  1. Location specified in the pd_tmp_directory operand
  2. Location specified in the TMPDIR environment variable
  3. Under /tmp
Y
File output by pdloadSame as the file output by the pdload command. For details, see the items for pdload.--
pdpgbfonUser troubleshooting information file#
  1. Under /tmp and $PDDIR/spool/save
N
pdrbalProcess results file
  1. Location specified in the report operand in the report statement
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
N
Index information file
  1. Location specified in the index statement
  2. Location specified in the idxwork statement
  3. Location specified in the pd_tmp_directory operand
  4. Location specified in the TMPDIR environment variable
  5. Under /tmp
Y
Work file for sorting
  1. Location specified in the sort statement
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
Y
Work file
  1. Location specified in the pd_tmp_directory operand
  2. Location specified in the TMPDIR environment variable
  3. Under /tmp
N
pdreclaimUser troubleshooting information file#
  1. Under /tmp and $PDDIR/spool/save
N
pdrorgUnload file
  1. Location specified in the unload statement
N
LOB data unload file
  1. Location specified in the lobunld statement
N
Processing performance information file
  1. Under $PDDIR/spool
N
Index information file
  1. Location specified in the index statement
  2. Location specified in the idxwork statement
  3. Location specified in the pd_tmp_directory operand
  4. Location specified in the TMPDIR environment variable
  5. Under /tmp
Y
Work file for sorting
  1. Location specified in the sort statement
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
Y
User troubleshooting information file#
  1. Under /tmp and $PDDIR/spool/save
N
Work file
  1. Location specified in the pd_tmp_directory operand
  2. Location specified in the TMPDIR environment variable
  3. Under /tmp
N
pdrstrProcess results output file
  1. Location specified in the -p option
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
N
Work directory for sorting
  1. Location specified in the -w option
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
Y
pdstbeginStatistics log file
  1. Under $PDDIR/spool
N
pdsteditDAT format file
  1. Location specified in the -o option
N
Temporary work file
  1. Location specified in the -w option
  2. Location specified in the pd_tmp_directory operand
  3. Location specified in the TMPDIR environment variable
  4. Under /tmp
Y
Work file for sorting
  1. Location specified in the TMPDIR environment variable
  2. Under /tmp
Y
pdstopShared memory dump file
  1. Under $PDDIR/spool/pdshmdump/shmdump
N
Connected user data file
  1. Under $PDDIR/spool/cnctusrinf
N
Connected user details file
  1. Under $PDDIR/spool/cnctusrdtl
N
pdtrndecShell script output destination directory
  1. Location specified in the -o option
  2. Under the current directory where the command was executed
N
Execution log output destination directory
  1. Location specified in the -o option
  2. Under the current directory where the command was executed
N
Legend:
Y: The file is deleted automatically when the command terminates.
N: The file is not deleted automatically when the command terminates (the file remains).
--: Not applicable
#
This file is output if the utility does not terminate within the utility execution monitoring interval specified in the pd_utl_exec_time operand. For details, see the description of the pd_utl_exec_time operand in the manual HiRDB Version 9 System Definition.