pdstbegin [-k statistical-information-type[,statistical-information-type]...]
[-m output-interval-of-system-operation-statistical-information]
[-I output-interval-of-database-I/O-statistical-information]
[-D database-I/O-statistical-information-option
[,database-I/O-statistical-information-option]]
[-w]
pdstbegin [-k statistical-information-type[,statistical-information-type]...]
[-m output-interval-of-system-operation-statistical-information]
[-I output-interval-of-database-I/O-statistical-information]
[-D database-I/O-statistical-information-option
[,database-I/O-statistical-information-option]]
[{-x host-name | -u unit-identifier}]
[{-a | -s server-name[,server-name]...}]
[-w]
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#1 | 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#2 | Statistical information is output during PREPARE and when an embedded SQL is executed. |
obj | Statistical information on SQL object transmission#3 | Statistical information is output when an SQL object is executed. |
dio | Statistical information on database I/O | Information about database I/O is output at the interval (seconds) specified in the -I option. |
Table 2-6 Table Frequency of measuring I/O times
Specified value | Action | Advantage | Disadvantage |
---|---|---|---|
Not specified | For I/O that occurred on each HiRDB file comprising an RDAREA, 100 I/O times are measured per second, in the order that the input or output occurred. | The impact on the performance can be minimized. | For the 101th and subsequent I/O instance that occurred in a second on each HiRDB file comprising an RDAREA the I/O times are not measured. |
everyio | For I/O that occurred on HiRDB files comprising RDAREAs, all the I/O times are measured. | Information about all (no exception) I/O can be collected. | The transaction performance deteriorates due to the overhead of measuring I/O times. |
Table 2-7 Table Amount of statistical information to be output
Specified value | Action | Advantage | Disadvantage |
---|---|---|---|
Not specified |
| Because the size of statistics logs per output trigger is fixed, the amount of used disk space and the impact on performance due to the frequent occurrence of statistics log buffer swapping are small. | Because information about only the top 10 files for each unit is output, the information about all I/O for HiRDB files comprising an RDAREA cannot be collected. |
everyfile | The information about all I/O for HiRDB files comprising RDAREAs that were accessed within the output interval are output. | The information about all I/O for HiRDB files comprising an RDAREA can be obtained. | Because the size of statistics logs per output trigger is not fixed, a large amount of disk space will be used and the frequent occurrence of statistics log buffer swapping will have a large impact on performance. |
Statistical information type (-k option specification) | Server type | ||
---|---|---|---|
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 |
dio | -- | Y | Y |
Start mode | Statistical information collection environment | Start condition | |||
---|---|---|---|---|---|
HiRDB start | Unit start (start of single unit) | Server start (start of single server) | |||
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 by specifying the pdstbegin or pd_statistics operand. | Y | Y | N# | Y |
Statistical information is being collected by executing the pdstbegin command. | N# | N# | N# | N# | |
Restart | Statistical information is being collected by specifying the pdstbegin or pd_statistics operand. | Y | Y | -- | I |
Statistical information is being collected by executing the pdstbegin command. | N# | N# | -- | Y |