pdstend (Stop output of statistical information)
Function
The pdstend command stops the output of specified statistical information on a unit on the server machine specified in the host name (or unit identifier). If the pdstend command is not executed, the system will continue to output statistical information until the HiRDB system stops.
Executor
Format
- HiRDB/Single Server
pdstend [-k statistical-information-type[,statistical-information-type]...]
[-a|-s server-name[server-name]...]
- HiRDB/Parallel Server
pdstend [-k statistical-information-type[,statistical-information-type]...]
[{-x host-name|-u unit-identifier}]
[-a|-s server-name[server-name]...]
Options
- -k statistical-information-type
Specifies the type of statistical information to be output. The default is to stop the output of all statistical information.
- sys
- System activity statistical information
- uap
- UAP statistical information
- sql
- SQL statistical information
- sqh
- SQL statement statistical information (statistical information about issued data manipulation SQL, definition SQL, and the LOCK statement and SQL)
- This statistical information is output when the output of SQL statistical information is specified.
- 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
- Statistics on SQL object transmission (applicable to HiRDB/Parallel Server only)
- fsv
- Statistical information about the activities of external servers
- hba
- Statistical information about the utilization status of external servers
- all
- All statistical information except sqh, pcd, obj, fsv, and hba
- {-x host-name| -u unit-identifier}
Specifies the host name of the host or the unit identifier of the unit on which statistical information is to be output. The default is to stop the output of statistical information on the entire HiRDB system.
- -x host-name
<identifier> ((1-32)) - Specifies the host name of the host on which statistical information is to be output. If the standby-less system switchover (1:1) facility is used and the alternate system is in use, the command stops output of statistical information about both hosts, whether the specified host name belongs to the normal BES or to the alternate BES.
- -u unit-identifier
<identifier> ((4 characters)) - Specifies the unit identifier of the unit on which statistical information is to be output. If the standby-less system switchover (1:1) facility is used and the alternate system is in use, the command stops output of statistical information about both units, whether the specified unit identifier belongs to the normal BES or to the alternate BES.
- {-a|-s [server-name [, server-name] ...]}
<<-a>>
Specifies the server on which the output of statistical information is to be stopped. The default is the option -a.
- -a
- Stops the output of statistical information for system services and all servers. This option and the -s option are mutually exclusive.
- -s [server-name [, server-name] ...]
<identifier> ((1-8)) - Specifies the name of the server for which the output of statistical information is to be stopped. This option and the -a option are mutually exclusive. If the standby-less system switchover (1:1) facility is used and the alternate system is in use, the command stops output of statistical information about both servers, whether the normal BES or the alternate BES is specified.
Rules
- The pdstend command can be executed only while HiRDB is active.
- The pdstend command must be executed at the server machine containing the single server or the server machine where the system manager is located.
- When statistical information is being output, the output continues until HiRDB is shut down unless the pdstend command is executed.
Note
- The following shows the pdstend command's return codes:
0: Normal termination
8: Abnormal termination (such as an invalid option or rsh error)
- Executing the pdstend command causes statistics log buffer information to be output to the statistics log file. To acquire the most recent statistical information, you must execute the pdstjsync command before you execute the pdstend command.
- If you stop acquisition of a server's sys (statistical information about system activities), acquisition of the unit's sys also stops.
- SQL statement statistical information is not output if the output of SQL statistical information is specified.
- When the standby-less system switchover (effects distributed) facility is used, if restart occurs after execution of pdstend, no statistical information is output after the restart. If system switchover occurs after execution of pdstend, no statistical information is output at the target accepting unit for the server that was being used as the running system on the erroneous unit. To restart output of statistical information, you must execute the pdstbegin command.
- When the standby-less system switchover (effects distributed) facility is used and the -x or -u option is specified, the target of the pdstend command execution is different before and after system switchover, as shown below:
Server type | Server status | Target |
---|
Host BES | Executing | Y |
Standby | N |
Guest BES | Executing | Y |
Acceptable status | N |
- Legend:
- Y: Can be executed
- N: Cannot be executed
- You should note the following when the standby-less system switchover (effects distributed) facility is used and the -x or -u option is specified together with the -s option:
- Acquisition of statistical information stops if the back-end server specified in the -s option on the unit specified in the -x or -u option is running when the pdstend command is executed.