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

HiRDB administrator

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

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

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[Figure]<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[Figure]<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.

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] ...][Figure]<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

  1. The pdstend command can be executed only while HiRDB is active.
  2. The pdstend command must be executed at the server machine containing the single server or the server machine where the system manager is located.
  3. When statistical information is being output, the output continues until HiRDB is shut down unless the pdstend command is executed.

Note

  1. The following shows the pdstend command's return codes:
    0: Normal termination
    8: Abnormal termination (such as an invalid option or rsh error)
  2. 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.
  3. If you stop acquisition of a server's sys (statistical information about system activities), acquisition of the unit's sys also stops.
  4. SQL statement statistical information is not output if the output of SQL statistical information is specified.
  5. 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.
  6. 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 typeServer statusTarget
    Host BESExecutingY
    StandbyN
    Guest BESExecutingY
    Acceptable statusN
    Legend:
    Y: Can be executed
    N: Cannot be executed
  7. 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.