Hitachi

Hitachi Advanced Database Setup and Operation Guide


7.2.7 Operands related to statistical information (set format)

[41] adb_sta_log_max_size = maximum-size-of-statistics-log-file

~<integer> ((1 to 16)) <<4>> (gigabytes#)

Specify in gigabytes the maximum size of each statistics log file. Four statistics log files are created.

Normally, there is no need to specify this operand. Specify this operand if you want to reduce the maximum size of statistics log files.

Note that the maximum size of statistics log files, as specified for this operand, takes effect when a statistics log file is switched. Therefore, even if you specify this operand, the maximum size of the statistics log files differ from the value specified for this operand until switching of a statistics log file occurs.

#

To test a swap between small statistics log files, you can use the adb_sta_log_size_unit operand to change the unit of the maximum size of statistics log files to a smaller size (MB).

[42] adb_sta_log_path = name-of-output-destination-directory-for-statistics-log-files

~<path name> ((2 to 510 bytes))

Specify an absolute path for the name of the output destination directory for statistics log files.

Statistics log files are output to the directory specified by this operand.

Normally, this operand does not need to be specified. If this operand is omitted, statistics log files are output to the $ADBDIR/spool directory.

Specify this operand if you want to output statistics log files to a directory other than the $ADBDIR/spool directory.

Note the following when specifying this operand.

  • Specify a dedicated directory in which only statistics log files are stored.

  • Specify a directory for which the HADB administrator has access privileges (read, write, and execution privileges).

  • Specify a directory on the disk where enough free space is allocated.

    If the adb_sta_log_max_size and adb_sta_log_size_unit operands are omitted, the maximum size of each statistics log file is 4 gigabytes. Four statistics log files are created. Therefore, the minimum required size is 16 gigabytes.

    Note

    You can change the maximum size for a statistics log file by using the adb_sta_log_max_size and adb_sta_log_size_unit operands in the server definition.

  • If you change the output destination directory for statistics log files, statistical information stored in the statistics log files before change can no longer be referenced. Therefore, before changing the output destination directory for statistics log files, output the statistical information by using the adbstat command.

[43] adb_sta_log_size_unit = {G|M}

Specify this to change the unit of the maximum size of statistics log files that is specified for the adb_sta_log_max_size operand.

In normal operation, omit this operand. Specify this operand if you want to change the unit of the maximum size to MB when, for example, you test a swap between statistics log files. If this operand is specified, a warning message (KFAA52201-W) is output.

  • G

    Specifying this value sets the unit of the maximum size of statistics log files to GB.

  • M

    Specifying this value sets the unit of the maximum size of statistics log files to MB.