~<<sys>>
Specifies the information that is to be edited.
If you specify sop, dop, pcd, obj, sqh, cnc, or dio, make sure you also specify the -o option (otherwise, an error results).
If you specify sop, dop, pcd, obj, sqh, cnc, or dio, the utility outputs statistical information to a DAT-format file, but it does not edit the statistical information. If you specify all and omit the -o option, the utility continues processing without detecting an error.
sys: System activity statistical information
svr: System activity statistical information by server
uap: UAP statistical information
sql: SQL statistical information
buf: Global buffer pool statistical information
fil: Statistical information on HiRDB files for database manipulation
dfw: Deferred write processing statistical information
idx: Index statistical information
sop: SQL static optimization information
dop: SQL dynamic optimization information
pcd: SQL object execution information
obj: SQL object transfer statistical information
sqh: SQL statement statistical information
cnc: CONNECT/DISCONNECT statistical information
dio: Statistical information about database I/O operations
all: All of the above (If sop, dop, pcd, obj, sqh, cnc, or dio is specified, the statistical information is output to a DAT-format file only.)
Specifies in minutes the interval at which totaled values are to be output for the selected types of statistical information. Totaled values for each selected type of statistical information are output at this interval.
This option takes effect when the edited statistical information is output to the standard output. This option is ignored when the edited statistical information is output to a DAT-format file.
Specifies a log record output start time and end time as the period for which statistical information is to be output. The permitted value range for both the start time and the end time is from 00:00:00 on January 1, 1970, to the current time on the current date.
When this option is omitted, all statistical information in the input statistics unload files and system log files is edited.
When the start time is omitted, editing is from the beginning of the input statistics unload files or system log files to the specified end time. When the end time is omitted, editing is from the specified start time to the end of the statistics input unload files or system log files.
When the option flag is specified, a start time or an end time (or both) must be specified. A time is specified in the format hhmmss[MMDD[YYYY]]:
When UAP-related or SQL-related statistical information is to be edited, specifies the names of that UAPs that are to be subject to information editing (the UAPs' ID names as specified in PDCLTAPNAME in the client environment definition are specified).
A maximum of 16 UAP names can be specified. When this option is omitted, the utility edits UAP or SQL statistical information according to the range specified with the -t option.
~<identifier> ((1-32))
Specifies the names of the hosts that are to be subject to information editing. A maximum of 32 host names can be specified. When this option is omitted, the standard host names are set and all hosts become subject to information editing. If a host name specified in the -x option of the pdunit operand is changed, the host names before and after the change are both subject to information editing. In such a case, statistical information is output for the host name before the change separately from the statistical information for the host name after the change.
~<identifier> ((1-8))
Specifies the names of the servers that are to be subject to information editing. A maximum of 32 server names can be specified. When this option is omitted, all servers become subject to information editing.
Specifies the input statistics unload files that are to be used as the input information for statistical analysis.
The host executing pdstedit must be able to reference the specified input statistics unload files. An input statistics unload file means an unload statistics log file or an unload log file.
When this option is omitted, the utility assumes the standard input.
Entity specified by -i option | File type | Analysis processing | |
---|---|---|---|
File | Regular file | Processing continues. | |
RAW file | Processing continues. | ||
Pipe file (FIFO)# | Analysis processing is placed on hold until the specified file is opened in write mode by another process. | ||
Other | Analysis processing on the specified file is skipped. | ||
Directory | File under the directory | Regular file | Processing continues. |
RAW file | Processing continues. | ||
Pipe file (FIFO) | Warning message is output. | ||
Other | Analysis processing on the specified file is skipped. |
#: You can specify a pipe file (FIFO) when there is only one statistics log file.
When you use the pdlogunld command to unload a system log file, specify the -n option (to prevent the system log status from being changed). If the system log status changes, the system log file may not be unloaded for the following reasons:
It is difficult to collect unload log files in HiRDB file system areas in character special files at a single location because they cannot be transferred to another host by a method such as rcp. In such a case, use the following method to transfer unload log files to another host:
When multiple files are to be analyzed by pdstedit, all the files subject to analysis are placed in a single directory and that directory is specified. However, if an unload log file is located in a HiRDB file system area in a character special file, it is difficult to input it together with other files because it cannot be copied by a command such as cp.
In such a case, by symbolically linking the directory containing the files to be analyzed to the HiRDB file system area in the character special file that contains the unload log files to be analyzed, you can analyze all the files without having to copy the latter.
~<pathname> ((1-128))
When a DAT-format file is to be created by collecting statistical information from an input statistics unload file, specifies the name of the directory under which the DAT-format file is to be created.
~<pathname> ((1-128))
Specifies the name of the directory under which work files are to be created for the statistics analysis utility. When this option is omitted, the directory shown in the table below is assumed.
Table 14-2 Directory to which pdstedit outputs files
-w option | pd_tmp_directory operand in the system definition | ||
---|---|---|---|
Specified | Omitted | ||
TMPDIR environment variable# | |||
Specified | Omitted | ||
Specified | Directory specified in the -w option | ||
Omitted | Directory specified in pd_tmp_directory | Directory specified in TMPDIR | /tmp directory |
An error results if work files cannot be created in the directory shown in Table 14-2 Directory to which pdstedit outputs files.
If the statistics analysis utility is cancelled during execution, such as by forced or abnormal termination of the process, the temporary work files may remain in the directory. If such temporary work files are not needed, the user should delete them. The following files are created in the directory for temporary work files:
-k option value | Names of files that are created |
---|---|
sys | PID.syi, PID.syo |
uap | PID.uai, PID.uao |
sql | PID.sqi, PID.sqo |
buf | PID.bui, PID.buo |
fil | PID.fii, PID.fio |
dfw | PID.dfi, PID.dfo |
idx | PID.ixi, PID.ixo, PID.isi, PID.iso |
sop | PID.soi, PID.soo |
dop | PID.doi, PID.doo |
pcd | PID.pci, PID.pco |
obj | PID.obi, PID.obo |
sqh | PID.qhi, PID.qho |
cnc | PID.cni, PID.cno |
dio | PID.dii, PID.dio |
Specifies the name of the control statements file in which are specified the names of the file groups that store the system log information that is to be input to the statistics analysis utility.
When the -i option is not specified, the status changes to the standard input standby status even if the -d option is specified.
Following is the format of the control statements file (file_group statements); a maximum of 32 control statements can be specified in this file:
file_group server-name:file-group-name[,file-group-name]... |
Specifies that a title bar is to be output to the DAT-format file. Specification of this option is ignored if the -o option is not specified.
Specifies that the output format is to be changed when a DAT-format file is output. When this option is specified, the -o option must also be specified.
You can specify sec or er1 as an extended format specification value.
Specifies that the date and time are to be output in the format YYYY/MM/DD hh:mm:ss when DAT-format files are output. If the -o option is not specified, this option is ignored. If this option is specified, -e sec is ignored.