Nonstop Database, HiRDB Version 9 Command Reference

[Contents][Index][Back][Next]

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 name Output file or output directory File output destination Whether deleted automatically
pdaudput pdaudput 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
pdcancel core file
  1. Under $PDDIR/spool/save
 N
deb file
  1. Under $PDDIR/spool/save
 N
pdconstck Process 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
pdcopy Backup 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
pddbst CSV 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
pddefrev Definition 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
pddivinfgt Partitioning information file
  1. Location specified in the -f option
 N
pdexp Export file
  1. Location specified in the -e or -i option
 N
Definition SQL output file
  1. Location specified in the -o option
 N
pdgetcst Output result file
  1. Location specified in the -l option
 N
Optimization information parameter file
  1. Location specified in the -e option
 N
pdgeter Output 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
pdinfoget Initial 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
pditvtrc Output 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
pdjarsync JAR file
  1. Location specified in the pd_java_archive_directory operand
  2. Under $PDDIR/java
 N
pdload LOB 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
pdlogunld Unload log file
  1. Location specified in the -o option
  2. Standard output
 N
pdorend Skip 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
pdparaload pdload 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 pdload Same as the file output by the pdload command. For details, see the items for pdload. --
pdpgbfon User troubleshooting information file#
  1. Under /tmp and $PDDIR/spool/save
 N
pdrbal Process 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
pdreclaim User troubleshooting information file#
  1. Under /tmp and $PDDIR/spool/save
 N
pdrorg Unload 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
pdrstr 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
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
pdstbegin Statistics log file
  1. Under $PDDIR/spool
 N
pdstedit DAT 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
pdstop Shared 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
pdtrndec Shell 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.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.