3.3.9 Operands related to statistical information

22) pd_stj_file_size = maximum-statistics-log-file-size
[Figure]<unsigned integer>((64-1000000)) (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
23) pd_stj_buff_size = statistics-log-buffer-size
[Figure]<unsigned integer>((32-512)) (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 [Figure] 1024) [Figure] (0.03 [Figure] 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)