2.3.17 Operands related to statistical information
- 88) pd_statistics = Y | N
- Specifies whether or not collection of the statistics log is to be started at the time of HiRDB startup.
- Y:
- Begin collecting the statistics log at the time of HiRDB startup.
- N:
- Do not begin collecting the statistics log at the time of HiRDB startup.
- When Y is specified, statistics log information on the system operation of the overall unit only is collected. If information on each server or information other than the statistics information on system operation is needed, the pdstend command must be entered to stop statistical information collection after HiRDB startup has been completed, then the pdstbegin command can be entered to begin collecting statistical information again.
- When N is specified, it is still possible to collect a statistics log during HiRDB operation by entering the pdstbegin command.
- Notes
- The statistics log information cannot be acquired in the following cases:
- The pdstbegin operand is specified.
- The standby-less system switchover (1:1) facility is used and the system is switched to an alternate BES unit.
- A unit to which the standby-less system switchover (effects distributed) facility is applied
- No server has started in the unit.
- 89) pd_stj_file_size = maximum-statistics-log-file-size
<unsigned integer>((64-1000000))<<1024>>(KB)- Specifies in kilobytes the maximum size of a statistics log file.
- Two statistics log files are provided. When the amount of stored statistics log information reaches the size specified here, the statistics log files are swapped.
- Specification guidelines
- 90) pd_stj_buff_size = statistics-log-buffer-size
<unsigned integer>((32-512)) <<32>> (KB)- Specifies the statistics log buffer size.
- Specification guidelines
- The default value of 32 is appropriate when the following types of statistical information are not to be output:
- SQL object execution information
- Statistics about SQL object transmission
- If these types of statistical information are to be output, specify the value obtained by adding 32 to the result obtained from the following formula (however, if the result exceeds 512, specify 512):
- (a
1024)
(0.03
b) - a: Statistics log output volume (bytes)
- For details, see D.1 Formulas for determining size of statistics log file (pd_stj_file_size).
- b: Statistical information output time (seconds)