<<sys>>
Specifies the information that is to be edited.
If you specify sop, dop, pcd, obj, sqh, cnc, fsv, or hba, make sure that the -o option is also specified (otherwise, an error results).
When sop, dop, pcd, obj, sqh, cnc, fsv, or hba is specified, 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
all: All the above (if sop, dop, pcd, obj, sqh, cnc, fsv, or hba 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.
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]]:
Specifies the names of UAPs that are to be subject to information editing (ID name of a UAP as specified in PDCLTAPNAME in the client environment definition) when the editing is to be of UAP or SQL statistical information, foreign server operation statistical information, or foreign server utilization statistical information.
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, all hosts become subject to information editing.
<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.
<identifier> ((1-30))
Specifies the names of foreign servers in order to edit statistical information about their operation (foreign server operation statistical information) or utilization (foreign server utilization statistical information).
You can specify a maximum of 32 foreign server names. When this option is omitted, all foreign servers are subject to editing of statistical information.
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, /tmp or /usr/tmp is assumed. An error results if work files cannot be created in /tmp or /usr/tmp for some reason.
The statistics analysis utility calls a sort program internally. In this case as well, the sort program creates temporary work files in /tmp or /usr/tmp. You can use the TMPDIR environment variable to change the directory where the temporary work files are created.
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 |
fsv | PID.fsi, PID.fso |
hba | PID.hbi, PID.hbo |
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.