Operands related to statistical information

Operand specification format in a HiRDB/Single Server: pdstbegin [-k statistical-information-type[,statistical-information-type]...]; [-m interval]; [-w]

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]...}]; [-w]

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

~<<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 output	Statistical information output trigger
sys	Statistical information on system operation	Statistical information is output at the interval specified in the -m option.
uap	Statistical information on UAPs	Statistical information is output during connection to and disconnection from HiRDB.
sql	Statistical information on SQLs	Statistical information is output when SQL execution starts and ends.
buf	Statistical information on global buffers^#¹	Statistical information is output at synchronization points.
fil	Statistical information on HiRDB files related to database manipulations
dfw	Statistical information on deferred write processing
idx	Statistical information on indexes
sop	Statistical information on SQL static optimization	Statistical information is output when no hit occurs on an SQL object buffer during preprocessing of a dynamic SQL or static SQL.
dop	Statistical information on SQL dynamic optimization	Statistical information is output when an SQL statement other than FETCH or CLOSE is executed.
pcd	Statistical information related to SQL object execution	Statistical information is output when an SQL object is executed.
sqh	Statistical information on SQL statement statistics^#²	Statistical information is output during PREPARE and when an embedded SQL is executed.
obj	Statistical information on SQL object transmission^#³	Statistical information is output when an SQL object is executed.

#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: ~<unsigned integer> ((1-1440)) <<10>>(minutes); 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: ~<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: ~<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]...

~<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
Statistical information type (-k option specification)	FES	DS	BES
sys	Y	Y	Y
uap	Y	--	--
sql	Y	--	--
buf	--	Y	Y
fil	--	Y	Y
dfw	--	Y	Y
idx	--	Y	Y
sop	Y	--	--
dop	Y	--	--
pcd	Y	Y	Y
sqh	Y	--	--
obj	--	Y	Y

Y: Statistical information is output.

--: Statistical information is not output.

-w: Specifies that statistical information about the thread-to-thread lock-release wait time is to be output. This option is enabled when statistical information about system activities is output. Therefore, statistical information about the thread-to-thread lock-release wait time can be acquired if the -k option is omitted or the specified -k option contains sys.; This option might affect the performance of the entire system; therefore, we recommend that you normally do not specify this option.

Specification guideline: If you use the system switchover facility, we recommend that you specify this operand to collect thorough statistical information.

Relationship to other operands

This operand is related to pd_stj_file_size.
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 might 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:

If the HiRDB system, unit, or server is terminated (including abnormal termination) and is then started again, the statistical information collection state might 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 mode	Statistical information collection environment	Start condition
		HiRDB start	Unit start	Server start
		HiRDB start	Unit start	Standby-less system switchover (effects distributed) facility is not used	Standby-less system switchover (effects distributed) facility is used
Normal start	Statistical information is being collected with the pdstbegin operand specified.	Y	Y	N^#	Y
Normal start	Statistical information is being collected by executing the pdstbegin command.	N^#	N^#	N^#	N^#
Restart	Statistical information is being collected with the pdstbegin operand specified.	Y	Y	--	I
Restart	Statistical information is being collected by executing the pdstbegin command.	N^#	N^#	--	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.

--: Not applicable.

#: To collect statistical information, you must execute the pdstbegin command after starting the HiRDB system.

241) 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.

2.2.48 Operands related to statistical information