Hitachi

Hitachi Advanced Database Setup and Operation Guide


8.10.3 Moving back the time in the server machine's OS

Read 8.10.1 Notes (when changing the OS time), and then move back the time in the OS of the server machine on which the HADB server is installed by performing either of the following procedures:

Organization of this subsection

(1) Setting the clock back in the OS by a few seconds to a few minutes (when you can wait for the amount of time that was moved back)

Procedure

  1. Terminate the HADB server normally.

    Execute the adbstop command to terminate the HADB server normally. For details about the adbstop command, see 10.2.2 Terminating the HADB server.

  2. Set back the clock in the server machine's OS.

    Move back the time in the OS on the server machine on which the HADB server is installed.

  3. Wait for at least the amount of time that was moved back (the amount of the time change), and then start the HADB server.

    Wait for at least the amount of time by which the time was changed, and then execute the adbstart command to start the HADB server. For example, if you have moved back the time in the OS by 10 minutes, wait for at least 10 minutes, and then start the HADB server.

    For details about the adbstart command, see 10.2.1 Starting the HADB server.

You have now set back the clock in the server machine's OS.

If you are setting back the clock by an amount of time that is too long to wait for, see (2) Starting the HADB server immediately (when you cannot wait for the amount of time that was moved back).

(2) Starting the HADB server immediately (when you cannot wait for the amount of time that was moved back)

Procedure

  1. Terminate the HADB server normally.

    Execute the adbstop command to terminate the HADB server normally. For details about the adbstop command, see 10.2.2 Terminating the HADB server.

  2. Back up the spool directory in the server directory.

    After the HADB server has terminated normally, use either of the following methods to back up all directories and files that are stored in the spool directory in the server directory.($ADBDIR/spool directory):

    • Executing the operating system's cp command

    • Executing the adbinfoget command

    For details about the adbinfoget command, see adbinfoget (Collect Troubleshooting Information) in the manual HADB Command Reference.

  3. Make a backup of the output destination directory for statistics log files.

    If you omit the adb_sta_log_path operand in the server definition, ignore this step and go to the next step.

    If you specify the adb_sta_log_path operand in the server definition, you need to back up the statistics log files. Use either of the following methods to back up all files that are stored in the output destination directory for statistics log files specified in the adb_sta_log_path operand:

    • Executing the operating system's cp command

    • Executing the adbinfoget command

    For details about the adbinfoget command, see adbinfoget (Collect Troubleshooting Information) in the manual HADB Command Reference.

    For details about the adb_sta_log_path operand in the server definition, see the description of the adb_sta_log_path operand in 7.2.7 Operands related to statistical information (set format).

  4. Delete the information that was output by the HADB server.

    After you have made a backup, execute the adbinfosweep command to delete the information that was output by the HADB server. For details about the adbinfosweep command, see adbinfosweep (Delete Troubleshooting Information) in the manual HADB Command Reference.

    Important

    If you do not execute the adbinfosweep command, the first time the HADB server is started after the time in the server machine's OS is moved back, the HADB server and HADB clients might behave in an unexpected way. Before you execute the adbinfosweep command, back up the information that was output by the HADB server, because executing this command will delete the output information.

  5. Delete the spool directory from the server directory.

    Use an OS command to delete the spool directory ($ADBDIR/spool directory) from the server directory.

  6. Delete the statistics log files.

    If you omit the adb_sta_log_path operand in the server definition, ignore this step and go to the next step.

    If you specify the adb_sta_log_path operand in the server definition, you need to delete the statistics log files. Delete all files that are stored in the output destination directory for statistics log files specified in the adb_sta_log_path operand. For details about how to delete statistics log files, see (4) Deleting statistics log files in 10.10.5 Using the statistics log files.

  7. Create an empty spool directory.

    Use an OS command to create an empty spool directory under the server directory.

  8. Move back the time in the server machine's OS.

    After you have deleted the information that was output by the HADB server, move back the time in the OS of the server machine on which the HADB server is installed.

  9. Start the HADB server.

    After you have moved back the time in the server machine's OS, execute the adbstart command to start the HADB server. For details about the adbstart command, see 10.2.1 Starting the HADB server.

You have now moved back the time in the server machine's OS.