2.3.40 Operands related to statistical information

181) pdstbegin
[Figure]Operand specification format in a HiRDB/Single Server
pdstbegin [-k statistical-information-type[,statistical-information-type]...]
[-m interval]
[Figure]Operand specification format in a 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]...}]
This operand is specified in order to begin collecting statistical information at the time HiRDB is started. The pdstend command is entered in order to stop collection of statistical information. The statistical information is output to the statistics log file.
-k statistical-information-type[,statistical-information-type]...
[Figure]<<sys>>
Specifies the type of statistical information that is to be output. The pdls -d sty command can be used to check the types of statistical information specified for output.
Statistical information type (-k option specification)Type of statistical information outputStatistical information output trigger
sysStatistical information on system operationStatistical information is output at the interval specified in the -m option.
uapStatistical information on UAPsStatistical information is output during connection to and disconnection from HiRDB.
sqlStatistical information on SQLsStatistical information is output when SQL execution starts and ends.
bufStatistical information on global buffers1Statistical information is output at synchronization points.
filStatistical information on HiRDB files related to database manipulations
dfwStatistical information on deferred write processing
idxStatistical information on indexes
sopStatistical information on SQL static optimizationStatistical information is output when no hit occurs on an SQL object buffer during preprocessing of a dynamic SQL or static SQL.
dopStatistical information on SQL dynamic optimizationStatistical information is output when an SQL statement other than FETCH or CLOSE is executed.
pcdStatistical information related to SQL object executionStatistical information is output when an SQL object is executed.
sqhStatistical information on SQL statement statistics2Statistical information is output during PREPARE and when an embedded SQL is executed.
objStatistical information on SQL object transmission3Statistical information is output when an SQL object is executed.
fsvStatistical information on foreign server option3Statistical information is output when a transaction is terminated.
hbaStatistical information on foreign server usage3Statistical information is output when an SQL statement is executed for a foreign server.
1 This statistical information is collected at synchronization points, and the information between synchronization points is edited. Consequently, statistical information cannot be collected unless at least two synchronization points occur. To reliably collect this statistical information, a synchronization point must be triggered by executing the pdlogswap or pdlogsync command immediately before executing the pdstend command.
2 The statistical information on SQL statement statistics is output when the statistical information on SQLs (sql specification) is being output.
3 This statistical information is only for a HiRDB/Parallel Server, and is not output for a HiRDB/Single Server.
-m interval
[Figure]<unsigned integer> ((1-1440)) <<10>>
This option is specified when statistical information on system operation (sys specified) is to be collected.
Specifies in minutes the interval at which the statistical information on system operation is to be output to the statistics log file.
-x host-name
[Figure]<host name> ((1-32 characters))
For a HiRDB/Parallel Server, specifies a host name specified in the -x option of the pdunit operand in order to select the units for which statistical information is to be output. Specify the host name of the unit for which statistical information is to be output.
If the standby-less system switchover (effects distributed) facility is being applied to this unit, the statistical information on the guest back-end server being accepted is also output.
-u unit-identifier
[Figure]<identifier> ((4 characters))
In the case of a HiRDB/Parallel Server, specifies the unit name of a unit for which statistical information is to be output. This option is specified when it is necessary to limit the units for which statistical information is to be output.
If the standby-less system switchover (effects distributed) facility is being applied to the unit on this host, the statistical information on the guest back-end server being accepted is also output.
-a
In the case of a HiRDB/Parallel Server, specifies that statistical information is to be output for all servers. This option is specified when it is not necessary to limit the units for which statistical information is to be output.
-s server-name[,server-name]...
[Figure]<identifier> ((1-8 characters))
In the case of a HiRDB/Parallel Server, specifies the server names of the servers for which statistical information is to be output. This option is specified when it is necessary to limit the servers for which statistical information is to be output. Some types of statistical information are not output for all server types, as indicated in the following table:
Statistical information type (-k option specification)Server type
FESDSBES
sysYYY
uapY[Figure][Figure]
sqlY[Figure][Figure]
buf[Figure]YY
fil[Figure]YY
dfw[Figure]YY
idx[Figure]YY
sopY[Figure][Figure]
dopY[Figure][Figure]
pcdYYY
sqhY[Figure][Figure]
obj[Figure]YY
fsv[Figure][Figure]Y
hba[Figure][Figure]Y
Y: Statistical information is output.
[Figure]: Statistical information is not output.
Relationship to other operands
When this operand is specified, specification of the pd_statistics operand is ignored.
Notes
  • The pdstbegin operand can be specified only once. If it is specified more than once, the first time it is specified is valid and the subsequent specifications are ignored.
  • When the pdstbegin operand is specified, the specified statistical information is output until HiRDB is terminated or until the pdstend command is entered.
  • If you use the standby-less system switchover (1:1) facility, the specification for this operand is invalid when the system is being switched to an alternate BES unit.
  • Note the following if you use the standby-less system switchover (effects distributed) facility: During a normal HiRDB startup, each server follows the value specified for this operand. During a HiRDB restart (including a system switchover), the value specified for this operand is invalid. During a restart, the previous statistical information collection state is inherited. During a system switchover, the statistical information prior to the switchover is inherited.
  • If no server has started in the unit, unit statistical information is not acquired.
  • Depending on when the pdstbegin and pdstend commands are entered, the statistical information on UAPs may not match the statistical information on SQLs. The relationship between when the pdstbegin and pdstend commands are entered and the statistical information that is output is shown as follows:

    [Figure]

  • If the HiRDB system, unit, or server is terminated (including abnormal termination) and is then started again, the statistical information collection state may not be inherited. The following table shows whether the statistical information collection state is inherited when the HiRDB system, unit, or server is started.
    Start modeStatistical information collection environmentStart condition
    HiRDB
    start
    Unit startServer start
    Standby-less system switchover (effects distributed) facility is not usedStandby-less system switchover (effects distributed) facility is used
    Normal startStatistical information is being collected with the pdstbegin operand specified.YYN*Y
    Statistical information is being collected by executing the pdstbegin command.N*N*N*N*
    RestartStatistical information is being collected with the pdstbegin operand specified.YY[Figure]I
    Statistical information is being collected by executing the pdstbegin command.N*N*[Figure]Y
Y: Statistical information collection state is inherited.
I: Statistical information collection state is inherited. When the pdstbegin command is executed, the collection state of the statistical information specified by this command is inherited.
N: Statistical information collection state is not inherited.
[Figure]: Not applicable.
* To collect statistical information, you must execute the pdstbegin command after starting the HiRDB system.
182) pdhibegin -k statistics-type[,statistics-type]...
Specifies the types of statistical information to be collected beginning at the time of HiRDB startup. When this operand is specified, statistical information is output continuously to the system log file until HiRDB is terminated.
-k statistics-type
Specifies the type of statistical information to be output:
cnc: Statistical information related to CONNECT/DISCONNECT.
In the case of a HiRDB/Parallel Server, the output destination file is the system log file at a front-end server.