2.110 pdstend (Stop output of statistical information)

Organization of this section
(1) Function
(2) Executor
(3) Format
(4) Options
(5) Rules
(6) Notes

(1) 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.

(2) Executor

HiRDB administrator

(3) Format

(a) HiRDB single server configuration

pdstend [-k statistical-information-type[,statistical-information-type]...]
        [-a|-s server-name[server-name]...]
        [-w]

(b) HiRDB parallel server configuration

pdstend [-k statistical-information-type[,statistical-information-type]...]
        [{-x host-name|-u unit-identifier}]
        [-a|-s server-name[server-name]...]
        [-w]

(4) Options

(a) -k statistical-information-type

Specifies the type of statistical information whose output is to be stopped. When this option is omitted, output of all statistical information is terminated. However, if the -w option is specified, only collection of statistical information on the thread-to-thread lock-release wait time is stopped.

sys
System activity statistical information
If thread-to-thread lock-release wait time is collected, collection of statistical information on the thread-to-thread lock-release wait time is also stopped.
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 a HiRDB parallel server configuration only)
dio
Statistical information about database I/O operations
all
All statistical information except sqh, pcd, and obj
(b) {-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.
(c) {-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
Specifies that output of statistical information is to be stopped in the HiRDB system and on all servers. This option cannot be specified together with the -s option.
-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.
(d) -w

Specifies that collection of thread-to-thread lock-release wait time is to be stopped. If the -k option is omitted and the -w option is specified, collection of statistical information on the thread-to-thread lock-release wait time is stopped, but collection of the system activity statistical information continues. If sys or all is specified in the -k option or the -k option is omitted, collection of the system activity statistical information and collection of statistical information on the thread-to-thread lock-release wait time are both stopped regardless of whether the -w option was specified.

Execute the pdls -d stj command to check the collection status of the statistical information on the thread-to-thread lock-release wait time. For details about the period for which system activity statistical information and statistical information on the thread-to-thread lock-release wait time can be collected, see (4) Options under 2.109 pdstbegin (Start output of statistical information).

To collect more accurate information, execute the pdstjsync command immediately before or after you execute this command. For details, see 2.112 pdstjsync (Apply statistics log buffer to statistics log file).

(5) 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.
  4. If you want to stop collecting statistical information before you stop collecting statistical information on the thread-to-thread lock-release wait time, stop the collection of statistical information on the thread-to-thread lock-release wait time when you stop collection of statistical information.
  5. Collection of statistical information on the thread-to-thread lock-release wait time is stopped for all servers in the following cases:
    • The -a option was specified.
    • The -s and -a options were omitted and the -w option was specified.

(6) Notes

  1. The following shows the pdstend command's return codes:
    0: Normal termination
    4: At least one unit terminated normally.
    8: Abnormal termination (such as an invalid option or rsh error)
  2. If you stop acquisition of a server's sys (statistical information about system activities), acquisition of the unit's sys also stops.
  3. SQL statement statistical information is not output if the output of SQL statistical information is specified.
  4. 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.
  5. 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. The KFPS01882-E message is displayed.
  6. 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.
    • If the back-end server specified in the -s option is not running on the unit specified in the -x or -u option, the command displays the KFPS01882-E message and then terminates with an error.
      Use the pdls -d svr command to determine the unit on which the back-end server is running, and then re-execute the pdstend command.