Hitachi

Hitachi Advanced Database Setup and Operation Guide


13.1.8 Expanding the initial size of user log files

This subsection explains how to improve processing performance by re-evaluating the value of the adb_log_usrfile_size operand in the server definition.

If an increase in the number of user logs causes the initial size of user log files to be exceeded, user log files are expanded automatically. Because expansion of user log files will have a significant impact on update processing performance, check whether the initial size of user log files is appropriate.

Procedure

  1. Check the maximum size of user log files.

    Check the following item in the information that was output when the adbstat command was executed:

    • Log_usrfile_max_size (maximum size of user log files)

    Note

    For details about the adbstat command, see adbstat (Perform Statistical Analysis of the HADB Server) in the manual HADB Command Reference.

  2. Re-evaluate the value specified for the adb_log_usrfile_size operand.

    If the Log_usrfile_max_size value you checked in step 1 is larger than the initial-size-of-user-log-files value specified for the adb_log_usrfile_size operand in the server definition, expansion of user log files has occurred. In such a case, increase the initial-size-of-user-log-files value specified for the adb_log_usrfile_size operand by using the value that is output to Log_usrfile_max_size as a guideline. Increasing the initial-size-of-user-log-files value will prevent expansion of user log files from occurring during update processing.

    Important

    Before you increase the initial-size-of-user-log-files value, re-estimate the size as explained in 6.12 Estimating the size of the system log files.

  3. Terminate the HADB server.

    Terminate the HADB server by executing the adbstop command.

  4. Change the server definition.

    Increase the initial-size-of-user-log-files value specified for the adb_log_usrfile_size operand in the server definition.

  5. Start the HADB server.

    Execute the adbstart command to start the HADB server.

Note

For details about the adb_log_usrfile_size operand in the server definition, see the adb_log_usrfile_size operand in 7.2.3 Operands related to system logs (set format).