pdstbegin (Start output of statistical information)
Function
The pdstbegin command outputs to the statistics log file statistical information about a unit located at the server machine with a specified host name. When output of statistical information is to be stopped, the pdstend command must be executed.
The statistical information is output to the statistics log file named pdstj1 or pdstj2 at each host.
The obtained statistical information can be read by the statistics analysis utility. For details about the statistics analysis utility, see Chapter 14. Statistics Analysis Utility (pdstedit).
Executor
Format
- HiRDB/Single Server
pdstbegin [-k statistical-information-type[,statistical-information-type]...]
[-m interval] [-a|-s server-name[,server-name]...}]
- HiRDB/Parallel Server
pdstbegin [-k statistical-information-type[,statistical-information-type]...]
[-m interval] [{-x host-name|-u unit-identifier}]
[{-a|-s server-name[,server-name]...}]
Options
- -k statistical-information-type
<<sys>>
Specifies the type of statistical information to be output:
- 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
- -m interval
<unsigned integer> ((1-1440)) <<10>>
When system activity statistical information (-k sys specified) is to be output to the statistics log file, specifies in minutes the interval at which the information is to be output.
- {-x host-name|-u unit-identifier}
Specifies the identifier of the unit or the name of the host for which statistical information is to be output. If this option is omitted, statistical information for the entire HiRDB system is output to the statistics log file.
- -x host-name
<identifier> ((1-32)) - Specifies the name of the host for 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 starts 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 identifier of the unit for 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 starts 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 servers for which statistical information is to be output. When this option is omitted, the statistical information to be output depends on the server type, as shown in Tables 2-20 and 2-21.
- -a
- Specifies that statistical information about the entire system and all servers is to be output.
- This option and the -s option are mutually exclusive.
- -s server-name[, server-name]
<identifier> ((1-8)) - Specifies the name of a server for which statistical information is to be output.
- 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 starts output of statistical information about both servers, whether the normal BES or the alternate BES is specified.
Rules
Notes
- The following are the pdstbegin command's return codes:
0: Normal termination
8: Abnormal termination (such as an invalid option or rsh error)
- The pdstbegin command can also be executed using pdststart as the command name.
- If none of the servers in the unit has started, statistical information about the unit is not acquired.
- When acquisition of a server's sys (statistical information about system activities) is started, acquisition of the unit's sys also begins.
- When HiRDB is terminated and then restarted, the statistical information output operation is not inherited. To output statistical information after HiRDB has started, you must re-execute the pdstbegin command.
- Once a server is terminated, the statistical information output operation is not inherited when the server is started normally. To output statistical information for a server that was terminated, the pdstbegin command must be re-executed after the server has been started normally.
- Execute the pdls -d stj command to determine whether statistical information is being output.
- UAP-related statistical information is output only for UAPs that executed between the time the pdstbegin command was entered and the time the pdstend command was entered. For UAPs executing in the OLTP environment, UAP-related statistical information is output only for transactions that executed between the time the pdstbegin command was entered and the time the pdstend command was entered.
- SQL-related statistical information is output only for SQLs that executed between the time the pdstbegin command was entered and the time the pdstend command was entered.
- UAP-related statistical information and SQL-related statistical information may not be in agreement, depending on the timing of the pdstbegin command and pdstend command entry, as shown in Figure 2-11.
Figure 2-11 Relationship between output statistical information and entry of pdstbegin and pdstend commands
![[Figure]](figure/zu020050.gif)
- Following are the times at which the different types of statistical information are output:
- sys
- Output at the time interval specified in the -m option
- uap
- Output when connected to HiRDB and when disconnected from HiRDB
- sql
- Output when SQL execution starts and when SQL execution terminates
- sqh
- Output information during PREPARE and during execution of an embedded data-type SQL statement.
- buf, fil, dfw, idx
- Output at synchronization points
- sop
- Output when the specified SQL object was not found in the SQL object buffer during dynamic and static SQL preprocessing
- dop
- Output when an SQL statement other than FETCH or CLOSE was executed
- pcd
- Output when an SQL object is executed
- obj
- Output when an SQL object execution request is issued at the dictionary server and back-end server.
- fsv
- Output when the transaction has terminated.
- hba
- Output when an SQL statement is executed on an external server.
- The statistical information listed below is collected at synchronization points, and the information that exists between synchronization points is edited. Therefore, this statistical information is not collected unless there are at least two synchronization points:
- Global buffer pool statistical information
- Statistical information on HiRDB files for database manipulation
- Deferred write processing statistical information
- Index statistical information
To collect this statistical information, synchronization points must be created by executing the pdlogswap command immediately after the pdstbegin command and immediately before the pdstend command.
- SQL statement statistical information is output when 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 the pdstbegin command but before execution of the pdstend command, the same statistical information is output after the restart as before the restart. If system switchover occurs after execution of the pdstbegin command but before execution of the pdstend command (as in the case of a server that was being used as the running system on the erroneous unit), the same statistical information is output after the switchover at the target accepting unit as before the switchover. To stop output of statistical information, you must execute the pdstend command.
- When the standby-less system switchover (effects distributed) facility is used and the -x or -u option is specified, the target of the pdstbegin 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 begins if the back-end server specified in the -s option on the unit specified in the -x or -u option is running when the pdstbegin command is executed.